From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
Cc: | Ralf Tschiersch <ralf(at)net-service(dot)de>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: pg_log deleted - what to do? |
Date: | 2000-10-01 18:01:51 |
Message-ID: | 200010011801.OAA09849@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Can the user rename the /data directory, do initdb, save the pg_log
file, move the old /data back into place, add the new pg_log, and do a
backup of his data?
I thought this would work, but am not sure.
> Ralf Tschiersch writes:
>
> > don't ask why, but what can I do if I have pg_log accidently deleted? How
> > to recover? the postmaster starts, I can connect do databases, but neiter
> > tables nor sequences are found! Postgres is 6.5.3 on linux 2.2.10.
>
> You have pretty much lost. Deleting pg_log is almost like deleting the
> data itself. You make backups, don't you?
>
> --
> Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/
>
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Ralf Tschiersch | 2000-10-01 18:14:39 | Re: pg_log deleted - what to do? |
Previous Message | Peter Eisentraut | 2000-10-01 17:54:08 | Re: pg_log deleted - what to do? |