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