pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDesparate: Lost WAL files
7+ messages / 3 participants
[nested] [flat]
* Desparate: Lost WAL files
@ 2005-07-06 18:35 Richard Doust <rdoust@mac.com>
0 siblings, 2 replies; 7+ messages in thread
From: Richard Doust @ 2005-07-06 18:35 UTC (permalink / raw)
To: pgsql-admin
Hi.
Can anyone please tell me what I can do? I've lost the contents of my
pg_xlog directory and postmaster is failing to start because it can't
find a valid checkpoint record. It had done a clean shutdown, so I
know that the dbms should be okay if I could just restart it.
I'm in a desparate situation. It's a production database.
Thanks in advance.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Desparate: Lost WAL files
@ 2005-07-06 18:51 Joshua D. Drake <jd@commandprompt.com>
parent: Richard Doust <rdoust@mac.com>
1 sibling, 1 reply; 7+ messages in thread
From: Joshua D. Drake @ 2005-07-06 18:51 UTC (permalink / raw)
To: Richard Doust <rdoust@mac.com>; +Cc: pgsql-admin
Richard Doust wrote:
> Hi.
> Can anyone please tell me what I can do? I've lost the contents of my
> pg_xlog directory and postmaster is failing to start because it can't
> find a valid checkpoint record. It had done a clean shutdown, so I know
> that the dbms should be okay if I could just restart it.
> I'm in a desparate situation. It's a production database.
Well the exact error would be good just in case but you may be able to
use pg_resetxlog to get the machine back up. However you will have no
idea what state the database itself is in.
You need to restore from backup.
Sincerely,
Joshua D. Drake
> Thanks in advance.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Desparate: Lost WAL files
@ 2005-07-06 18:53 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Richard Doust <rdoust@mac.com>
1 sibling, 0 replies; 7+ messages in thread
From: Bruce Momjian @ 2005-07-06 18:53 UTC (permalink / raw)
To: Richard Doust <rdoust@mac.com>; +Cc: pgsql-admin
Richard Doust wrote:
> Hi.
> Can anyone please tell me what I can do? I've lost the contents of my
> pg_xlog directory and postmaster is failing to start because it can't
> find a valid checkpoint record. It had done a clean shutdown, so I
> know that the dbms should be okay if I could just restart it.
> I'm in a desparate situation. It's a production database.
> Thanks in advance.
Have you tried pg_resetxlog to get it started?
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Desparate: Lost WAL files
@ 2005-07-06 18:59 Richard Doust <rdoust@mac.com>
parent: Joshua D. Drake <jd@commandprompt.com>
0 siblings, 1 reply; 7+ messages in thread
From: Richard Doust @ 2005-07-06 18:59 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: pgsql-admin
Thanks guys.
I didn't know about this command.
It worked like a charm.
Like I said, I had done a clean shutdown.
Thanks again.
On Jul 6, 2005, at 11:51 AM, Joshua D. Drake wrote:
> Richard Doust wrote:
>
>> Hi.
>> Can anyone please tell me what I can do? I've lost the contents of
>> my pg_xlog directory and postmaster is failing to start because
>> it can't find a valid checkpoint record. It had done a clean
>> shutdown, so I know that the dbms should be okay if I could just
>> restart it.
>> I'm in a desparate situation. It's a production database.
>>
>
> Well the exact error would be good just in case but you may be able
> to use pg_resetxlog to get the machine back up. However you will
> have no
> idea what state the database itself is in.
>
> You need to restore from backup.
>
> Sincerely,
>
> Joshua D. Drake
>
>
>
>
>> Thanks in advance.
>> ---------------------------(end of
>> broadcast)---------------------------
>> TIP 1: subscribe and unsubscribe commands go to
>> majordomo@postgresql.org
>>
>
>
> --
> Your PostgreSQL solutions company - Command Prompt, Inc.
> 1.800.492.2240
> PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
> Managed Services, Shared and Dedicated Hosting
> Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Desparate: Lost WAL files
@ 2005-07-06 19:03 Joshua D. Drake <jd@commandprompt.com>
parent: Richard Doust <rdoust@mac.com>
0 siblings, 1 reply; 7+ messages in thread
From: Joshua D. Drake @ 2005-07-06 19:03 UTC (permalink / raw)
To: Richard Doust <rdoust@mac.com>; +Cc: Bruce Momjian <pgman@candle.pha.pa.us>; pgsql-admin
Richard Doust wrote:
> Thanks guys.
> I didn't know about this command.
> It worked like a charm.
> Like I said, I had done a clean shutdown.
If you did a clean shutdown and you lost those files you quite likely
have a very serious problem. You should investigate your hardware. Files
don't just "disappear".
Sincerely,
Joshua D. Drake
> Thanks again.
>
> On Jul 6, 2005, at 11:51 AM, Joshua D. Drake wrote:
>
>> Richard Doust wrote:
>>
>>> Hi.
>>> Can anyone please tell me what I can do? I've lost the contents of
>>> my pg_xlog directory and postmaster is failing to start because it
>>> can't find a valid checkpoint record. It had done a clean shutdown,
>>> so I know that the dbms should be okay if I could just restart it.
>>> I'm in a desparate situation. It's a production database.
>>>
>>
>> Well the exact error would be good just in case but you may be able
>> to use pg_resetxlog to get the machine back up. However you will have no
>> idea what state the database itself is in.
>>
>> You need to restore from backup.
>>
>> Sincerely,
>>
>> Joshua D. Drake
>>
>>
>>
>>
>>> Thanks in advance.
>>> ---------------------------(end of
>>> broadcast)---------------------------
>>> TIP 1: subscribe and unsubscribe commands go to
>>> majordomo@postgresql.org
>>>
>>
>>
>> --
>> Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
>> PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
>> Managed Services, Shared and Dedicated Hosting
>> Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
>>
--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Desparate: Lost WAL files
@ 2005-07-06 19:08 Richard Doust <rdoust@mac.com>
parent: Joshua D. Drake <jd@commandprompt.com>
0 siblings, 1 reply; 7+ messages in thread
From: Richard Doust @ 2005-07-06 19:08 UTC (permalink / raw)
To: Joshua D. Drake <jd@commandprompt.com>; +Cc: pgsql-admin
Well, actually, (he said sheepishly) I deleted the WAL files myself.
A bit of stupidity.
On Jul 6, 2005, at 12:03 PM, Joshua D. Drake wrote:
> Richard Doust wrote:
>
>> Thanks guys.
>> I didn't know about this command.
>> It worked like a charm.
>> Like I said, I had done a clean shutdown.
>>
>
> If you did a clean shutdown and you lost those files you quite likely
> have a very serious problem. You should investigate your hardware.
> Files don't just "disappear".
>
> Sincerely,
>
> Joshua D. Drake
>
>
>
>> Thanks again.
>> On Jul 6, 2005, at 11:51 AM, Joshua D. Drake wrote:
>>
>>> Richard Doust wrote:
>>>
>>>
>>>> Hi.
>>>> Can anyone please tell me what I can do? I've lost the contents
>>>> of my pg_xlog directory and postmaster is failing to start
>>>> because it can't find a valid checkpoint record. It had done a
>>>> clean shutdown, so I know that the dbms should be okay if I
>>>> could just restart it.
>>>> I'm in a desparate situation. It's a production database.
>>>>
>>>>
>>>
>>> Well the exact error would be good just in case but you may be
>>> able to use pg_resetxlog to get the machine back up. However you
>>> will have no
>>> idea what state the database itself is in.
>>>
>>> You need to restore from backup.
>>>
>>> Sincerely,
>>>
>>> Joshua D. Drake
>>>
>>>
>>>
>>>
>>>
>>>> Thanks in advance.
>>>> ---------------------------(end of
>>>> broadcast)---------------------------
>>>> TIP 1: subscribe and unsubscribe commands go to
>>>> majordomo@postgresql.org
>>>>
>>>>
>>>
>>>
>>> --
>>> Your PostgreSQL solutions company - Command Prompt, Inc.
>>> 1.800.492.2240
>>> PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
>>> Managed Services, Shared and Dedicated Hosting
>>> Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
>>>
>>>
>
>
> --
> Your PostgreSQL solutions company - Command Prompt, Inc.
> 1.800.492.2240
> PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
> Managed Services, Shared and Dedicated Hosting
> Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Desparate: Lost WAL files
@ 2005-07-06 19:09 Joshua D. Drake <jd@commandprompt.com>
parent: Richard Doust <rdoust@mac.com>
0 siblings, 0 replies; 7+ messages in thread
From: Joshua D. Drake @ 2005-07-06 19:09 UTC (permalink / raw)
To: Richard Doust <rdoust@mac.com>; +Cc: pgsql-admin
Richard Doust wrote:
> Well, actually, (he said sheepishly) I deleted the WAL files myself. A
> bit of stupidity.
Doh! In the future it would probably be wise to *not* do that ;)
Sincerely,
Joshua D. Drake
>
> On Jul 6, 2005, at 12:03 PM, Joshua D. Drake wrote:
>
>> Richard Doust wrote:
>>
>>> Thanks guys.
>>> I didn't know about this command.
>>> It worked like a charm.
>>> Like I said, I had done a clean shutdown.
>>>
>>
>> If you did a clean shutdown and you lost those files you quite likely
>> have a very serious problem. You should investigate your hardware.
>> Files don't just "disappear".
>>
>> Sincerely,
>>
>> Joshua D. Drake
>>
>>
>>
>>> Thanks again.
>>> On Jul 6, 2005, at 11:51 AM, Joshua D. Drake wrote:
>>>
>>>> Richard Doust wrote:
>>>>
>>>>
>>>>> Hi.
>>>>> Can anyone please tell me what I can do? I've lost the contents
>>>>> of my pg_xlog directory and postmaster is failing to start
>>>>> because it can't find a valid checkpoint record. It had done a
>>>>> clean shutdown, so I know that the dbms should be okay if I
>>>>> could just restart it.
>>>>> I'm in a desparate situation. It's a production database.
>>>>>
>>>>>
>>>>
>>>> Well the exact error would be good just in case but you may be
>>>> able to use pg_resetxlog to get the machine back up. However you
>>>> will have no
>>>> idea what state the database itself is in.
>>>>
>>>> You need to restore from backup.
>>>>
>>>> Sincerely,
>>>>
>>>> Joshua D. Drake
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>> Thanks in advance.
>>>>> ---------------------------(end of
>>>>> broadcast)---------------------------
>>>>> TIP 1: subscribe and unsubscribe commands go to
>>>>> majordomo@postgresql.org
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Your PostgreSQL solutions company - Command Prompt, Inc.
>>>> 1.800.492.2240
>>>> PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
>>>> Managed Services, Shared and Dedicated Hosting
>>>> Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
>>>>
>>>>
>>
>>
>> --
>> Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
>> PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
>> Managed Services, Shared and Dedicated Hosting
>> Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
>>
--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2005-07-06 19:09 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-07-06 18:35 Desparate: Lost WAL files Richard Doust <rdoust@mac.com>
2005-07-06 18:51 ` Joshua D. Drake <jd@commandprompt.com>
2005-07-06 18:59 ` Richard Doust <rdoust@mac.com>
2005-07-06 19:03 ` Joshua D. Drake <jd@commandprompt.com>
2005-07-06 19:08 ` Richard Doust <rdoust@mac.com>
2005-07-06 19:09 ` Joshua D. Drake <jd@commandprompt.com>
2005-07-06 18:53 ` Bruce Momjian <pgman@candle.pha.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox