| From: | Nick <nboutelier(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Error trying to set up streaming replication |
| Date: | 2012-03-27 01:40:47 |
| Message-ID: | 147bd3f7-64ed-47a3-a21d-29f2a9071fe2@er9g2000vbb.googlegroups.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I followed the instructions from
http://packetcloud.net/2010/12/09/setting-up-streaming-replication-in-postgresql-9-0/
When I start the standby I get this...
LOG: database system was shut down in recovery at 2012-03-26 17:36:32
PDT
LOG: entering standby mode
cp: cannot stat `/var/lib/postgresql/9.1/main/pg_wal/
000000010000007600000019': No such file or directory
LOG: consistent recovery state reached at 76/19000078
LOG: record with zero length at 76/19000078
LOG: database system is ready to accept read only connections
cp: cannot stat `/var/lib/postgresql/9.1/main/pg_wal/
000000010000007600000019': No such file or directory
LOG: streaming replication successfully connected to primary
LOG: incomplete startup packet
And the standby never gets updated by the master.
Any ideas whats going wrong?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Travers | 2012-03-27 02:33:34 | Re: postgresql commit. |
| Previous Message | leaf_yxj | 2012-03-27 01:22:20 | postgresql commit. |