| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | dionysus <dionysus39(at)hotmail(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: restoring pgsql database v7.0.3? |
| Date: | 2002-05-24 04:45:35 |
| Message-ID: | 28933.1022215535@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
dionysus <dionysus39(at)hotmail(dot)com> writes:
> ... I reinstalled my OS (Redhat linux 7.1)...I am
> now trying to work out how to restore one of my user's databases to
> its previous state from an old copy of my /var/lib/pgsql directory
> (databases are in /var/lib/pgsql/data/base).....I tried simply
> overwriting the fresh install with the files from my backup, but that
> somehow corrupted my installation - I had to reinstall the package
A complete restore of /var/lib/pgsql/data/ should have worked, if the
dump was taken while the database was idle. If you try to restore
selectively it will likely not work --- pg_log has to be in sync with
all of the data files. A filesystem dump of an active database is
unlikely to yield consistent results either.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Annissa Melhenas | 2002-05-24 08:21:32 | script |
| Previous Message | Tom Lane | 2002-05-24 04:27:32 | Re: discovering an index definition |