Re: After adjusting checkpoint related entries in postgresql.conf...

["Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu>]

Title: RE: [ADMIN] After adjusting checkpoint related entries in postgresql.conf...

Hi Farhan,

> Are you facing any problems?

Yes, the files in data/pg_xlog directory hasn't been
updated.  Here's the setting as far as checkpint
entries are concerned:

  checkpoint_segments = 3
  checkpoint_timeout = 5min
  checkpoint_warning = 30s

Does checkpoint not happen if there is no activity?
The last entry I see in the serverlog file is:

  2007-08-20 16:47:51.152 PDT] <  >LOG:  received SIGHUP, reloading configuration files

Thank you.

Tena

-----Original Message-----
From: Farhan Mughal [mailto:farhanhafeezmughal(at)yahoo(dot)co(dot)uk]
Sent: Mon 8/20/2007 5:16 PM
To: Tena Sakai; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] After adjusting checkpoint related entries in postgresql.conf...


A reload should be enough. Are you facing any problems?

--Farhan

----- Original Message ----
From: Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Sent: Tuesday, 21 August, 2007 5:00:21 AM
Subject: [ADMIN] After adjusting checkpoint related entries in postgresql.conf...

After adjusting checkpoint related entries in postgresql.conf...








Hi everybody,



After adjusting checkpoint related entries in postgresql.conf

file, is it sufficient to issue:

  pg_ctl reload

Or am I supposed to do more than that?



Thank you in advance.



Tena Sakai

tsakai(at)gallo(dot)ucsf(dot)edu









      ___________________________________________________________
Want ideas for reducing your carbon footprint? Visit Yahoo! For Good  http://uk.promotions.yahoo.com/forgood/environment.html