Обсуждение: 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@gallo.ucsf.edu
A reload should be enough. Are you facing any problems?
--Farhan
From: Tena Sakai <tsakai@gallo.ucsf.edu>
To: pgsql-admin@postgresql.org
Sent: Tuesday, 21 August, 2007 5:00:21 AM
Subject: [ADMIN] 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@gallo.ucsf.edu
Yahoo! Answers - Get better answers from someone who knows. Try it now.
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@yahoo.co.uk]
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 <tsakai@gallo.ucsf.edu>
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
tsakai@gallo.ucsf.edu
___________________________________________________________
Want ideas for reducing your carbon footprint? Visit Yahoo! For Good http://uk.promotions.yahoo.com/forgood/environment.html
"Tena Sakai" <tsakai@gallo.ucsf.edu> writes: > Does checkpoint not happen if there is no activity? That's correct. regards, tom lane
Many thanks, Tom.
Tena
tsakai@gallo.ucsf.edu
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Mon 8/20/2007 9:12 PM
To: Tena Sakai
Cc: Farhan Mughal; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] After adjusting checkpoint related entries in postgresql.conf...
"Tena Sakai" <tsakai@gallo.ucsf.edu> writes:
> Does checkpoint not happen if there is no activity?
That's correct.
regards, tom lane