Re: Recover database from binary files

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Recover database from binary files
Дата
Msg-id BANLkTimCGzZY+oCjk0vB9P+sE8zRHytWTw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Recover database from binary files  (Diogo Melo <dmelo87@gmail.com>)
Ответы Re: Recover database from binary files  (Diogo Melo <dmelo87@gmail.com>)
Список pgsql-general
On Tue, Apr 26, 2011 at 9:50 AM, Diogo Melo <dmelo87@gmail.com> wrote:
> just tar -zcvf 8.3.tar.gz /mnt/sdf/var/lib/postgresql/8.3/
> since i found a way to mount the partition on /mnt/sdf.
> first I installed postgres on a virtual machine and then I extracted the
> 8.3.tar.gz at /var/lib/postgresql . when i try to sh
> /etc/init.d/postgresql-8.3 start it runs the command instantly but don't
> launch anything.
>
> Is there a procedure to recover postgres databases on this occasions??

Pretty much what you are doing is the procedure.  Check permissions on
that folder, look in the postgresql logs, look in the system logs,
etc.  It'll likely say something about wrong permissions, but that's
just a guess.

В списке pgsql-general по дате отправления:

Предыдущее
От: Diogo Melo
Дата:
Сообщение: Re: Recover database from binary files
Следующее
От: Tom Lane
Дата:
Сообщение: Re: optimizing a cpu-heavy query