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

Re: Emergency backup question.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Danni Coy <rgcoy(at)midcoast(dot)com(dot)au>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Emergency backup question.
Date: 2001-11-20 15:21:04
Message-ID: (view raw or whole thread)
Lists: pgsql-novice
Danni Coy <rgcoy(at)midcoast(dot)com(dot)au> writes:
> Greetings Basically I have a problem here. I lost my linux system due to 
> hard drive corruption I managed to back up my /var/lib/pgsql/data/base 
> directory to an ordinary tarball before I redid the system. Is there any 
> way to use this data as a backup?

If you only backed up that subdirectory, and not all of
/var/lib/pgsql/data, I'm afraid you're out of luck.  You needed the
pg_log files too.

> and what is the proceedure for a proper backup?

Routine pg_dump runs are recommended.  You might care to consult the
discussion of backup procedures in the Administrator's Guide,
or the updated version in development docs,

			regards, tom lane

In response to


pgsql-novice by date

Next:From: Josh BerkusDate: 2001-11-20 16:35:42
Subject: Re: If function available?
Previous:From: Francisco ReyesDate: 2001-11-20 15:17:33
Subject: If function available?

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