Restoring from a file system level backup - Mailing list pgsql-admin

From Jonathan Daniels
Subject Restoring from a file system level backup
Date
Msg-id 20001108185141.7709.qmail@web2902.mail.yahoo.com
Whole thread Raw
List pgsql-admin
Hi,

I need to restore from a filesystem level backup, the
reason being that I cannot exeute an sql dump due to
the postmaster not executing. Therefore I have decided
to reinstall postgres (I am running Linux Mandrake 7
as an OS). I just want to ensure that the following is
correct:

copy all files (pg_ and tbl_ prefixed files, logfile
and PG_VERSION) from the database directory

copy pg_log from the /var/lib/data directory (I copied
all files from here just in case).

I have done the above but am not sure what the
procedure is for restoring from a file system level
backup. Any ideas?

Thanks in advance,

Jonathan Daniels

__________________________________________________
Do You Yahoo!?
Thousands of Stores.  Millions of Products.  All in one Place.
http://shopping.yahoo.com/

pgsql-admin by date:

Previous
From: lbottorff@harveycounty.com
Date:
Subject: Errors building Postgres on NT
Next
From: "mike focosi"
Date:
Subject: Increasing 8k row limit