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

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(dot)klaver(at)gmail(dot)com