Re: 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