Re: [GENERAL] Postgres errors in Drupal install.

2011-06-26 Thread Martin Gainty
26 Jun 2011 16:23:09 -0700 > From: pie...@hogranch.com > To: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Postgres errors in Drupal install. > > On 06/26/11 4:10 PM, Dave Coventry wrote: > > > >> work_mem: 64kB > >> shared_buffers: 128kB > &

Re: [GENERAL] Postgres errors in Drupal install.

2011-06-26 Thread John R Pierce
On 06/26/11 4:10 PM, Dave Coventry wrote: work_mem: 64kB shared_buffers: 128kB maintenance_work_mem: 1MB I'll see if that makes any difference. I'd watch the systems' memory usage as shown by `top` or `free`... as long as the 'cached' value (add in 'free' if its significant) stays reasonab

Re: [GENERAL] Postgres errors in Drupal install.

2011-06-26 Thread Dave Coventry
Apologies, I didn't notice that I was replying off-list. On 27 June 2011 00:29, Dave Coventry wrote: > On 26 June 2011 23:37, John R Pierce wrote: >> I didn't read the whole thread, but is this a Linux server?   Linux has a >> horrible feature, the "Out of Memory Killer", which kills off process

Re: [GENERAL] Postgres errors in Drupal install.

2011-06-26 Thread John R Pierce
On 06/26/11 2:23 PM, Dave Coventry wrote: While the server is a little challenged in the way of RAM, it is by no means under any sort of load. I didn't read the whole thread, but is this a Linux server? Linux has a horrible feature, the "Out of Memory Killer", which kills off processes when

Re: [GENERAL] Postgres errors in Drupal install.

2011-06-26 Thread Peter Bex
On Sun, Jun 26, 2011 at 11:23:30PM +0200, Dave Coventry wrote: [snip] > 2011-06-26 17:13:24 EDT DETAIL: Failed system call was > shmget(key=5432001, size=29278208, 03600). > 2011-06-26 17:13:24 EDT HINT: This error usually means that > PostgreSQL's request for a shared memory segment exceeded ava

Re: [GENERAL] Postgres errors in Drupal install.

2011-06-26 Thread Dave Coventry
Thank you very much for your responses. On 26 June 2011 21:54, Peter Bex wrote: > Do you get the error in the logs or do you see it while going to the > site manually and does it show this instead of rendering a page? The log don't really give much indication of anything untoward happening. It's

Re: [GENERAL] Postgres errors in Drupal install.

2011-06-26 Thread Peter Bex
On Sun, Jun 26, 2011 at 09:36:59PM +0200, Dave Coventry wrote: > I'm having huge problems with a Drupal install using Postgres 8.4.8. > > I'm getting the following error: Do you get the error in the logs or do you see it while going to the site manually and does it show this instead of rendering

Re: [GENERAL] Postgres errors in Drupal install.

2011-06-26 Thread Adrian Klaver
On Sunday, June 26, 2011 12:36:59 pm Dave Coventry wrote: > I'm having huge problems with a Drupal install using Postgres 8.4.8. > > I'm getting the following error: > > PDOException: SQLSTATE[08006] [7] could not connect to server: > Connection refused Is the server running on host "localhost" a

[GENERAL] Postgres errors in Drupal install.

2011-06-26 Thread Dave Coventry
I'm having huge problems with a Drupal install using Postgres 8.4.8. I'm getting the following error: PDOException: SQLSTATE[08006] [7] could not connect to server: Connection refused Is the server running on host "localhost" and accepting TCP/IP connections on port 5432? in lock_may_be_available