pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_xlog folder lost !
4+ messages / 3 participants
[nested] [flat]
* pg_xlog folder lost !
@ 2004-06-15 10:15 Rajesh Kumar Mallah <mallah@trade-india.com>
2004-06-15 10:32 ` Re: pg_xlog folder lost ! Bjoern Metzdorf <bm@turtle-entertainment.de>
0 siblings, 1 reply; 4+ messages in thread
From: Rajesh Kumar Mallah @ 2004-06-15 10:15 UTC (permalink / raw)
To: pgsql-admin
Hi,
The harddrive on which i had linked pg_xlog
has been lost. I have all other folders except that
which are in a seperate drive are present.
Can i get my data back using pg_resetxlog ?
Any Help will be greatly appreciated.
Regds
Mallah.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_xlog folder lost !
2004-06-15 10:15 pg_xlog folder lost ! Rajesh Kumar Mallah <mallah@trade-india.com>
@ 2004-06-15 10:32 ` Bjoern Metzdorf <bm@turtle-entertainment.de>
0 siblings, 0 replies; 4+ messages in thread
From: Bjoern Metzdorf @ 2004-06-15 10:32 UTC (permalink / raw)
To: Rajesh Kumar Mallah <mallah@trade-india.com>; +Cc: pgsql-admin
Rajesh Kumar Mallah wrote:
>
> Hi,
>
> The harddrive on which i had linked pg_xlog
> has been lost. I have all other folders except that
> which are in a seperate drive are present.
>
> Can i get my data back using pg_resetxlog ?
Give it a try: create the xlog folder again and run pg_resetxlog.
Regards,
Bjoern
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_xlog folder lost !
@ 2004-06-15 11:08 mallah@trade-india.com
2004-06-15 23:32 ` Re: pg_xlog folder lost ! Rajesh Kumar Mallah <mallah@trade-india.com>
0 siblings, 1 reply; 4+ messages in thread
From: mallah@trade-india.com @ 2004-06-15 11:08 UTC (permalink / raw)
To: bm@turtle-entertainment.de; +Cc: pgsql-admin
> Rajesh Kumar Mallah wrote:
>>
>> Hi,
>>
>> The harddrive on which i had linked pg_xlog
>> has been lost. I have all other folders except that
>> which are in a seperate drive are present.
>>
>> Can i get my data back using pg_resetxlog ?
>
> Give it a try: create the xlog folder again and run pg_resetxlog.
Thanks. My hosting company is yet to bring the machine
up. I have tried this process in my local machine and it
works.
I think this process only gets the data till last checkpoint
reliably . I hope its correct.
Regds
Mallah
>
> Regards,
> Bjoern
-----------------------------------------
Over 1,00,000 exporters are waiting for your order! Click below to get
in touch with leading Indian exporters listed in the premier
trade directory Exporters Yellow Pages.
http://www.trade-india.com/dyn/gdh/eyp/
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: pg_xlog folder lost !
2004-06-15 11:08 Re: pg_xlog folder lost ! mallah@trade-india.com
@ 2004-06-15 23:32 ` Rajesh Kumar Mallah <mallah@trade-india.com>
0 siblings, 0 replies; 4+ messages in thread
From: Rajesh Kumar Mallah @ 2004-06-15 23:32 UTC (permalink / raw)
To: pgsql-admin; +Cc: bm@turtle-entertainment.de
I could start the postmaster after doing
pg_resetxlog .
The docs tell that a dump reload of the database should be done.
I am trying to do that by starting a new postmaster in a seprate port
and using pg_dumpall
while i do that i get some minor errors like
ALTER USER arvind SET search_path TO 'erp';
ERROR: schema "erp" does not exist
and some ownership related errors like
SET SESSION AUTHORIZATION 'rt_user';
SET
........
........
CREATE INDEX attachments1 ON attachments USING btree (parent);
ERROR: must be owner of relation attachments
Following are the grant sequence on table attachments
obtained by grepping the output
REVOKE ALL ON TABLE attachments FROM PUBLIC;
REVOKE ALL ON TABLE attachments FROM rt_user;
GRANT ALL ON TABLE attachments TO postgres WITH GRANT OPTION;
GRANT ALL ON TABLE attachments TO rt_user;
is it some bug with pg_dumpall/pg_dump ?
i am using 7.4.1 btw , shall now try with 7.4.3
Regds
Mallah.
mallah@trade-india.com wrote:
>>Rajesh Kumar Mallah wrote:
>>
>>
>>>Hi,
>>>
>>>The harddrive on which i had linked pg_xlog
>>>has been lost. I have all other folders except that
>>>which are in a seperate drive are present.
>>>
>>>Can i get my data back using pg_resetxlog ?
>>>
>>>
>>Give it a try: create the xlog folder again and run pg_resetxlog.
>>
>>
>
>
>Thanks. My hosting company is yet to bring the machine
>up. I have tried this process in my local machine and it
>works.
>
>I think this process only gets the data till last checkpoint
>reliably . I hope its correct.
>
>Regds
>Mallah
>
>
>
>
>>Regards,
>>Bjoern
>>
>>
>
>
>
>-----------------------------------------
>Over 1,00,000 exporters are waiting for your order! Click below to get
>in touch with leading Indian exporters listed in the premier
>trade directory Exporters Yellow Pages.
>http://www.trade-india.com/dyn/gdh/eyp/
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2004-06-15 23:32 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-06-15 10:15 pg_xlog folder lost ! Rajesh Kumar Mallah <mallah@trade-india.com>
2004-06-15 10:32 ` Bjoern Metzdorf <bm@turtle-entertainment.de>
2004-06-15 11:08 Re: pg_xlog folder lost ! mallah@trade-india.com
2004-06-15 23:32 ` Rajesh Kumar Mallah <mallah@trade-india.com>
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