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

On 4/01/2012 11:07 PM, bboett(at)free(dot)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 /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?
>

Look at the PostgreSQL logs to see why it failed to start. Probably
permissions. See:

wiki.postgresql.org/wiki/Guide_to_reporting_problems

--
Craig Ringer