Created
April 28, 2016 16:08
-
-
Save vadv/a842878b2378035c5229dde0efcabba3 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-bash-4.3$ #rmgr: XLOG len (rec/tot): 72/ 104, tx: 0, lsn: 0/01844EA8, prev 0/01844E40, bkp: 0000, desc: checkpoint: redo 0/1844EA8; tli 1; prev tli 1; fpw true; xid 0/1951; oid 16403; multi 1; offset 0; oldest xid 1929 in DB 1; oldest multi 1 in DB 1; oldest running xid 0; shutdown | |
-bash-4.3$ mv data/global/pg_control data/global/pg_control.back | |
-bash-4.3$ touch^Cata/global/pg_control | |
-bash-4.3$ mv data/global/pg_control.back data/global/pg_control | |
-bash-4.3$ pg_controldata data | |
pg_control version number: 942 | |
Catalog version number: 201409291 | |
Database system identifier: 6278627349384791518 | |
Database cluster state: shut down | |
pg_control last modified: Чт 28 апр 2016 18:21:46 | |
Latest checkpoint location: 0/1844EA8 | |
Prior checkpoint location: 0/1844E40 | |
Latest checkpoint's REDO location: 0/1844EA8 | |
Latest checkpoint's REDO WAL file: 000000010000000000000001 | |
Latest checkpoint's TimeLineID: 1 | |
Latest checkpoint's PrevTimeLineID: 1 | |
Latest checkpoint's full_page_writes: on | |
Latest checkpoint's NextXID: 0/1951 | |
Latest checkpoint's NextOID: 16403 | |
Latest checkpoint's NextMultiXactId: 1 | |
Latest checkpoint's NextMultiOffset: 0 | |
Latest checkpoint's oldestXID: 1929 | |
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: Чт 28 апр 2016 18:21:46 | |
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 wal_log_hints setting: off | |
Current max_connections setting: 100 | |
Current max_worker_processes setting: 8 | |
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 | |
Size of a large-object chunk: 2048 | |
Date/time type storage: 64-bit integers | |
Float4 argument passing: by value | |
Float8 argument passing: by value | |
Data page checksum version: 0 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment