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



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

"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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match