Re: help... lost database after upgrade from 9.0 to 9.1 - Mailing list pgsql-general

From Adrian Klaver
Subject Re: help... lost database after upgrade from 9.0 to 9.1
Date
Msg-id 201201041006.53725.adrian.klaver@gmail.com
Whole thread Raw
In response to help... lost database after upgrade from 9.0 to 9.1  (Bruno Boettcher <bboett@bboett.adlp.org>)
Responses Re: help... lost database after upgrade from 9.0 to 9.1  (Bruno Boettcher <bboett@bboett.adlp.org>)
List 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 by date:

Previous
From: "James B. Byrne"
Date:
Subject: PGAdmin3 for 9.1 and CentOS-5_x86_64
Next
From: Alban Hertroys
Date:
Subject: Re: Duplicated entries are not ignored even if a "do instead nothing" rule is added.