Re: transitioning postgres oid
От | Robert Abbate |
---|---|
Тема | Re: transitioning postgres oid |
Дата | |
Msg-id | 003b01c1fb52$a9106ac0$183e8b41@watcher2 обсуждение исходный текст |
Ответ на | transitioning postgres oid ("Robert Abbate" <cogea@ectisp.net>) |
Ответы |
Re: transitioning postgres oid
|
Список | 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 по дате отправления: