Re: [GENERAL] Failing to recover after panic shutdown

2008-06-04 Thread Magnus Hagander
Per Lauvås wrote: > Hi, and thanks for the replies! > > OK. I think we will reconsider this. The backup procedure was set up > a few years ago. I have personally made several point in time > recoveries using this technique (for testing purposes), and it works. > But I guess an undesirable side-eff

Re: [GENERAL] Failing to recover after panic shutdown

2008-06-04 Thread Per Lauvås
CTED] > Sent: 3. juni 2008 15:47 > To: Per Lauvås > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Failing to recover after panic shutdown > > Per Lauvås wrote: > > Hi > > > > I am running Postgres 8.2 on Windows 2003 server SP2. > > > >

Re: [GENERAL] Failing to recover after panic shutdown

2008-06-04 Thread Magnus Hagander
t: 3. juni 2008 15:47 > To: Per Lauvås > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Failing to recover after panic shutdown > > Per Lauvås wrote: > > Hi > > > > I am running Postgres 8.2 on Windows 2003 server SP2. > > > > Every now and then (2-

Re: [GENERAL] Failing to recover after panic shutdown

2008-06-03 Thread Per Lauvås
] Sent: 3. juni 2008 15:47 To: Per Lauvås Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Failing to recover after panic shutdown Per Lauvås wrote: > Hi > > I am running Postgres 8.2 on Windows 2003 server SP2. > > Every now and then (2-3 times a year) our Postgres service i

Re: [GENERAL] Failing to recover after panic shutdown

2008-06-03 Thread Magnus Hagander
Per Lauvås wrote: > Hi > > I am running Postgres 8.2 on Windows 2003 server SP2. > > Every now and then (2-3 times a year) our Postgres service is down > and we need to manually start it. This is what we find: > > In log when going down: > 2008-06-02 13:40:02 PANIC: could not open file > "pg_xl

[GENERAL] Failing to recover after panic shutdown

2008-06-03 Thread Per Lauvås
Hi I am running Postgres 8.2 on Windows 2003 server SP2. Every now and then (2-3 times a year) our Postgres service is down and we need to manually start it. This is what we find: In log when going down: 2008-06-02 13:40:02 PANIC: could not open file "pg_xlog/0001001C0081" (log fi