I am following the instructions on the wiki https://wiki.postgresql.org/wiki/Binary_Replication_Tutorial#PITR.2C_Warm_Standby.2C_Hot_Standby.2C_and_Streaming_Replication using the "10 minute" version of the setup. On the master I have postgresql.conf wal_level = hot_standby max_wal_senders = 3 checkpoint_segments = 32 wal_keep_segments = 64 pg_hba.conf host replication all 10.X.X.X/32 trust # (I set up a trust for now.. I created the user on the master) BTW the wiki should tell you to create the user. on the slave I have postgresql.conf hot_standby = on recovery.conf standby_mode = 'on' primary_conninfo = 'host=10.X.X.X port=5432 user=replication' I followed the instructions for rsyncing the files over and restarted the slave the log file says. 2012-06-24 06:51:13 UTC [25274]: [2-1] user=,db= LOG: received fast shutdown request 2012-06-24 06:51:13 UTC [25274]: [3-1] user=,db= LOG: aborting any active transactions 2012-06-24 06:51:13 UTC [25278]: [2-1] user=,db= FATAL: terminating walreceiver process due to administrator command 2012-06-24 06:51:13 UTC [25276]: [1-1] user=,db= LOG: shutting down 2012-06-24 06:51:13 UTC [25276]: [2-1] user=,db= LOG: database system is shut down 2012-06-24 06:51:15 UTC [25324]: [1-1] user=,db= LOG: database system was shut down in recovery at 2012-06-24 06:51:13 UTC 2012-06-24 06:51:15 UTC [25325]: [1-1] user=[unknown],db=[unknown] LOG: incomplete startup packet 2012-06-24 06:51:15 UTC [25324]: [2-1] user=,db= LOG: entering standby mode 2012-06-24 06:51:15 UTC [25324]: [3-1] user=,db= LOG: consistent recovery state reached at 2F/670248B0 2012-06-24 06:51:15 UTC [25324]: [4-1] user=,db= LOG: redo starts at 2F/67024820 2012-06-24 06:51:15 UTC [25324]: [5-1] user=,db= LOG: record with incorrect prev-link 2E/F1024868 at 2F/670248B0 2012-06-24 06:51:15 UTC [25323]: [1-1] user=,db= LOG: database system is ready to accept read only connections 2012-06-24 06:51:15 UTC [25328]: [1-1] user=,db= LOG: streaming replication successfully connected to primary I created a table in the master and added some rows and that table doesn't show up in the slave. I see that both the sender and the receivers are running so I am at a loss as to what is going on. Any clues? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
