Обсуждение: Log-shipping replication in one machine

We have install PostgreSQL 9.3 in Ubuntu. We want to ask it is posibble 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

warning: connection to the database failed, disabling startup checks:
psql: FATAL: the database system is starting up

We do the log shipping replication process based on http://www.themagicnumber.es/replication-in-postgresql-i?lang=en

We hope all of you can help us to solve this problem. Thank you

---

On 10/21/2014 12:02 AM, nurul [via PostgreSQL] wrote:
>
> We do the log shipping replication process based on
> http://www.themagicnumber.es/replication-in-postgresql-i?lang=en

thats a rather old blog entry, appears to be talking about postgres 8.3



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast

On Tue, Oct 21, 2014 at 4:02 PM, nurul [via PostgreSQL]
<ml-node+s1045698n5823774h72@n5.nabble.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
withdifferent port such as port 5435 as a master while 5436 as a slave? We also tried that process in one machine but
stillget 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

Thank you for your response. May i know what is the difference between log shipping and streaming replication actually? I'm sorry i am very new in postgreSQL and still confused with these two  

---

On 10/26/2014 09:46 PM, nurul [via PostgreSQL] wrote:
> Thank you for your response. May i know what is the difference between
> log shipping and streaming replication actually? I'm sorry i am very new
> in postgreSQL and still confused with these two
>

For an overview see:

http://www.postgresql.org/docs/9.3/interactive/warm-standby.html

Short version:

1) Both deal with WAL files.

2) Log shipping ships the entire file (16MB by default) at a time.

3) Streaming ships records within the WAL file, so it works incrementally.


--
Adrian Klaver
adrian.klaver@aklaver.com