Re: Suddenly all tables were gone

On Fri, Jan 3, 2014 at 2:42 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

Here you go. The problem database has already been dropped and re-created, BTW:

(0)(0j)[root@staging /var/lib/pgsql/9.3]# pg_controldata
pg_control version number:            937
Catalog version number:               201306121
Database system identifier:           5962287500209577471
Database cluster state:               in production
pg_control last modified:             Fri 03 Jan 2014 03:07:25 PM EST
Latest checkpoint location:           2FC/BB000028
Prior checkpoint location:            2FC/B9000028
Latest checkpoint's REDO location:    2FC/BB000028
Latest checkpoint's REDO WAL file:    00000001000002FC000000BB
Latest checkpoint's TimeLineID:       1
Latest checkpoint's PrevTimeLineID:   1
Latest checkpoint's full_page_writes: on
Latest checkpoint's NextXID:          0/32280314
Latest checkpoint's NextOID:          2491780
Latest checkpoint's NextMultiXactId:  78785
Latest checkpoint's NextMultiOffset:  110
Latest checkpoint's oldestXID:        1791
Latest checkpoint's oldestXID's DB:   1
Latest checkpoint's oldestActiveXID:  0
Latest checkpoint's oldestMultiXid:   78746
Latest checkpoint's oldestMulti's DB: 0
Time of latest checkpoint:            Fri 03 Jan 2014 03:07:25 PM EST
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

Moshe Jacobson
Manager of Systems Engineering, Nead Werx Inc.
2323 Cumberland Parkway · Suite 201 · Atlanta, GA 30339

“Quality is not an act, it is a habit.” — Aristotle