Re: recovering fs-data from previous installation - Mailing list pgsql-general

From Adrian Klaver
Subject Re: recovering fs-data from previous installation
Date
Msg-id 201002110715.31460.adrian.klaver@gmail.com
Whole thread Raw
In response to recovering fs-data from previous installation  (Marc Lustig <ml@marclustig.com>)
List pgsql-general
On Monday 08 February 2010 7:11:28 am Marc Lustig wrote:
> I managed to install again postgresql-8.4 from hardy-backports.
> Now the installation is identical with the previous one.
>
> With the fresh database, the server starts up fine.
>
> Now I copied all from the backup to
> /usr/lib/postgresql/8.4
> /var/lib/postgresql/8.4
>
> The the startup fails like this:
>
>  * Starting PostgreSQL 8.4 database server
>
>                                           * Error: could not exec
> /usr/lib/postgresql/8.4/bin/pg_ctl /usr/lib/postgresql/8.4/bin/pg_ctl start
> -D /var/lib/postgresql/8.4/main -l
> /var/log/postgresql/postgresql-8.4-main.log -s -o  -c
> config_file="/etc/postgresql/8.4/main/postgresql.conf" :
>
> the log-file is empty.
>
> Can you please help to get postgresql to start again using the previous
> database. I suppose there should be no serious issues, as the version of
> postgresql is identical now.

Where are you starting this from? This start up script looks wrong. It looks
like a combination of scripts. For a comparison here is mine for 8.4 on Ubuntu:

/usr/lib/postgresql/8.4/bin/postgres -D /var/lib/postgresql/8.4/main -c
config_file=/etc/postgresql/8.4/main/postgresql.conf


--
Adrian Klaver
adrian.klaver@gmail.com

pgsql-general by date:

Previous
From: Koichi Suzuki
Date:
Subject: Bug on pg_lesslog
Next
From: Tom Lane
Date:
Subject: Re: Extending SQL in C using VARIABLE length type