Skip site navigation (1) Skip section navigation (2)

Re: problems after pg_resetxlog

From: Miguel <mmiranda(at)123(dot)com(dot)sv>
To: Miguel <mmiranda(at)123(dot)com(dot)sv>
Cc: pgsql general list <pgsql-general(at)postgresql(dot)org>
Subject: Re: problems after pg_resetxlog
Date: 2005-10-29 00:14:21
Message-ID: 4362BEDD.1090602@123.com.sv (view raw or flat)
Thread:
Lists: pgsql-general
Miguel wrote:

> Tom Lane wrote:
>
>> Increasing the WAL start address might help (see the pg_resetxlog man
>> page).  Realize that you're probably going to be dealing with corrupted
>> data, however :-(
>>
>>             regards, tom lane
>>
>>  
>>
Ops, foget the last email, i reread the man, this is what i have to do:

shiva2 pg_xlog # ls -l
total 180448
-rw-------  1 postgres postgres 16777216 Oct 28 18:05 
00000001000000980000001A
-rw-------  1 postgres postgres 16777216 Oct 28 18:07 
00000001000000980000001B
-rw-------  1 postgres postgres 16777216 Oct 28 18:10 
00000001000000980000001C
-rw-------  1 postgres postgres 16777216 Oct 28 18:10 
00000001000000980000001D
-rw-------  1 postgres postgres 16777216 Oct 28 17:25 
00000001000000980000001E
-rw-------  1 postgres postgres 16777216 Oct 28 17:28 
00000001000000980000001F
-rw-------  1 postgres postgres 16777216 Oct 28 17:37 
000000010000009800000020
-rw-------  1 postgres postgres 16777216 Oct 28 17:51 
000000010000009800000021
-rw-------  1 postgres postgres 16777216 Oct 28 17:53 
000000010000009800000022
-rw-------  1 postgres postgres 16777216 Oct 28 17:46 
000000010000009800000023
-rw-------  1 postgres postgres 16777216 Oct 28 17:49 
000000010000009800000024
drwx------  2 postgres postgres     4096 Apr 22  2005 archive_status


So :

pg_resetxlog -l 0x01, 0x98, 0x25 dir_data

Is this ok?

In response to

pgsql-general by date

Next:From: basel novoDate: 2005-10-29 00:50:52
Subject: Re: newbie question: reading sql commands from script
Previous:From: Douglas McNaughtDate: 2005-10-28 23:59:32
Subject: Re: Installation trouble

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group