Re: my stupidity - Mailing list pgsql-hackers

From Larry Rosenman
Subject Re: my stupidity
Date
Msg-id 200007210510.e6L5AgG06387@lerami.lerctr.org
Whole thread Raw
In response to Re: my stupidity  (John McKown <jmckown@prodigy.net>)
List pgsql-hackers
Nope.  get "database ler, OID=18754" has disappeared.

LER

> On Thu, 20 Jul 2000, Larry Rosenman wrote:
> 
> > Can anyone suggest how I can regain access to some PGSQL files
> > that are in a directory below /usr/local/pgsql/data/base
> > but aren't in the catalog due to an errant initdb?
> 
> Well, I don't know if it will work, but what I'd try is something like the
> following:
> 
> 1) logon as root
> 2) cd /usr/local/pgsql/data/base
> 3) mv database-name database-name-old
> 4) logon as the normal database user
> 5) createdb database-name
> 6) logon as root
> 7) cd /usr/local/pgsql/data/base
> 8) mv database-name database-name-new
> 9) mv database-name-old database-name
> 10) test
> 
> Since you have everything still around, I don't see where this can cause
> you any more hurt than you are already in.
> 
> John
> 


-- 
Larry Rosenman                      http://www.lerctr.org/~ler
Phone: +1 972-414-9812 (voice) Internet: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749


pgsql-hackers by date:

Previous
From: John McKown
Date:
Subject: Re: my stupidity
Next
From: Adriaan Joubert
Date:
Subject: Re: Loading binary data into the database