| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | "nurul [via PostgreSQL]" <ml-node+s1045698n5823774h72(at)n5(dot)nabble(dot)com> |
| Cc: | PostgreSQL - general mailing list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Log-shipping replication in one machine |
| Date: | 2014-10-24 08:22:38 |
| Message-ID: | CAB7nPqSusiasdiHwo=DVSnWgK77=iw4wzDi4OBt1UY7Vm3ii+A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Oct 21, 2014 at 4:02 PM, nurul [via PostgreSQL]
<ml-node+s1045698n5823774h72(at)n5(dot)nabble(dot)com> wrote:
>
> We have install PostgreSQL 9.3 in Ubuntu. We want to ask it is possible to do log shipping replication in one machine with different port such as port 5435 as a master while 5436 as a slave? We also tried that process in one machine but still get an error in slave such as
Yes you can do that.
> warning: connection to the database failed, disabling startup checks:
> psql: FATAL: the database system is starting up
Did you enable hot_standby = on in postgresql.conf of the standby with
wal_level = hot_standby in postgresql.conf of the master? Those are
necessary requirements to make a standby accessible for read-only
operations, which is what it seems you are looking for.
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2014-10-24 09:56:17 | Re: ARMv5 |
| Previous Message | John R Pierce | 2014-10-24 08:12:44 | Re: Log-shipping replication in one machine |