Re: pg_ctl stop

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(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco