YEEEEEEEESSSS!!!!!!! It worked!!! I thought that I did as you said the first time. I had to remove postmaster.pid. It seems that the pid för postmaster when the system last was up was stored there.
GREAT!!!!! Thank you very much! /nisse On Wed, 2002-10-23 at 01:23, Oliver Elphick wrote: > On Tue, 2002-10-22 at 20:06, Nils-Erik Svangård wrote: > > Hi! > > > > Yesterday my main hd gave up (40gig up in smoke), /usr and /lib was on > > another hd so they where saved. > > in /lib there seems like the data from my postgressql databas survived, > > but now when I have reinstalled and try to access the data it says data > > test2 doesnt exist (thats the old database). > > I have just copied the old files over the new installation, since its > > the same version och postgres. Im running unstable, doesanyone know how > > to use the data again?? > > You need to copy the whole tree of $PGDATA. (By default, that is in > /var/lib/postgres, unless you set it to be somewhere else.) Its > contents should look like this: > > olly@linda$ sudo ls $PGDATA > PG_VERSION global pg_hba.conf pg_xlog postmaster.opts > base pg_clog pg_ident.conf postgresql.conf postmaster.pid > > > > To be clear, the database includes eseential files at the top level of > $PGDATA; you cannot simply copy part of the tree. > > > Your backup procedures should include the use of pg_dumpall to copy the > database either to another machine, or to a tape, or at least to another > disk in the same machine. > > -- > Oliver Elphick [EMAIL PROTECTED] > Isle of Wight, UK > http://www.lfix.co.uk/oliver > GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C > ======================================== > "I press toward the mark for the prize of the high > calling of God in Christ Jesus." > Philippians 3:14 > > -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
