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
>