[PLUG] Another Post-Reboot Issue: PostgreSQL

[Rich Shepard]

On Thu, 1 Mar 2007, Jon Scully wrote:

> Try adding, to the bottom of /var/lib/postgres/data/pg_hba.conf:
> local all all trust

Jon,

   Tom Lane identified the problem. The network socket in /tmp was owned by
root.root instead of by postgres.users.

   I learned that I could remove that file after stopping the postmaster, and
that it was recreated properly when the postmaster was restarted. That fixed
the problem. I had no idea that I could safely wipe out that socket file;
that's why I didn't touch it until told it was a good thing to do.

Thanks,

Rich

-- 
Richard B. Shepard, Ph.D.               |    The Environmental Permitting
Applied Ecosystem Services, Inc.        |          Accelerator(TM)
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863