On Apr 21, 2011, at 6:35 PM, Tiruvenkatasamy Baskaran wrote: > Got the following messages in log file on the master DB. > LOG: database system was shut down at 2011-04-01 14:27:37 IST > LOG: database system is ready to accept connections > LOG: autovacuum launcher started > LOG: replication connection authorized: user=postgres host=10.128.16.52 > port=52324 > cp: cannot stat > `/usr/local/pgsql/data/pg_xlogarch/000000010000000000000001': No such file or > directory > LOG: archive command failed with exit code 1 > Got the following messages in log file on the slave DB. > LOG: database system was interrupted; last known up at 2011-03-24 12:29:15 > IST > LOG: entering standby mode > cp: cannot stat `/usr/local/pgsql/data/pg_xlogarch/000000010000000000000002': > No such file or directory > LOG: redo starts at 0/2000020 > LOG: record with zero length at 0/20000B0 > cp: cannot stat `/usr/local/pgsql/data/pg_xlogarch/000000010000000000000002': > No such file or directory > LOG: streaming replication successfully connected to primary > FATAL: the database system is starting up > FATAL: the database system is starting up > Master DB is running and able to query table. But slave DB is not running and > not able to query table.
Please confirm if you have made Slave DB using PITR/Hot Backup of Master. Also, please let me know the steps which you have followed. Thanks & Regards, Vibhor Kumar EnterpriseDB Corporation The Enterprise PostgreSQL Company vibhor.ku...@enterprisedb.com Blog:http://vibhork.blogspot.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
