Unsubscribe

Please unsubscribe me to all PostgreSQL mailing lists.

Thanks and best regards
Meenakshi Ramamoorthi

From: Frank Cavaliero [mailto:fcavalie(at)us(dot)ibm(dot)com]
Sent: Monday, November 20, 2017 10:31 AM
To: pgsql-admin(at)postgresql(dot)org; pgsql-general(at)lists(dot)postgresql(dot)org; pgsql-general(at)postgresql(dot)org
Subject: UNSUBSCRIBE

PLEASE UNSUBSCRIBE ME TO ALL pgsql* mailing lists.

Thanks.

[IBM]

________________________________

From: rammohan ganapavarapu <rammohanganap(at)gmail(dot)com<mailto:rammohanganap(at)gmail(dot)com>>
To: gparc(at)free(dot)fr<mailto:gparc(at)free(dot)fr>, pgsql-admin(at)postgresql(dot)org<mailto:pgsql-admin(at)postgresql(dot)org>
Date: 11/20/2017 01:25 PM
Subject: Re: [ADMIN] Can master and slave on different PG versions?

________________________________

Gilles,

Thank you, if we set wal_level in version <= 9.6 to "logical" what does it mean what does it do? do we still call it as logical replication? also how to tell if my replication is logical or physical. Please excuse me if i am asking stupid questions :) i am new to Postgres.

Ram

On Mon, Nov 20, 2017 at 2:20 AM, <gparc(at)free(dot)fr<mailto:gparc(at)free(dot)fr>> wrote:

Hello,

yes, before postgres version 10, you must use an extension such as pg_logical
to build logical replication between master and slave.

For pg_logical, see the following links to help you start :
https://www.2ndquadrant.com/en/resources/pglogical/pglogical-docs/<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.2ndquadrant.com_en_resources_pglogical_pglogical-2Ddocs_&d=DwMFaQ&c=jf_iaSHvJObTbx-siA1ZOg&r=_GnCTcDYUX5mV2S5BIlW41N9EY5jv7hC4Nh434sahtc&m=sPmMDO8jRhRCChz1aU-SC2N0iRWPazxEwcsGNLtOvwc&s=BSsfUJV7vWF79TvfilrkQY_yZnjlhahcVwR5pKZmyf0&e=>
http://bonesmoses.org/2016/10/14/pg-phriday-perfectly-logical/<https://urldefense.proofpoint.com/v2/url?u=http-3A__bonesmoses.org_2016_10_14_pg-2Dphriday-2Dperfectly-2Dlogical_&d=DwMFaQ&c=jf_iaSHvJObTbx-siA1ZOg&r=_GnCTcDYUX5mV2S5BIlW41N9EY5jv7hC4Nh434sahtc&m=sPmMDO8jRhRCChz1aU-SC2N0iRWPazxEwcsGNLtOvwc&s=A61U_G-oIuRTcrQCT2TPmoDD7os-HMfAyISWBUCfcsI&e=>
https://www.depesz.com/2016/11/08/major-version-upgrading-with-minimal-downtime/<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.depesz.com_2016_11_08_major-2Dversion-2Dupgrading-2Dwith-2Dminimal-2Ddowntime_&d=DwMFaQ&c=jf_iaSHvJObTbx-siA1ZOg&r=_GnCTcDYUX5mV2S5BIlW41N9EY5jv7hC4Nh434sahtc&m=sPmMDO8jRhRCChz1aU-SC2N0iRWPazxEwcsGNLtOvwc&s=fc6EAX2CmKok-xSJjIPqadadgmAA8CqkA3NQaqefRTk&e=>

Regards
Gilles

----- Mail original -----
De: "rammohan ganapavarapu" <rammohanganap(at)gmail(dot)com<mailto:rammohanganap(at)gmail(dot)com>>
À: gparc(at)free(dot)fr<mailto:gparc(at)free(dot)fr>, pgsql-admin(at)postgresql(dot)org<mailto:pgsql-admin(at)postgresql(dot)org>
Envoyé: Vendredi 17 Novembre 2017 16:43:57
Objet: Re: [ADMIN] Can master and slave on different PG versions?

Hi,

I was using pg_basebackup to rebuild slave, so pglogical is not in-built in postgres and I have to install?

Thanks

On Nov 17, 2017 12:42 AM, < gparc(at)free(dot)fr<mailto:gparc(at)free(dot)fr>> wrote:

Hello,

How did you create the slave ? with pg_basebackup or via rsync ?
In any case, the slave MUST have been built with a backup/rsync made AFTER the master have been restarted when you changed
wal_level to logical.

Note, that you did so far, set wal_level=logical, is just a prerequisite to use logical replication.
After that, you need a tool which will extract the changes in the WALs from the master and will replay them on the slave.

