On 金, 2010-06-18 at 16:48 -0700, Rich Shepard wrote: > On Fri, 18 Jun 2010, Stuart Luppescu wrote: > > > Error! > > > > could not connect to server: Permission denied Is the server running > > locally and accepting connections on Unix domain socket > > "/var/run/postgresql/.s.PGSQL.5432"? > > Yup. Been there, done that, got the tee-shirt. > > Delete that socket file and the .lock file when postgres is not running > and restart it. From memory that's all that's required.
Thanks. That helped. Also, it would have helped if I paid closer attention to the Fine Documentation, especially this line: In order for your users to make local connections — via localhost or the Unix socket — to the server, your users must be in the postgres group. Use usermod -a -G postgres user to add user to the postgres group. Users not in the postgres group will be rejected with: Permission denied. So, I added apache to the postgres group, and now I'm up and running! Whew. -- Stuart Luppescu -*-*- slu <at> ccsr <dot> uchicago <dot> edu CCSR in UEI at U of C _______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
