replication

[ymsaout]

Hi,

Is there something to manage replication ? do you plan to accept PR for that ?

Thank you.

[davidak]

Yes. I set up streaming replication (async) with this role and it works just fine.

Have a look at the vars:

https://github.com/ANXS/postgresql/blob/master/defaults/main.yml#L203

I used this tutorial for orientation on the config and the instructions for the initial backup.

https://www.howtoforge.com/tutorial/postgresql-replication-on-ubuntu-15-04/

On the standby i executed this commands manually:

systemctl stop postgresql
rm -rf /var/lib/postgresql/9.6/main/
su - postgres
pg_basebackup -h master -D /var/lib/postgresql/9.6/main -U replication -v --progress --checkpoint=fast --xlog-method=stream -R
cd /var/lib/postgresql/9.6/main
vim recovery.conf
+ trigger_file = '/tmp/postgresql.trigger.5432'

exit
systemctl start postgresql

(Used Ubuntu 16.04 and Ansible 2.2)

[trotro]

Hi,
I have a playbook to enable streaming replication. But It’s not idempotent, because the replication is done from scratch. If someone is willing to help, I can work on it.

[egmont1227]

You can find repmgr replication feature in #424

[github-actions]

This issue has been marked 'stale' due to lack of recent activity. If there is no further activity, the issue will be closed in another 30 days. Thank you for your contribution!

[github-actions]

This issue has been closed due to inactivity. If you feel this is in error, please reopen the issue or file a new issue with the relevant details.