Postgres Pro
Downloads
Home   >   mailing lists

Thread: my stupidity

my stupidity

From
Larry Rosenman
Date:
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?

Thanks!

LER

-- 
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

Re: my stupidity

From
John McKown
Date:
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

Re: my stupidity

From
Larry Rosenman
Date:
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