- PostgreSQL Replication Types

From: Will McCormick <wmccormick(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: - PostgreSQL Replication Types
Date: 2015-12-17 15:17:47
Message-ID: CA+jgkY6cDEqdY0Z-yk1fk6-9WXirWQpKtPSsaRSGRafbYt-0FA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I inherited a 9.1 replication environment

Few basic questions that I can't find clear answers / clarifications for if
possible:

3 types of replication in 9.1 I've read about from the offical docs:

1) warm standby
2) hot standby
3) streaming replication

I'm using streaming replication I believe, the only indication I have is
that there is the primary_conninfo on the standby. Is this the only
indication?

Is it possible to get if using streaming replication under normal
operations?

*cp: cannot stat `/opt/postgres/9.1/archive/000000070000000F00000057': No
such file or directory*

*cp: cannot stat `/opt/postgres/9.1/archive/000000070000000F00000057': No
such file or directory*

*LOG: streaming replication successfully connected to primary*

*FATAL: could not receive data from WAL stream: FATAL: requested WAL
segment 000000070000000F00000057 has already been removed*

My understanding is that warm standby and hot standby do log shipping and
there is a greater window for transactions not to be send to the standby
because WAL XLOG must be filled.

Whereas Streaming replication basically sends at the transaction level?

I'm sure this is somewhat misinformed!

Thanks,

Will

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-12-17 15:37:39 Re: - PostgreSQL Replication Types
Previous Message Adrian Klaver 2015-12-17 05:04:26 Re: Fwd: dblink_connect fails