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 -- c...@df7cb.de | http://www.df7cb.de/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
