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

Re: pg_log deleted - what to do?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Ralf Tschiersch <ralf(at)net-service(dot)de>, 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 20:24:34
Message-ID: 200010012024.QAA16380@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Also, I never liked the name pg_log.  Though descriptive, it was too
tempting a name for administrators to delete.  Write-ahead log will not
use that file, so it should go away in 7.1.

> OK, please try pg_dump or pg_dumpall.  The database will not usable, but
> may be backup-able.
> 
> 
> > 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
> > > 
> > 
> > 
> 
> 
> -- 
>   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
> 


-- 
  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

In response to

Responses

pgsql-admin by date

Next:From: Ralf TschierschDate: 2000-10-01 20:31:40
Subject: Re: pg_log deleted - what to do?
Previous:From: Bruce MomjianDate: 2000-10-01 20:14:25
Subject: Re: pg_log deleted - what to do?

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