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
havefollowed.
Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor.kumar@enterprisedb.com
Blog:http://vibhork.blogspot.com