Обсуждение: pg_ctl stop

hi list,

i'm just started with postghreSQL.
my version 7.1.3.

i started: pg_ctl start -o -i

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

now my problem is:

pg_ctl stop always failes.
pg_ctl: postmaster does not shut down

i read on the list that i should not use

killall -9 postmaster

so i hope anybody can help me

oliver

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