Обсуждение: start/stop error message

I am unable to solve the following problem.

When I start or stop PostgreSQL using pg_ctl (without the -D option) the
system works fine. No errors.  I have the PGDATA environment variable
set and it points to my cluster.

When I run the /etc/init.d/postgresql-8.2 script with either of "stop"
or "start" as parameters I get the following error:


david@kepler:/etc/init.d$ sudo /etc/init.d/postgresql-8.2 start
 * Starting PostgreSQL 8.2 database server
 * Error: specified cluster does not exist
                                                         [fail]

and the same error when passing "stop"

The cluster clearly exists and is recognized by pg_ctl. As a result
PostgreSQL does not start with the system and must be started and
stopped manually.

I am running Ubuntu linux (very close to Debian).

There must be a configuration error but I cannot find it.

David

David wrote:
> I am unable to solve the following problem.
>
> When I start or stop PostgreSQL using pg_ctl (without the -D option) the
> system works fine. No errors.  I have the PGDATA environment variable
> set and it points to my cluster.
>
> When I run the /etc/init.d/postgresql-8.2 script with either of "stop"
> or "start" as parameters I get the following error:
>
>
> david@kepler:/etc/init.d$ sudo /etc/init.d/postgresql-8.2 start
>  * Starting PostgreSQL 8.2 database server
>  * Error: specified cluster does not exist
>                                                          [fail]
>
> and the same error when passing "stop"
>
> The cluster clearly exists and is recognized by pg_ctl. As a result
> PostgreSQL does not start with the system and must be started and
> stopped manually.
>
> I am running Ubuntu linux (very close to Debian).
>
> There must be a configuration error but I cannot find it.
>

Do the paths set in /etc/init.d/postgresql-8.2 conform to your PG*
environment variables?

David wrote:
> david@kepler:/etc/init.d$ sudo /etc/init.d/postgresql-8.2 start
>  * Starting PostgreSQL 8.2 database server
>  * Error: specified cluster does not exist
>                                                          [fail]
>
> and the same error when passing "stop"
>
> The cluster clearly exists and is recognized by pg_ctl. As a result
> PostgreSQL does not start with the system and must be started and
> stopped manually.

I can imagine that you have some unsupported mixture of package
installation and manually created cluster.  But it is hard to tell
without more detail.

On Thu, Nov 20, 2008 at 12:22:24AM -0500, David wrote:
> I am unable to solve the following problem.
>
> When I start or stop PostgreSQL using pg_ctl (without the -D option) the
> system works fine. No errors.  I have the PGDATA environment variable
> set and it points to my cluster.

What did you do prior to getting into this situation?

Firstly, run pg_lsclusters and see if your cluster is in there. If not
I suggest you explain more clearly what you did. Also, read the
documentation in /usr/share/doc/postgresql-8.2/README.Debian.gz and see
if it puts you on the right track.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.