Re: transitioning postgres oid - Mailing list pgsql-general

From Robert Abbate
Subject Re: transitioning postgres oid
Date
Msg-id 003b01c1fb52$a9106ac0$183e8b41@watcher2
Whole thread Raw
In response to transitioning postgres oid  ("Robert Abbate" <cogea@ectisp.net>)
Responses Re: transitioning postgres oid
List pgsql-general
This doesn't work because the old databases are not accessible with the new
Postgres installation. I get the following error:


Connection to database '26955' failed.
FATAL 1:  Database "26955" does not exist in the system catalog.


Does anyone know how do you update the system catalog to include an old
Postges installation OID? I have old databases just sitting there and I
can't seem to include them in the new installation. I cannot include them in
the new installation to run pg_dump.

Thanks,
Robert





----- Original Message -----
From: "Thomas Beutin" <tyrone@laokoon.IN-Berlin.DE>
To: "Robert Abbate" <cogea@ectisp.net>
Sent: Tuesday, May 14, 2002 2:26 AM
Subject: Re: [GENERAL] transitioning postgres oid


> Hi,
>
> executing the shell command "pg_dump --help" shows the options
> of pg_dump available in Your installation. You should try to
> dump with the "-o" resp "--oids" option and inserting in the
> data into the fresh installation. Maybe this helps.
>
> -tb
>
> On Tue, May 14, 2002 at 01:26:47AM -0500, 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
>
> --
> Thomas Beutin                             tb@laokoon.IN-Berlin.DE
> Beam me up, Scotty. There is no intelligent live down in Redmond.


---
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/28/02


pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: Strange interaction with php's pg_query
Next
From: Bill Moran
Date:
Subject: Re: Use of OIDS as primary keys