Re: streaming replication trigger file - Mailing list pgsql-general

From jenopob
Subject Re: streaming replication trigger file
Date
Msg-id 1310008061441-4559669.post@n5.nabble.com
Whole thread Raw
In response to Re: streaming replication trigger file  (Sanjay Rao <srao@noida.interrasystems.com>)
List pgsql-general
I think you should make the base database the same

6. Make a base backup by copying the primary server's data directory to the
standby server.
$ psql -c "SELECT pg_start_backup('label', true)"
$ rsync -a ${PGDATA}/ standby:/srv/pgsql/standby/ --exclude postmaster.pid
$ psql -c "SELECT pg_stop_backup()"


--
View this message in context:
http://postgresql.1045698.n5.nabble.com/streaming-replication-trigger-file-tp4494129p4559669.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: Joe Lester
Date:
Subject: failed archive command
Next
From: Brendan Prouty
Date:
Subject: Request for help - Does anyone in Seattle need a Postgres job?