| From: | Christophe Labouisse <christophe(at)labouisse(dot)org> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | pg_ctl start hangs |
| Date: | 2001-08-17 08:22:44 |
| Message-ID: | m2zo8zdrjf.fsf@gabuzo.meunet |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
When restarting postgres this morning I notice the pg_ctl start hangs
forever while the database seems to be up and working. Eventually I
found out that the start process involves a "psql -l" which waits
for me to enter a password since I have "local all password" in my
pg_hba.conf. I change back to trust but since I have users with shell
access on the server I'd would like to switch back to "password".
I used the following command to start the database:
/usr/local/bin/pg_ctl start -s -w -l /usr/local/pgsql/errlog -o "-i"
My configuration:
FreeBSD 4.3, Postgresql 7.1.2
--
Le cinéma en Lumière : http://www.lumiere.org/
Fingerprint : 4721 651D D309 B302 93E4 5D73 CC52 DF3A E7C7 86CF
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2001-08-17 09:47:31 | Re: Query Approach and performance |
| Previous Message | Morgan Curley | 2001-08-17 07:29:36 | Query Approach and performance |