Re: transitioning postgres oid - Mailing list pgsql-general

From Robert Abbate
Subject Re: transitioning postgres oid
Date
Msg-id 009101c1fb5a$6c9950e0$183e8b41@watcher2
Whole thread Raw
In response to transitioning postgres oid  ("Robert Abbate" <cogea@ectisp.net>)
Responses Re: transitioning postgres oid
Re: transitioning postgres oid
Re: transitioning postgres oid
List pgsql-general
Actually, if I was able to get the old database up, I wouldn't needed to
re-install postgres again. That is my problem. I could not get the old
databases up and running at all. I had to do a fresh installation. So now
the old databases are just sitting there. Any ideas?


> On Tue, May 14, 2002 at 09:21:37AM -0500, Robert Abbate wrote:
> > 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.
>
> You do pg_dump with the old backend up, then restore to the new one.
> You can automate this by starting (say) the new backend on a different
> port:
>
> pg_dump -c database_name | psql -p new_port database_name
>
>
> A
> --
> ----
> Andrew Sullivan                               87 Mowat Avenue
> Liberty RMS                           Toronto, Ontario Canada
> <andrew@libertyrms.info>                              M6K 3E3
>                                          +1 416 646 3304 x110
>


---
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: Erwin Ambrosch
Date:
Subject: Question about SERIAL
Next
From: "Bertin, Philippe"
Date:
Subject: Re: Using COPY