Postgres Pro
Downloads
Home   >   mailing lists

Thread: start/stop error message

start/stop error message

From
David
Date:
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

Re: start/stop error message

From
brian
Date:
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?

Re: start/stop error message

From
Peter Eisentraut
Date:
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.

Re: start/stop error message

From
Martijn van Oosterhout
Date:
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.
Attachment