Re: pg_ctl stop - Mailing list pgsql-novice

From Josh Berkus
Subject Re: pg_ctl stop
Date
Msg-id web-522787@davinci.ethosmedia.com
Whole thread Raw
In response to pg_ctl stop  ("Oliver Walter" <owalter@intradat.com>)
List pgsql-novice
Oliver,

> after this i made changes in
> -pg_hba.conf
> -pg_ident.conf

What sort of changes?  If you've locked localhost out, you'll experience
some problems.

> now my problem is:
>
> pg_ctl stop always failes.
> pg_ctl: postmaster does not shut down

What do you mean, fails?  What happens when you issue the command pg_ctl
stop?  And what user are you doing this as?

Keep in mind that pg_ctl will not shut down the database if you have a
connection open.  Is it possible that you have a psql, pgadmin, or
pgaccess window open somewhere?

> i read on the list that i should not use
>
> killall -9 postmaster

That's risking database corruption, if you do.

I'd suggest that you also pick up a general-purpose PostgreSQL
beginner's book.  See http://techdocs.postgresql.org/bookreviews.php

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco

pgsql-novice by date:

Previous
From: Jason Earl
Date:
Subject: Re: Number of days in a month
Next
From: Andrew McMillan
Date:
Subject: Re: IF...THEN...ELSE on INSERT