From: | Ralf Tschiersch <ralf(at)net-service(dot)de> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: pg_log deleted - what to do? |
Date: | 2000-10-01 18:14:39 |
Message-ID: | Pine.LNX.4.10.10010012008380.22011-100000@dilbert.net-service.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi -
I've tried this already, with no success. More details:
the "postgres"-database shows:
postgres=> \d
Couldn't find any tables, sequences or indices!
postgres=> select * from pg_database;
datname |datdba|encoding|datpath
----------+------+--------+----------
template1 | 26| 0|template1
(1 row)
Whew - where are the databases?
Connecting a (former) existing database shows:
dbx1=> \d
Couldn't find any tables, sequences or indices!
dbx1=> select * from gp;
kid|typ|var|data
---+---+---+----
(0 rows)
But the File is there!
-rw------- 1 postgres daemon 16384 Sep 30 03:46 data/base/dbx1/gp
It's horrible. I know that I had to do a backup, but things change fast!
Its seems that Postgres did a "reset" and does not know that there is
pretty much it could deliver. Setting up a fres installation with the
exact table and properties ist okay, but copying the
data/base/dbname-Files into this new place does not the trick.
Thanks for your care...
Ralf
On Sun, 1 Oct 2000, Bruce Momjian wrote:
> 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 | Peter Eisentraut | 2000-10-01 19:16:41 | Re: pg_log deleted - what to do? |
Previous Message | Bruce Momjian | 2000-10-01 18:01:51 | Re: pg_log deleted - what to do? |