| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: 9.2 recovery/startup problems |
| Date: | 2014-11-26 13:06:00 |
| Message-ID: | 20141126130600.GK1639@alvin.alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Palle Girgensohn | 2014-11-26 13:06:36 | Re: [pgsql-packagers] Palle Girgensohn's ICU patch |
| Previous Message | Robert Haas | 2014-11-26 13:02:19 | Re: superuser() shortcuts |