Search Postgresql Archives

Re: Switch off PITR

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, 2008-12-03 at 13:16 -0500, Bill Moran wrote:
> In response to "Joey K." <pguser@xxxxxxxxx>:
> > 
> > How do I turn off PITR in the mean time? I commented archive_command and
> > issued a pg_ctl reload and postgres is *still* archiving logs to the backup
> > server.
> 
> Pretty sure you're going to need a full restart -- reload won't cause
> that parameter to be re-evaluated.

You can change archive_command to something like /bin/true and reload.
However you will have to do a full base backup to get postgresql doing
log shipping again.

Joshua D. Drake

-- 
PostgreSQL
   Consulting, Development, Support, Training
   503-667-4564 - http://www.commandprompt.com/
   The PostgreSQL Company, serving since 1997


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux