| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Bill Moran <wmoran(at)collaborativefusion(dot)com> |
| Cc: | "Joey K(dot)" <pguser(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Switch off PITR |
| Date: | 2008-12-03 19:22:28 |
| Message-ID: | 1228332148.27483.132.camel@jd-laptop.pragmaticzealot.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 2008-12-03 at 13:16 -0500, Bill Moran wrote:
> In response to "Joey K." <pguser(at)gmail(dot)com>:
> >
> > 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Kellerer | 2008-12-03 19:24:35 | Re: Good Open source reverse UML creation tool |
| Previous Message | wild_oscar | 2008-12-03 18:22:13 | Good Open source reverse UML creation tool |