pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Odd behaviour with WAL and pg_stop_backup
2+ messages / 2 participants
[nested] [flat]

* Odd behaviour with WAL and pg_stop_backup
@ 2006-09-15 12:47 Donald Fraser <postgres@kiwi-fraser.net>
  2006-09-15 14:17 ` Re: Odd behaviour with WAL and pg_stop_backup Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Donald Fraser @ 2006-09-15 12:47 UTC (permalink / raw)
  To: pgsql-admin

PostgreSQL 8.0.7
OS: Linux Red Hat 4.0


We have been testing the on-line backup of PostgreSQL and after issuing a 
pg_stop_backup() PostgreSQL is still using the archive command, as set in 
postgresql.conf, for every new WAL block generated.

It appears the only way to truly stop it from using the archive command is to 
edit the postgresql.conf file, remove the archive command and either issue a 
SIGHUP or a server restart.

Can someone confirm that this is the correct behaviour or not?

Thanks in advance,
Donald Fraser





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

* Re: Odd behaviour with WAL and pg_stop_backup
  2006-09-15 12:47 Odd behaviour with WAL and pg_stop_backup Donald Fraser <postgres@kiwi-fraser.net>
@ 2006-09-15 14:17 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2006-09-15 14:17 UTC (permalink / raw)
  To: Donald Fraser <postgres@kiwi-fraser.net>; +Cc: pgsql-admin

"Donald Fraser" <postgres@kiwi-fraser.net> writes:
> We have been testing the on-line backup of PostgreSQL and after issuing a 
> pg_stop_backup() PostgreSQL is still using the archive command, as set in 
> postgresql.conf, for every new WAL block generated.

Um ... why would that surprise you?  That facility is designed for
continuous archiving of WAL.  If you want to make a one-shot dump,
pg_dump is a much better tool.

			regards, tom lane



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


end of thread, other threads:[~2006-09-15 14:17 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-09-15 12:47 Odd behaviour with WAL and pg_stop_backup Donald Fraser <postgres@kiwi-fraser.net>
2006-09-15 14:17 ` Tom Lane <tgl@sss.pgh.pa.us>

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