Re: my stupidity

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(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749