Odd behaviour with WAL and pg_stop_backup

From: "Donald Fraser" <postgres(at)kiwi-fraser(dot)net>
To: "[ADMIN]" <pgsql-admin(at)postgresql(dot)org>
Subject: Odd behaviour with WAL and pg_stop_backup
Date: 2006-09-15 12:47:21
Message-ID: 000601c6d8c5$161acd50$6464a8c0@DonAcer
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Nick Howden 2006-09-15 13:08:32 Auto Vacuum not starting unless postgres is restarted
Previous Message Gregory Stark 2006-09-15 12:45:07 Re: [ADMIN] Vacuum error on database postgres