From: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
---|---|
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 16:41:40 |
Message-ID: | web-510107@davinci.ethosmedia.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Danni,
> > 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?
Not really. As Tom said, without some of the other files, a backup of
just the /base subdirectory is nigh on useless.
If, however, this was mission-critical information requiring many hours
of your time to recover, you can recover a certain amount of your data
by reading the tables directly using a text editor. However, this is
very labor-intensive and tends to only allow you to recover the integer,
numeric, and short VARCHAR fields; the rest of the fields often get
compressed.
-Josh
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2001-11-20 16:47:11 | Re: Trouble with MS Access-to-postgresql export |
Previous Message | Josh Berkus | 2001-11-20 16:35:42 | Re: If function available? |