On Fri, Sep 19, 2014 at 8:07 AM, Alvaro Herrera <alvhe...@2ndquadrant.com> wrote:
> Can you paste the pg_controldata output please? > pg_controldata output as follows: pg_control version number: 937 Catalog version number: 201306121 Database system identifier: 6023658189132429183 Database cluster state: in production pg_control last modified: Fri Sep 19 12:09:05 2014 Latest checkpoint location: 2D3/5DB461C0 Prior checkpoint location: 2D3/5D08D0D0 Latest checkpoint's REDO location: 2D3/5D68EFE0 Latest checkpoint's REDO WAL file: 00000001000002D30000005D Latest checkpoint's TimeLineID: 1 Latest checkpoint's PrevTimeLineID: 1 Latest checkpoint's full_page_writes: on Latest checkpoint's NextXID: 0/10882952 Latest checkpoint's NextOID: 3443291 Latest checkpoint's NextMultiXactId: 3622064 Latest checkpoint's NextMultiOffset: 4294172074 Latest checkpoint's oldestXID: 1673 Latest checkpoint's oldestXID's DB: 1 Latest checkpoint's oldestActiveXID: 0 Latest checkpoint's oldestMultiXid: 1 Latest checkpoint's oldestMulti's DB: 1 Time of latest checkpoint: Fri Sep 19 12:06:35 2014 Fake LSN counter for unlogged rels: 0/1 Minimum recovery ending location: 0/0 Min recovery ending loc's timeline: 0 Backup start location: 0/0 Backup end location: 0/0 End-of-backup record required: no Current wal_level setting: minimal Current max_connections setting: 100 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 > Also, what files are there in pg_multixact/offsets/ ? > Currently there are about 56 files in pg_multixact/offsets/. 0000 0002 0004 0006 0008 000A 000C 000E 0010 0012 0014 0016 0018 001A 001C 001E 0020 0022 0024 0026 0028 002A 002C 002E 0030 0032 0034 0036 0001 0003 0005 0007 0009 000B 000D 000F 0011 0013 0015 0017 0019 001B 001D 001F 0021 0023 0025 0027 0029 002B 002D 002F 0031 0033 0035 0037 Regards...
