The files belonging to this database system will be owned by user "ioltas". This user must also own the server process. The database cluster will be initialized with locale "C". The default database encoding has accordingly been set to "SQL_ASCII". The default text search configuration will be set to "english". Data page checksums are disabled. creating directory /home/ioltas/git/postgres/src/bin/pg_rewind/tmp_testthst/data_master ... ok creating subdirectories ... ok selecting default max_connections ... 100 selecting default shared_buffers ... 128MB selecting dynamic shared memory implementation ... posix creating configuration files ... ok creating template1 database in /home/ioltas/git/postgres/src/bin/pg_rewind/tmp_testthst/data_master/base/1 ... ok initializing pg_authid ... ok initializing dependencies ... ok creating system views ... ok loading system objects' descriptions ... ok creating collations ... ok No usable system locales were found. Use the option "--debug" to see details. creating conversions ... ok creating dictionaries ... ok setting privileges on built-in objects ... ok creating information schema ... ok loading PL/pgSQL server-side language ... ok vacuuming database template1 ... ok copying template1 to template0 ... ok copying template1 to postgres ... ok Sync to disk skipped. The data directory might become corrupt if the operating system crashes. Success. You can now start the database server using: /home/ioltas/git/postgres/tmp_install/home/ioltas/pgsql/bin/pg_ctl -D /home/ioltas/git/postgres/src/bin/pg_rewind/tmp_testthst/data_master -l logfile start waiting for server to start..........LOG: database system was shut down at 2015-06-19 13:22:28 JST LOG: MultiXact member wraparound protections are now enabled LOG: database system is ready to accept connections done server started waiting for server to start..............FATAL: the database system is starting up .LOG: database system was interrupted; last known up at 2015-06-19 13:23:49 JST LOG: entering standby mode LOG: redo starts at 0/2000060 LOG: consistent recovery state reached at 0/2000130 LOG: database system is ready to accept read only connections LOG: started streaming WAL from primary at 0/3000000 on timeline 1 done server started LOG: received promote request FATAL: terminating walreceiver process due to administrator command LOG: invalid record length at 0/30EB480 LOG: redo done at 0/30EB410 LOG: last completed transaction was at log time 2015-06-19 13:25:10.714845+09 server promoting LOG: selected new timeline ID: 2 LOG: archive recovery complete LOG: MultiXact member wraparound protections are now enabled LOG: database system is ready to accept connections LOG: received fast shutdown request LOG: aborting any active transactions LOG: shutting down waiting for server to shut down.....LOG: database system is shut down done server stopped LOG: received fast shutdown request LOG: aborting any active transactions LOG: shutting down waiting for server to shut down....LOG: database system is shut down done server stopped The servers diverged at WAL position 0/30EB480 on timeline 1. Rewinding from last common checkpoint at 0/30EB410 on timeline 1 backup_label.old (COPY) base/1/12209_fsm (COPY) base/1/12209_vm (COPY) base/1/12214_fsm (COPY) base/1/12214_vm (COPY) base/1/12219_fsm (COPY) base/1/12219_vm (COPY) base/1/12224_fsm (COPY) base/1/12224_vm (COPY) base/1/12229_fsm (COPY) base/1/12229_vm (COPY) base/1/12234_fsm (COPY) base/1/12234_vm (COPY) base/1/1247_fsm (COPY) base/1/1247_vm (COPY) base/1/1249_fsm (COPY) base/1/1249_vm (COPY) base/1/1255_fsm (COPY) base/1/1255_vm (COPY) base/1/1259_fsm (COPY) base/1/1259_vm (COPY) base/1/1417_vm (COPY) base/1/1418_vm (COPY) base/1/2328_vm (COPY) base/1/2336_vm (COPY) base/1/2600_fsm (COPY) base/1/2600_vm (COPY) base/1/2601_fsm (COPY) base/1/2601_vm (COPY) base/1/2602_fsm (COPY) base/1/2602_vm (COPY) base/1/2603_fsm (COPY) base/1/2603_vm (COPY) base/1/2604_vm (COPY) base/1/2605_fsm (COPY) base/1/2605_vm (COPY) base/1/2606_fsm (COPY) base/1/2606_vm (COPY) base/1/2607_fsm (COPY) base/1/2607_vm (COPY) base/1/2608_fsm (COPY) base/1/2608_vm (COPY) base/1/2609_fsm (COPY) base/1/2609_vm (COPY) base/1/2610_fsm (COPY) base/1/2610_vm (COPY) base/1/2611_vm (COPY) base/1/2612_fsm (COPY) base/1/2612_vm (COPY) base/1/2613_vm (COPY) base/1/2615_fsm (COPY) base/1/2615_vm (COPY) base/1/2616_fsm (COPY) base/1/2616_vm (COPY) base/1/2617_fsm (COPY) base/1/2617_vm (COPY) base/1/2618_fsm (COPY) base/1/2618_vm (COPY) base/1/2619_fsm (COPY) base/1/2619_vm (COPY) base/1/2620_vm (COPY) base/1/2753_fsm (COPY) base/1/2753_vm (COPY) base/1/2830_vm (COPY) base/1/2832_vm (COPY) base/1/2834_vm (COPY) base/1/2836_vm (COPY) base/1/2838_fsm (COPY) base/1/2838_vm (COPY) base/1/2840_fsm (COPY) base/1/2840_vm (COPY) base/1/2995_vm (COPY) base/1/3079_fsm (COPY) base/1/3079_vm (COPY) base/1/3118_vm (COPY) base/1/3256_vm (COPY) base/1/3330_fsm (COPY) base/1/3330_vm (COPY) base/1/3456_fsm (COPY) base/1/3456_vm (COPY) base/1/3466_vm (COPY) base/1/3501_vm (COPY) base/1/3541_fsm (COPY) base/1/3541_vm (COPY) base/1/3576_vm (COPY) base/1/3596_vm (COPY) base/1/3598_vm (COPY) base/1/3600_fsm (COPY) base/1/3600_vm (COPY) base/1/3601_fsm (COPY) base/1/3601_vm (COPY) base/1/3602_fsm (COPY) base/1/3602_vm (COPY) base/1/3603_fsm (COPY) base/1/3603_vm (COPY) base/1/3764_fsm (COPY) base/1/3764_vm (COPY) base/1/826_vm (COPY) base/1/pg_filenode.map (COPY) base/12373/12209_fsm (COPY) base/12373/12209_vm (COPY) base/12373/12214_fsm (COPY) base/12373/12214_vm (COPY) base/12373/12219_fsm (COPY) base/12373/12219_vm (COPY) base/12373/12224_fsm (COPY) base/12373/12224_vm (COPY) base/12373/12229_fsm (COPY) base/12373/12229_vm (COPY) base/12373/12234_fsm (COPY) base/12373/12234_vm (COPY) base/12373/1247_fsm (COPY) base/12373/1247_vm (COPY) base/12373/1249_fsm (COPY) base/12373/1249_vm (COPY) base/12373/1255_fsm (COPY) base/12373/1255_vm (COPY) base/12373/1259_fsm (COPY) base/12373/1259_vm (COPY) base/12373/1417_vm (COPY) base/12373/1418_vm (COPY) base/12373/2328_vm (COPY) base/12373/2336_vm (COPY) base/12373/2600_fsm (COPY) base/12373/2600_vm (COPY) base/12373/2601_fsm (COPY) base/12373/2601_vm (COPY) base/12373/2602_fsm (COPY) base/12373/2602_vm (COPY) base/12373/2603_fsm (COPY) base/12373/2603_vm (COPY) base/12373/2604_vm (COPY) base/12373/2605_fsm (COPY) base/12373/2605_vm (COPY) base/12373/2606_fsm (COPY) base/12373/2606_vm (COPY) base/12373/2607_fsm (COPY) base/12373/2607_vm (COPY) base/12373/2608_fsm (COPY) base/12373/2608_vm (COPY) base/12373/2609_fsm (COPY) base/12373/2609_vm (COPY) base/12373/2610_fsm (COPY) base/12373/2610_vm (COPY) base/12373/2611_vm (COPY) base/12373/2612_fsm (COPY) base/12373/2612_vm (COPY) base/12373/2613_vm (COPY) base/12373/2615_fsm (COPY) base/12373/2615_vm (COPY) base/12373/2616_fsm (COPY) base/12373/2616_vm (COPY) base/12373/2617_fsm (COPY) base/12373/2617_vm (COPY) base/12373/2618_fsm (COPY) base/12373/2618_vm (COPY) base/12373/2619_fsm (COPY) base/12373/2619_vm (COPY) base/12373/2620_vm (COPY) base/12373/2753_fsm (COPY) base/12373/2753_vm (COPY) base/12373/2830_vm (COPY) base/12373/2832_vm (COPY) base/12373/2834_vm (COPY) base/12373/2836_vm (COPY) base/12373/2838_fsm (COPY) base/12373/2838_vm (COPY) base/12373/2840_fsm (COPY) base/12373/2840_vm (COPY) base/12373/2995_vm (COPY) base/12373/3079_fsm (COPY) base/12373/3079_vm (COPY) base/12373/3118_vm (COPY) base/12373/3256_vm (COPY) base/12373/3330_fsm (COPY) base/12373/3330_vm (COPY) base/12373/3456_fsm (COPY) base/12373/3456_vm (COPY) base/12373/3466_vm (COPY) base/12373/3501_vm (COPY) base/12373/3541_fsm (COPY) base/12373/3541_vm (COPY) base/12373/3576_vm (COPY) base/12373/3596_vm (COPY) base/12373/3598_vm (COPY) base/12373/3600_fsm (COPY) base/12373/3600_vm (COPY) base/12373/3601_fsm (COPY) base/12373/3601_vm (COPY) base/12373/3602_fsm (COPY) base/12373/3602_vm (COPY) base/12373/3603_fsm (COPY) base/12373/3603_vm (COPY) base/12373/3764_fsm (COPY) base/12373/3764_vm (COPY) base/12373/826_vm (COPY) base/12373/pg_filenode.map (COPY) base/12378/12209_fsm (COPY) base/12378/12209_vm (COPY) base/12378/12214_fsm (COPY) base/12378/12214_vm (COPY) base/12378/12219_fsm (COPY) base/12378/12219_vm (COPY) base/12378/12224_fsm (COPY) base/12378/12224_vm (COPY) base/12378/12229_fsm (COPY) base/12378/12229_vm (COPY) base/12378/12234_fsm (COPY) base/12378/12234_vm (COPY) base/12378/1247_fsm (COPY) base/12378/1247_vm (COPY) base/12378/1249_fsm (COPY) base/12378/1249_vm (COPY) base/12378/1255_fsm (COPY) base/12378/1255_vm (COPY) base/12378/1259_fsm (COPY) base/12378/1259_vm (COPY) base/12378/1417_vm (COPY) base/12378/1418_vm (COPY) base/12378/16396_fsm (COPY) base/12378/2328_vm (COPY) base/12378/2336_vm (COPY) base/12378/2600_fsm (COPY) base/12378/2600_vm (COPY) base/12378/2601_fsm (COPY) base/12378/2601_vm (COPY) base/12378/2602_fsm (COPY) base/12378/2602_vm (COPY) base/12378/2603_fsm (COPY) base/12378/2603_vm (COPY) base/12378/2604_vm (COPY) base/12378/2605_fsm (COPY) base/12378/2605_vm (COPY) base/12378/2606_fsm (COPY) base/12378/2606_vm (COPY) base/12378/2607_fsm (COPY) base/12378/2607_vm (COPY) base/12378/2608_fsm (COPY) base/12378/2608_vm (COPY) base/12378/2609_fsm (COPY) base/12378/2609_vm (COPY) base/12378/2610_fsm (COPY) base/12378/2610_vm (COPY) base/12378/2611_vm (COPY) base/12378/2612_fsm (COPY) base/12378/2612_vm (COPY) base/12378/2613_vm (COPY) base/12378/2615_fsm (COPY) base/12378/2615_vm (COPY) base/12378/2616_fsm (COPY) base/12378/2616_vm (COPY) base/12378/2617_fsm (COPY) base/12378/2617_vm (COPY) base/12378/2618_fsm (COPY) base/12378/2618_vm (COPY) base/12378/2619_fsm (COPY) base/12378/2619_vm (COPY) base/12378/2620_vm (COPY) base/12378/2753_fsm (COPY) base/12378/2753_vm (COPY) base/12378/2830_vm (COPY) base/12378/2832_vm (COPY) base/12378/2834_vm (COPY) base/12378/2836_vm (COPY) base/12378/2838_fsm (COPY) base/12378/2838_vm (COPY) base/12378/2840_fsm (COPY) base/12378/2840_vm (COPY) base/12378/2995_vm (COPY) base/12378/3079_fsm (COPY) base/12378/3079_vm (COPY) base/12378/3118_vm (COPY) base/12378/3256_vm (COPY) base/12378/3330_fsm (COPY) base/12378/3330_vm (COPY) base/12378/3456_fsm (COPY) base/12378/3456_vm (COPY) base/12378/3466_vm (COPY) base/12378/3501_vm (COPY) base/12378/3541_fsm (COPY) base/12378/3541_vm (COPY) base/12378/3576_vm (COPY) base/12378/3596_vm (COPY) base/12378/3598_vm (COPY) base/12378/3600_fsm (COPY) base/12378/3600_vm (COPY) base/12378/3601_fsm (COPY) base/12378/3601_vm (COPY) base/12378/3602_fsm (COPY) base/12378/3602_vm (COPY) base/12378/3603_fsm (COPY) base/12378/3603_vm (COPY) base/12378/3764_fsm (COPY) base/12378/3764_vm (COPY) base/12378/826_vm (COPY) base/12378/pg_filenode.map (COPY) base/12378/pg_internal.init (COPY) global/1136_fsm (COPY) global/1136_vm (COPY) global/1213_fsm (COPY) global/1213_vm (COPY) global/1214_fsm (COPY) global/1214_vm (COPY) global/1260_fsm (COPY) global/1260_vm (COPY) global/1261_vm (COPY) global/2396_fsm (COPY) global/2396_vm (COPY) global/2846_vm (COPY) global/2964_vm (COPY) global/2966_vm (COPY) global/3592_vm (COPY) global/4060_vm (COPY) global/6000_vm (COPY) global/pg_control (COPY) global/pg_filenode.map (COPY) global/pg_internal.init (COPY) pg_clog/0000 (COPY) pg_hba.conf (COPY) pg_ident.conf (COPY) pg_multixact/members/0000 (COPY) pg_multixact/offsets/0000 (COPY) pg_notify/0000 (COPY) pg_stat/db_0.stat (COPY) pg_stat/db_12378.stat (COPY) pg_stat/global.stat (COPY) pg_subtrans/0000 (COPY) pg_xlog/000000010000000000000002 (COPY) pg_xlog/000000010000000000000003 (COPY) pg_xlog/00000002.history (COPY) pg_xlog/000000020000000000000003 (COPY) pg_xlog/archive_status/000000010000000000000002.done (COPY) postgresql.auto.conf (COPY) postgresql.conf (COPY) recovery.done (COPY) base/12378/16396 (COPY_TAIL) blk 0 base/12378/1249 (NONE) blk 30 blk 44 base/12378/1259 (NONE) blk 0 base/12378/16384 (NONE) blk 0 base/12378/2610 (NONE) blk 2 base/12378/16390 (TRUNCATE) blk 0 pg_xlog/000000010000000000000001 (REMOVE) base/12378/16396_vm (REMOVE) base/12378/16390_fsm (REMOVE) Done! waiting for server to start....LOG: database system was interrupted while in recovery at log time 2015-06-19 13:25:28 JST HINT: If this has occurred more than once some data might be corrupted and you might need to choose an earlier recovery target. FATAL: the database system is starting up .LOG: entering standby mode LOG: redo starts at 0/30EB3D8 LOG: consistent recovery state reached at 0/30EB758 LOG: invalid record length at 0/30EB7C8 LOG: database system is ready to accept read only connections FATAL: could not connect to the primary server: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/unpioFZBO2/.s.PGSQL.65433"? done server started LOG: received immediate shutdown request The files belonging to this database system will be owned by user "ioltas". This user must also own the server process. The database cluster will be initialized with locale "C". The default database encoding has accordingly been set to "SQL_ASCII". The default text search configuration will be set to "english". Data page checksums are disabled. creating directory /home/ioltas/git/postgres/src/bin/pg_rewind/tmp_testthst/data_master ... ok creating subdirectories ... ok selecting default max_connections ... 100 selecting default shared_buffers ... 128MB selecting dynamic shared memory implementation ... posix creating configuration files ... ok creating template1 database in /home/ioltas/git/postgres/src/bin/pg_rewind/tmp_testthst/data_master/base/1 ... ok initializing pg_authid ... ok initializing dependencies ... ok creating system views ... ok loading system objects' descriptions ... ok creating collations ... ok No usable system locales were found. Use the option "--debug" to see details. creating conversions ... ok creating dictionaries ... ok setting privileges on built-in objects ... ok creating information schema ... ok loading PL/pgSQL server-side language ... ok vacuuming database template1 ... ok copying template1 to template0 ... ok copying template1 to postgres ... ok Sync to disk skipped. The data directory might become corrupt if the operating system crashes. Success. You can now start the database server using: /home/ioltas/git/postgres/tmp_install/home/ioltas/pgsql/bin/pg_ctl -D /home/ioltas/git/postgres/src/bin/pg_rewind/tmp_testthst/data_master -l logfile start waiting for server to start.......LOG: database system was shut down at 2015-06-19 13:26:57 JST LOG: MultiXact member wraparound protections are now enabled LOG: database system is ready to accept connections done server started waiting for server to start.............LOG: database system was interrupted; last known up at 2015-06-19 13:27:40 JST LOG: entering standby mode LOG: redo starts at 0/2000028 LOG: consistent recovery state reached at 0/2000130 LOG: database system is ready to accept read only connections LOG: started streaming WAL from primary at 0/3000000 on timeline 1 done server started LOG: received promote request FATAL: terminating walreceiver process due to administrator command LOG: invalid record length at 0/30EB480 LOG: redo done at 0/30EB410 LOG: last completed transaction was at log time 2015-06-19 13:29:21.928295+09 server promoting LOG: selected new timeline ID: 2 LOG: archive recovery complete LOG: MultiXact member wraparound protections are now enabled LOG: database system is ready to accept connections LOG: received fast shutdown request LOG: aborting any active transactions LOG: shutting down waiting for server to shut down....LOG: database system is shut down done server stopped The servers diverged at WAL position 0/30EB480 on timeline 1. Rewinding from last common checkpoint at 0/30EB410 on timeline 1 Done! waiting for server to start.....LOG: database system was interrupted while in recovery at log time 2015-06-19 13:29:27 JST HINT: If this has occurred more than once some data might be corrupted and you might need to choose an earlier recovery target. FATAL: the database system is starting up .FATAL: the database system is starting up .LOG: entering standby mode LOG: redo starts at 0/30EB3D8 LOG: invalid record length at 0/3110180 LOG: started streaming WAL from primary at 0/3000000 on timeline 2 LOG: consistent recovery state reached at 0/31101B8 LOG: database system is ready to accept read only connections done server started LOG: received immediate shutdown request LOG: unexpected EOF on standby connection LOG: received immediate shutdown request