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

Re: Emergency backup question.

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 (view raw or flat)
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

In response to

pgsql-novice by date

Next:From: Josh BerkusDate: 2001-11-20 16:47:11
Subject: Re: Trouble with MS Access-to-postgresql export
Previous:From: Josh BerkusDate: 2001-11-20 16:35:42
Subject: Re: If function available?

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