Restoring from a file system level backup

From: Jonathan Daniels <jed2000(at)rocketmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Restoring from a file system level backup
Date: 2000-11-08 18:51:41
Message-ID: 20001108185141.7709.qmail@web2902.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

Browse pgsql-admin by date

  From Date Subject
Next Message mike focosi 2000-11-08 19:41:30 Increasing 8k row limit
Previous Message lbottorff 2000-11-08 14:37:44 Errors building Postgres on NT