Jeff Janes wrote: > This is what I get in the log from the attempted restart: > > PST LOG: database system was interrupted; last known up at 2014-11-25 > 15:40:33 PST > PST LOG: database system was not properly shut down; automatic recovery in > progress > PST LOG: redo starts at 84/EF000080 > PST LOG: record with zero length at 84/EF09AE18 > PST LOG: redo done at 84/EF09AD28 > PST LOG: last completed transaction was at log time 2014-11-25 > 15:42:09.173599-08 > PST LOG: checkpoint starting: end-of-recovery immediate > PST LOG: checkpoint complete: wrote 103 buffers (0.2%); 0 transaction log > file(s) added, 246 removed, 7 recycled; write=0.002 s, sync=0.020 s, > total=0.526 s; sync files=51, longest=0.003 s, average=0.000 s > PST FATAL: could not create file "base/16416/59288": File exists
Maybe fire up pg_xlogdump to see what xlog record references that relfilenode. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers