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 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 backup which is totally
> unusable....

Define scrambled backup.

> 
> 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="" :

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


> 
> 
> 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!

This is more of the same as above. For now lets concentrate on the original 
install.

> 
> 
>  so what can i do to extract the data of that tree and feed it into the
>  9.1 tree?

Get the 9.0 server running.

> 
>  thanks in avance!

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