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:[EMAIL PROTECTED] Sent: Mon 8/20/2007 5:16 PM To: Tena Sakai; pgsql-admin@postgresql.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 <[EMAIL PROTECTED]> To: pgsql-admin@postgresql.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 [EMAIL PROTECTED] ___________________________________________________________ Want ideas for reducing your carbon footprint? Visit Yahoo! For Good http://uk.promotions.yahoo.com/forgood/environment.html
