| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Peter Bayley" <peterb(at)homer(dot)com(dot)au> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Recover an existing database |
| Date: | 2002-01-18 20:01:03 |
| Message-ID: | 9655.1011384063@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Peter Bayley" <peterb(at)homer(dot)com(dot)au> writes:
> I had a hard disk crash recently and had to reinstall Linux (RedHat 7.2) a=
> nd consequently postgres (7.1.3) on the new root disk. My large database (=
> also 7.1.3) was mounted on another volume and I had created it using the "C=
> REATE DATABASE WITH LOCATION=3D" syntax.
> =20
> My question is: How can I change the new postgres install to recognise my =
> existing database?
You can't, if I'm correctly interpreting this scenario to mean that you
lost pg_log. Your transaction history, transaction numbers, and OIDs
are not in sync with the data files. While the OID counter isn't all
that critical, the transaction history definitely is. Sorry.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Cunningham | 2002-01-18 20:03:50 | Re: large file limitation |
| Previous Message | Jason Earl | 2002-01-18 19:52:24 | Re: sharing data accross several databases |