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
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 |