Skip to content

Instantly share code, notes, and snippets.

@sebastianwebber

sebastianwebber/base_backup.sh

Last active December 23, 2016 16:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save sebastianwebber/e411ae7e0c7a73136c239fd3a3f5e837 to your computer and use it in GitHub Desktop.
Save sebastianwebber/e411ae7e0c7a73136c239fd3a3f5e837 to your computer and use it in GitHub Desktop.
Download ZIP
pg_basebackup for slave
Raw
base_backup.sh
## postgres=# create user replicator replication password 'teste';
pg_basebackup -U replicator -h 192.168.100.100 -D /var/lib/pgsql/9.3/data --write-recovery-conf --xlog-method=stream --progress --verbose --checkpoint=fast
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment