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

2012-01-08 Thread Craig Ringer
On 4/01/2012 11:07 PM, bbo...@free.fr wrote: so i tried to copy the old 9.0 tree to a machine with a still working 9,0 postgres, but it stops with Starting PostgreSQL 9.0 database server: mainError: could not exec /usr/lib/postgresql/9.0/bin/pg_ctl /usr/lib/postgresql/9.0/bin/pg_ctl start -D /va

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

2012-01-05 Thread Adrian Klaver
On Wednesday, January 04, 2012 11:42:01 pm Bruno Boettcher wrote: > On Wed, Jan 04, 2012 at 10:06:53AM -0800, Adrian Klaver wrote: > Hello! > > > ok, got it, from your lines i saw that the binaries of the server were > removed > so i copied them over from the other server, and got the server

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

2012-01-05 Thread Bruno Boettcher
On Wed, Jan 04, 2012 at 10:06:53AM -0800, Adrian Klaver wrote: Hello! > So when you are running pg_ctlcluster 9.0 main start what user are you > running > as? tried as root... > > Have you tried to directly start the 9.0 cluster as the postgres user?: just tried, same error postgres@agenda

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

2012-01-05 Thread Radosław Smogura
On Wed, 4 Jan 2012 15:50:25 +0100, Bruno Boettcher wrote: Hello! just made a stupid move... upgraded a working system and without checking if the backup was ok so i end up with a debian system having upgraded to 9,1 without converting the database, and a scrambled backup which is totall

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

2012-01-04 Thread Adrian Klaver
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

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

2012-01-04 Thread Adrian Klaver
On Wednesday, January 04, 2012 6:50:25 am Bruno Boettcher wrote: > Hello! > > just made a stupid move... upgraded a working system and without > checking if the backup was ok > > so i end up with a debian system having upgraded to 9,1 without > converting the database, and a scrambled bac

[GENERAL] help... lost database after upgrade from 9.0 to 9.1

2012-01-04 Thread bboett
Hello! just made a stupid move... upgraded a working system and without checking if the b

[GENERAL] help... lost database after upgrade from 9.0 to 9.1

2012-01-04 Thread bboett
Hello! just made a stupid move... upgraded a working system and without checking if the b

[GENERAL] help... lost database after upgrade from 9.0 to 9.1

2012-01-04 Thread Bruno Boettcher
Hello! just made a stupid move... upgraded a working system and without checking if the backup was ok so i end up with a debian system having upgraded to 9,1 without converting the database, and a scrambled backup which is totally unusable i tried to start the old tree with pg_ctlcl