| From: | Patrick B <patrickbakerbr(at)gmail(dot)com> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Turning slave into a master - PostgreSQL 9.2 |
| Date: | 2016-11-01 19:43:53 |
| Message-ID: | CAJNY3iuZbsUJM8tzwSA9Vr7uHaMMNJidffe_DaSYs0dpWMLO1Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2016-11-02 2:55 GMT+13:00 Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>:
> On Mon, Oct 31, 2016 at 8:01 PM, Patrick B <patrickbakerbr(at)gmail(dot)com>
> wrote:
> > If I change recovery.conf:
> >
> > recovery_target_time = '2016-10-30 02:24:40'
> >
> >
> > I get error:
> >
> > FATAL: requested recovery stop point is before consistent recovery point
>
> You can try using pg_basebackup to get the replica setup. In 9.2 you
> gotta make your own recovery.conf, but you already know how to do
> that. Way easier than trying to rsync by hand etc.
>
I did a pg_basebackup!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2016-11-02 00:28:46 | Re: Validity of using the test_decoding plugin for production? |
| Previous Message | Joshua Kehn | 2016-11-01 19:01:22 | Re: Validity of using the test_decoding plugin for production? |