Such tool is pg_logical : https://www.2ndquadrant.com/en/resources/pglogical/<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.2ndquadrant.com_en_resources_pglogical_&d=DwMFaQ&c=jf_iaSHvJObTbx-siA1ZOg&r=_GnCTcDYUX5mV2S5BIlW41N9EY5jv7hC4Nh434sahtc&m=sPmMDO8jRhRCChz1aU-SC2N0iRWPazxEwcsGNLtOvwc&s=T7LWZgZq2ItSyvRlEEV7c2uPh_LVic2xEodM9cyBf20&e=>

Regards

----- Mail original -----
De: "rammohan ganapavarapu" < rammohanganap(at)gmail(dot)com<mailto:rammohanganap(at)gmail(dot)com>>
À: gparc(at)free(dot)fr<mailto:gparc(at)free(dot)fr>, pgsql-admin(at)postgresql(dot)org<mailto:pgsql-admin(at)postgresql(dot)org>
Envoyé: Jeudi 16 Novembre 2017 17:58:42

Objet: Re: [ADMIN] Can master and slave on different PG versions?

From Slave (9.6):

Database cluster state: shut down in recovery

wal_level setting: logical

From master (9.4) :

Database cluster state: in production

Current wal_level setting: logical

Quite frankly i couldn't find proper document on how to set logical replication in 9.4, i think i am using pg_logical. All i did was set wal_level to logical and add primary_slot_name in recovery.conf. Do i need to install pglogical extension? i couldn't find one for amazon linux.

Thanks,
Ram

On Thu, Nov 16, 2017 at 6:12 AM, < gparc(at)free(dot)fr<mailto:gparc(at)free(dot)fr>> wrote:

Hello again,

can you execute pg_controldata command on both Master and Slave
and check the following properties :
Database cluster state
wal_level setting

Also, if I understand correctly, you want to establish logical replication between your 9.4 master
and your 9.6 slave but you don't explain how ? using pg_logical ?

Regards

----- Mail original -----
De: "rammohan ganapavarapu" < rammohanganap(at)gmail(dot)com<mailto:rammohanganap(at)gmail(dot)com>>
À: "David G. Johnston" < david(dot)g(dot)johnston(at)gmail(dot)com<mailto:david(dot)g(dot)johnston(at)gmail(dot)com>>
Cc: pgsql-admin(at)postgresql(dot)org<mailto:pgsql-admin(at)postgresql(dot)org>
Envoyé: Mercredi 15 Novembre 2017 22:23:57
Objet: Re: [ADMIN] Can master and slave on different PG versions?

Any one tried this before?

On Wed, Nov 8, 2017 at 8:17 AM, rammohan ganapavarapu < rammohanganap(at)gmail(dot)com<mailto:rammohanganap(at)gmail(dot)com>> wrote:

David,

So initially i have physical replication configured, so to upgrade slave to 9.6 version i did converted master slave to logical replication and then try to upgrade the slave to 9.6. I am getting this error when i try to start the slave. Any idea?

2017-11-08 05:08:49 UTC [20063]: [1-1] user= db= host= LOG: shutting down
2017-11-08 05:08:49 UTC [20063]: [2-1] user= db= host= LOG: database system is shut down
2017-11-08 05:09:45 UTC [20322]: [1-1] user= db= host= LOG: database system was shut down at 2017-11-08 05:08:55 UTC
2017-11-08 05:09:45 UTC [20322]: [2-1] user= db= host= LOG: entering standby mode
2017-11-08 05:09:45 UTC [20322]: [3-1] user= db= host= WARNING: WAL was generated with wal_level=minimal, data may be missing
2017-11-08 05:09:45 UTC [20322]: [4-1] user= db= host= HINT: This happens if you temporarily set wal_level=minimal without taking a new base backup.
2017-11-08 05:09:45 UTC [20322]: [5-1] user= db= host= FATAL: hot standby is not possible because wal_level was not set to "replica" or higher on the master server
2017-11-08 05:09:45 UTC [20322]: [6-1] user= db= host= HINT: Either set wal_level to "replica" on the master, or turn off hot_standby here.
2017-11-08 05:09:45 UTC [20312]: [3-1] user= db= host= LOG: startup process (PID 20322) exited with exit code 1
2017-11-08 05:09:45 UTC [20312]: [4-1] user= db= host= LOG: aborting startup due to startup process failure
2017-11-08 05:09:45 UTC [20312]: [5-1] user= db= host= LOG: database system is shut down

Thanks,
Ram

On Mon, Oct 9, 2017 at 4:15 PM, David G. Johnston < david(dot)g(dot)johnston(at)gmail(dot)com<mailto:david(dot)g(dot)johnston(at)gmail(dot)com>> wrote:

On Mon, Oct 9, 2017 at 4:06 PM, rammohan ganapavarapu < rammohanganap(at)gmail(dot)com<mailto:rammohanganap(at)gmail(dot)com>> wrote:

Hi,

Is it possible to add 9.6 version Slave to 9.4 master?

​Physical replication, no; Logical replication, yes - if the software you are using is compatible with both versions.

David J.​