Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux