In 9.3.5, if I set up archiving, create a database, pull a base
backup, look at the clock, drop database, stop the server, rm -rf
datadir, put back the backup, edit recovery.conf:
cd /tmp; initdb foo
edit postgresql.conf with archive_mode = on, archive_command,
max_wal_senders = 1, wal_level = hot_standby
edit pg_hba.conf
pg_ctl start
psql -c 'create database db1'
psql -c 'checkpoint'
pg_basebackup -D /tmp/back1
date
Di 25. Nov 17:00:31 CET 2014
psql -c 'drop database db1'
pg_ctl stop
rm -rf foo; cp -a back1 foo
restore_command = 'cp /tmp/%f %p'
standby_mode = on
recovery_target_time = '2014-11-25 17:00:31'
... and then restart the server, I get:
postgres=# \c db1
FATAL: database "db1" does not exist
DETAIL: The database subdirectory "base/70262" is missing.
2014-11-25 16:11:22 CET [15225-1] LOG: database system was interrupted; last known up at 2014-11-25 15:56:51 CET
2014-11-25 16:11:22 CET [15225-2] LOG: creating missing WAL directory "pg_xlog/archive_status"
2014-11-25 16:11:22 CET [15225-3] LOG: entering standby mode
2014-11-25 16:11:22 CET [15225-4] LOG: restored log file "000000010000000D0000007B" from archive
2014-11-25 16:11:22 CET [15225-5] LOG: redo starts at D/7B000028
2014-11-25 16:11:22 CET [15225-6] LOG: consistent recovery state reached at D/7B0000F0
2014-11-25 16:11:22 CET [15225-7] LOG: restored log file "000000010000000D0000007C" from archive
2014-11-25 16:11:22 CET [15225-8] LOG: recovery stopping before commit of transaction 60681, time 2014-11-25
15:59:57.071137+01
2014-11-25 16:11:22 CET [15225-9] LOG: redo done at D/7C001110
cp: cannot stat '/tmp/00000002.history': No such file or directory
2014-11-25 16:11:22 CET [15225-10] LOG: selected new timeline ID: 2
cp: cannot stat '/tmp/00000001.history': No such file or directory
2014-11-25 16:11:23 CET [15225-11] LOG: archive recovery complete
2014-11-25 16:11:23 CET [15236-1] [unknown]@[unknown] LOG: incomplete startup packet
2014-11-25 16:11:23 CET [15238-1] LOG: autovacuum launcher started
2014-11-25 16:11:23 CET [15224-1] LOG: database system is ready to accept connections
2014-11-25 16:11:41 CET [15268-1] postgres@db1 FATAL: database "db1" does not exist
2014-11-25 16:11:41 CET [15268-2] postgres@db1 DETAIL: The database subdirectory "base/70262" is missing.
db1 is registered in pg_database, but the directory is missing on
disk.
(The actual log here is from a server with a longer history, but the
problem is reproducible in a freshly initdb'ed server as well.)
Christoph
--
cb@df7cb.de | http://www.df7cb.de/
