Re: my stupidity

Поиск
Список
Период
Сортировка
От Larry Rosenman
Тема Re: my stupidity
Дата
Msg-id 200007210510.e6L5AgG06387@lerami.lerctr.org
обсуждение исходный текст
Ответ на Re: my stupidity  (John McKown <jmckown@prodigy.net>)
Список 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 по дате отправления:

Предыдущее
От: John McKown
Дата:
Сообщение: Re: my stupidity
Следующее
От: Adriaan Joubert
Дата:
Сообщение: Re: Loading binary data into the database