Re: help... lost database after upgrade from 9.0 to 9.1

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: help... lost database after upgrade from 9.0 to 9.1
Дата
Msg-id 201201041006.53725.adrian.klaver@gmail.com
обсуждение исходный текст
Ответ на help... lost database after upgrade from 9.0 to 9.1  (Bruno Boettcher <bboett@bboett.adlp.org>)
Ответы Re: help... lost database after upgrade from 9.0 to 9.1  (Bruno Boettcher <bboett@bboett.adlp.org>)
Список pgsql-general
On Wednesday, January 04, 2012 9:46:42 am you wrote:
> On Wed, Jan 04, 2012 at 07:41:32AM -0800, Adrian Klaver wrote:
> Hello!
>
> > Define scrambled backup.

I am CCing list so more eyes can see this.

>
> well.... disks on both side had block loss, without me noticing....
> so the backups were on the wrong partitions, and most of them are now
> part of lost+found if not lost completely...
>
> my luck that boths disks gave up more or less, at the same time, and
> more or less silently....

Alright, so really scrambled.

>
> > On original machine verify that the locations and files in above command
> > exist: /var/lib/postgresql/9.0/main
> > /var/log/postgresql/postgresql-9.0-main.log
> > /etc/postgresql/9.0/main/postgresql.conf
>
> all three ok!

So when you are running pg_ctlcluster 9.0 main start what user are you running
as?

Have you tried to directly start the 9.0 cluster as the postgres user?:

usr/lib/postgresql/9.0/bin/pg_ctl /usr/lib/postgresql/9.0/bin/pg_ctl start  -D\
/var/lib/postgresql/9.0/main\
 -l /var/log/postgresql/postgresql-9.0-main.log -s -o -c\
config_file="/etc/postgresql/9.0/main/postgresql.conf"


>
> > Get the 9.0 server running.
>
> heh :D
> that's what i didn't manage to do....

--
Adrian Klaver
adrian.klaver@gmail.com

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

Предыдущее
От: "James B. Byrne"
Дата:
Сообщение: PGAdmin3 for 9.1 and CentOS-5_x86_64
Следующее
От: Alban Hertroys
Дата:
Сообщение: Re: Duplicated entries are not ignored even if a "do instead nothing" rule is added.