pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
After adjusting checkpoint related entries in postgresql.conf...
5+ messages / 3 participants
[nested] [flat]

* After adjusting checkpoint related entries in postgresql.conf...
@ 2007-08-21 00:00 Tena Sakai <tsakai@gallo.ucsf.edu>
  0 siblings, 0 replies; 5+ messages in thread

From: Tena Sakai @ 2007-08-21 00:00 UTC (permalink / raw)
  To: pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: After adjusting checkpoint related entries in postgresql.conf...
@ 2007-08-21 00:16 Farhan Mughal <farhanhafeezmughal@yahoo.co.uk>
  2007-08-21 03:14 ` Re: After adjusting checkpoint related entries in postgresql.conf... Tena Sakai <tsakai@gallo.ucsf.edu>
  0 siblings, 1 reply; 5+ messages in thread

From: Farhan Mughal @ 2007-08-21 00:16 UTC (permalink / raw)
  To: Tena Sakai <tsakai@gallo.ucsf.edu>; pgsql-admin


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

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: After adjusting checkpoint related entries in postgresql.conf...
  2007-08-21 00:16 Re: After adjusting checkpoint related entries in postgresql.conf... Farhan Mughal <farhanhafeezmughal@yahoo.co.uk>
@ 2007-08-21 03:14 ` Tena Sakai <tsakai@gallo.ucsf.edu>
  2007-08-21 04:12   ` Re: After adjusting checkpoint related entries in postgresql.conf... Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 5+ messages in thread

From: Tena Sakai @ 2007-08-21 03:14 UTC (permalink / raw)
  To: Farhan Mughal <farhanhafeezmughal@yahoo.co.uk>; pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: After adjusting checkpoint related entries in postgresql.conf...
  2007-08-21 00:16 Re: After adjusting checkpoint related entries in postgresql.conf... Farhan Mughal <farhanhafeezmughal@yahoo.co.uk>
  2007-08-21 03:14 ` Re: After adjusting checkpoint related entries in postgresql.conf... Tena Sakai <tsakai@gallo.ucsf.edu>
@ 2007-08-21 04:12   ` Tom Lane <tgl@sss.pgh.pa.us>
  2007-08-21 15:48     ` Re: After adjusting checkpoint related entries in postgresql.conf... Tena Sakai <tsakai@gallo.ucsf.edu>
  0 siblings, 1 reply; 5+ messages in thread

From: Tom Lane @ 2007-08-21 04:12 UTC (permalink / raw)
  To: Tena Sakai <tsakai@gallo.ucsf.edu>; +Cc: Farhan Mughal <farhanhafeezmughal@yahoo.co.uk>; pgsql-admin

"Tena Sakai" <tsakai@gallo.ucsf.edu> writes:
> Does checkpoint not happen if there is no activity?

That's correct.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: After adjusting checkpoint related entries in postgresql.conf...
  2007-08-21 00:16 Re: After adjusting checkpoint related entries in postgresql.conf... Farhan Mughal <farhanhafeezmughal@yahoo.co.uk>
  2007-08-21 03:14 ` Re: After adjusting checkpoint related entries in postgresql.conf... Tena Sakai <tsakai@gallo.ucsf.edu>
  2007-08-21 04:12   ` Re: After adjusting checkpoint related entries in postgresql.conf... Tom Lane <tgl@sss.pgh.pa.us>
@ 2007-08-21 15:48     ` Tena Sakai <tsakai@gallo.ucsf.edu>
  0 siblings, 0 replies; 5+ messages in thread

From: Tena Sakai @ 2007-08-21 15:48 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Farhan Mughal <farhanhafeezmughal@yahoo.co.uk>; pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2007-08-21 15:48 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-08-21 00:00 After adjusting checkpoint related entries in postgresql.conf... Tena Sakai <tsakai@gallo.ucsf.edu>
2007-08-21 00:16 Re: After adjusting checkpoint related entries in postgresql.conf... Farhan Mughal <farhanhafeezmughal@yahoo.co.uk>
2007-08-21 03:14 ` Tena Sakai <tsakai@gallo.ucsf.edu>
2007-08-21 04:12   ` Tom Lane <tgl@sss.pgh.pa.us>
2007-08-21 15:48     ` Tena Sakai <tsakai@gallo.ucsf.edu>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox