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]
