|
Thank you Mat, here are the additional infos : 1)
All of the three servers (main+2 replicas) are virtual on VMware Esxi 5.0 2)
Each server is on a different storage and on different vmware hosts 3)
The Log of the primary are with no errors 4)
Attached : pg_controldata output, postgres log, and /var/log/messages 5)
Fsck on the colume containing the database folders reports no error : [root@pg64prod_rep /]# umount /dev/sdb1 [root@pg64prod_rep /]# fsck -n /dev/sdb1 fsck from util-linux-ng 2.17.2 e2fsck 1.41.12 (17-May-2010) /dev/sdb1 has gone 193 days without being checked, check forced. Pass 1: Checking inodes, blocks, and sizes Pass 2: Checking directory structure Pass 3: Checking directory connectivity Pass 4: Checking reference counts Pass 5: Checking group summary information /dev/sdb1: 7886/13107200 files (8.3% non-contiguous), 38818825/52428119 blocks Marco Da: desmodemone [mailto:desmodemone@xxxxxxxxx]
Hello, please, could you post some details about? Your replica are on the same storage as the primary ? Are virtual or physical ? hypervisor type? Could you attach / post /var/log/messages and postgres log ? Could you attach / post pg_controldata output of the replica ? Did you verify the filesystem integrity of the replica ? Are the log of the primary without errors ? Thank you very much Mat |
pg_control version number: 937 Catalog version number: 201306121 Database system identifier: 5964553868552862446 Database cluster state: in archive recovery pg_control last modified: Sun 09 Feb 2014 12:42:12 PM CET Latest checkpoint location: E8C/99F03F90 Prior checkpoint location: E8C/76E09AE0 Latest checkpoint's REDO location: E8C/7C419D98 Latest checkpoint's REDO WAL file: 0000000100000E8C0000007C Latest checkpoint's TimeLineID: 1 Latest checkpoint's PrevTimeLineID: 1 Latest checkpoint's full_page_writes: on Latest checkpoint's NextXID: 0/1050904477 Latest checkpoint's NextOID: 88459706 Latest checkpoint's NextMultiXactId: 36567 Latest checkpoint's NextMultiOffset: 58369 Latest checkpoint's oldestXID: 870508363 Latest checkpoint's oldestXID's DB: 16433 Latest checkpoint's oldestActiveXID: 1050904477 Latest checkpoint's oldestMultiXid: 7469 Latest checkpoint's oldestMulti's DB: 0 Time of latest checkpoint: Sun 09 Feb 2014 12:33:45 PM CET Fake LSN counter for unlogged rels: 0/1 Minimum recovery ending location: E8C/A1FFF558 Min recovery ending loc's timeline: 1 Backup start location: 0/0 Backup end location: 0/0 End-of-backup record required: no Current wal_level setting: hot_standby Current max_connections setting: 230 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 Data page checksum version: 0
Attachment:
postgresql-2014-02-09_000000.log
Description: postgresql-2014-02-09_000000.log
Attachment:
messages
Description: messages
-- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
