| From: | Scott Marlowe <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | Robert Abbate <cogea(at)ectisp(dot)net> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: transitioning postgres oid |
| Date: | 2002-05-14 15:12:26 |
| Message-ID: | Pine.LNX.4.33.0205140912001.2855-100000@css120.ihs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Dump your old database with a -o switch:
pg_dump -o dbname >database.sql
On Tue, 14 May 2002, Robert Abbate wrote:
> Hi. I had to re-install Postgres and I was wondering how to do I get the old OID numbers (which have all my databases) incorporated into the fresh installation? I tried just putting the old "base" directory in, but it doesn't work. Is there some other way to do this or is it even possible at all?
>
> Please..any suggestions. Otherwise I lose my database data.
>
> Thanks,
> Robert
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.319 / Virus Database: 178 - Release Date: 1/29/02
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Abbate | 2002-05-14 15:15:45 | Re: transitioning postgres oid |
| Previous Message | Martín Marqués | 2002-05-14 15:05:22 | Re: restoreing dumps fail |