1. Sorry, that was an accident. I sent a new thread to the list and it
didn't make it. Thinking I had gotten the address wrong, I "replied to"
this thread and accidentally hit send, forgetting to change the subject.
My apologies, no hijacking was intended.
2. Close. The database was generally restarted with a script that would
call postmaster with the "-i" option. The conf file never allowed TCP/IP
connections, which didn't become apparent until I tried to restart using
pg_ctl with no options.
Thank you , and sorry again
Jaime
Tom Lane wrote:
> Jaime Silvela <JSilvela@Bear.com> writes:
>
>> Below you can see the log on starting, after a kill -9 of a process
>> brought Postgres down.
>> After letting postgres run for a while, it seems to have fixed itself,
>> and now the log does not suggest any corruption, and I can access it
>> locally. However, TCP/IP connections are rejected. Any ideas?
>>
>
> 1. Please do not hijack existing threads for an unrelated question.
>
> 2. You must have changed postgresql.conf or pg_hba.conf to reject
> outside connections. This might have happened some time ago and only
> shown up upon postmaster restart, if you'd neglected to SIGHUP the
> postmaster after the change...
>
> regards, tom lane
>
>
***********************************************************************
Bear Stearns is not responsible for any recommendation, solicitation,
offer or agreement or any information about any transaction, customer
account or account activity contained in this communication.
Bear Stearns does not provide tax, legal or accounting advice. You
should consult your own tax, legal and accounting advisors before
engaging in any transaction. In order for Bear Stearns to comply with
Internal Revenue Service Circular 230 (if applicable), you are notified
that any discussion of U.S. federal tax issues contained or referred to
herein is not intended or written to be used, and cannot be used, for
the purpose of: (A) avoiding penalties that may be imposed under the
Internal Revenue Code; nor (B) promoting, marketing or recommending to
another party any transaction or matter addressed herein.
***********************************************************************