From: | Bruno Boettcher <bboett(at)bboett(dot)adlp(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | help... lost database after upgrade from 9.0 to 9.1 |
Date: | 2012-01-04 14:50:25 |
Message-ID: | 20120104145025.GM15907@bboett.adlp.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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_ctlcluster 9.0 main start
Error: could not exec 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" :
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 /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" : ... failed!
failed!
so what can i do to extract the data of that tree and feed it into the
9.1 tree?
thanks in avance!
--
ciao bboett
==============================================================
bboett(at)adlp(dot)org
http://inforezo.u-strasbg.fr/~bboett/
===============================================================
From | Date | Subject | |
---|---|---|---|
Next Message | bboett | 2012-01-04 15:02:25 | help... lost database after upgrade from 9.0 to 9.1 |
Previous Message | Andreas Kretschmer | 2012-01-04 14:15:16 | Re: Postgresql 9.1 logging |