Hello
I am having a problem with all slaves...i am not sure it's a bug or my side configuration problem..
When ever i am restarting postgresql slave (Service postgresql restart - made a script) or even just stopping and starting a postgresql slave.. it displays a a message, although slave get's started and working fine...
server starting
cp: cannot stat `/usr/local/pgsql/data/pg_xlogarch/000000010000000300000026': No such file or directory
cp: cannot stat `/usr/local/postgres/data/pg_xlogarch/000000010000000300000026': No such file or directory
May 24 20:55:34 db-slave2 postgres[25223]: [2-1] LOG:Â received fast shutdown request
May 24 20:55:34 db-slave2 postgres[25223]: [3-1] LOG:Â aborting any active transactions
May 24 20:55:34 db-slave2 postgres[25229]: [3-1] FATAL:Â terminating walreceiver process due to administrator command
May 24 20:55:34 db-slave2 postgres[25226]: [1-1] LOG:Â shutting down
May 24 20:55:35 db-slave2 postgres[25226]: [2-1] LOG:Â database system is shut down
May 24 20:55:36 db-slave2 postgres[26769]: [1-1] LOG:Â database system was shut down in recovery at 2011-05-24 20:55:35 IST
May 24 20:55:36 db-slave2 postgres[26769]: [2-1] LOG:Â entering standby mode
May 24 20:55:36 db-slave2 postgres[26769]: [3-1] LOG:Â consistent recovery state reached at 3/2628F3F0
May 24 20:55:36 db-slave2 postgres[26769]: [4-1] LOG:Â redo starts at 3/2628F360
May 24 20:55:36 db-slave2 postgres[26769]: [5-1] LOG:Â invalid record length at 3/2628F3F0
May 24 20:55:36 db-slave2 postgres[26768]: [1-1] LOG:Â database system is ready to accept read only connections
May 24 20:55:36 db-slave2 postgres[26774]: [2-1] LOG:Â streaming replication successfully connected to primary
Pl. give any solution for this.
Postgresql Ver. 9.0.3
OS: CentOS release 5.3 (Final)
Kernel: 2.6.18-128.el5xen
pg_controldata
pg_control version number:ÂÂÂÂÂÂÂÂÂÂÂ 903
Catalog version number:ÂÂÂÂÂÂÂÂÂÂÂÂÂÂ 201008051
Database system identifier:ÂÂÂÂÂÂÂÂÂÂ 5572911747953590263
Database cluster state:ÂÂÂÂÂÂÂÂÂÂÂÂÂÂ in archive recovery
pg_control last modified:ÂÂÂÂÂÂÂÂÂÂÂÂ Tue 24 May 2011 08:55:36 PM IST
Latest checkpoint location:ÂÂÂÂÂÂÂÂÂÂ 3/2628F398
Prior checkpoint location:ÂÂÂÂÂÂÂÂÂÂÂ 3/2628F398
Latest checkpoint's REDO location:ÂÂÂ 3/2628F360
Latest checkpoint's TimeLineID:ÂÂÂÂÂÂ 1
Latest checkpoint's NextXID:ÂÂÂÂÂÂÂÂÂ 0/1102911
Latest checkpoint's NextOID:ÂÂÂÂÂÂÂÂÂ 1346139
Latest checkpoint's NextMultiXactId:Â 2
Latest checkpoint's NextMultiOffset:Â 3
Latest checkpoint's oldestXID:ÂÂÂÂÂÂÂ 654
Latest checkpoint's oldestXID's DB:ÂÂ 1
Latest checkpoint's oldestActiveXID:Â 1102911
Time of latest checkpoint:ÂÂÂÂÂÂÂÂÂÂÂ Tue 24 May 2011 08:53:52 PM IST
Minimum recovery ending location:ÂÂÂÂ 3/2628F3F0
Backup start location:ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂ 0/0
Current wal_level setting:ÂÂÂÂÂÂÂÂÂÂÂ hot_standby
Current max_connections setting:ÂÂÂÂÂ 5000
Current max_prepared_xacts setting:ÂÂ 0
Current max_locks_per_xact setting:ÂÂ 64
Maximum data alignment:ÂÂÂÂÂÂÂÂÂÂÂÂÂÂ 8
Database block size:ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂ 8192
Blocks per segment of large relation: 131072
WAL block size:ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂ 8192
Bytes per WAL segment:ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂ 16777216
Maximum length of identifiers:ÂÂÂÂÂÂÂ 64
Maximum columns in an index:ÂÂÂÂÂÂÂÂÂ 32
Maximum size of a TOAST chunk:ÂÂÂÂÂÂÂ 1996
Date/time type storage:ÂÂÂÂÂÂÂÂÂÂÂÂÂÂ 64-bit integers
Float4 argument passing:ÂÂÂÂÂÂÂÂÂÂÂÂÂ by value
Float8 argument passing:ÂÂÂÂÂÂÂÂÂÂÂÂÂ by value
--
Manish Singh
