pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: John Wiencek <jwiencek3@comcast.net>
To: mallikarjun t <mallit333@gmail.com>
Cc: Luca Ferrari <fluca1978@gmail.com>
Cc: soumitra bhandary <soumitra.bhandary@hotmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Streaming replication issue
Date: Thu, 5 Sep 2019 10:54:26 -0500
Message-ID: <E28CBC70-3EB7-45AB-B3BC-882FEBDCECCF@comcast.net> (raw)
In-Reply-To: <CAOA8XiX-iKs4XqTEMOfRWMtsGRV0S8O6ED0+EB1Y4VuGMsNRhw@mail.gmail.com>
References: <CAOA8XiVtkOXOEXQzq0B7Cg-zFwwqa6+-BfyaiLgn9CiWL_-_pw@mail.gmail.com>
	<CAKoxK+6egeUv-zzMBXfHuFAZtr=X5ZgRZsvnhk_O821ndsrv+A@mail.gmail.com>
	<CAOA8XiWAcatiS7EDLcmO5frkwj9AncC+JB_DBXfrBWowrajN+w@mail.gmail.com>
	<BMXPR01MB36398157DAFCFBC93CA89C7DE0BB0@BMXPR01MB3639.INDPRD01.PROD.OUTLOOK.COM>
	<CAOA8XiU+MYk2JCjTdTvUzApDM2hz_5m700=MTDLkcOUZp99bBw@mail.gmail.com>
	<CAKoxK+6OR4qN4LH9yhJd2mYzEfGpQXcLhKFSjv2FMNEY4CE0eg@mail.gmail.com>
	<CAOA8XiUOnd-0qYjNdkuG6Y+UdB4jV+ExTpfhQy6nfSjKR1ui-A@mail.gmail.com>
	<CAKoxK+6RTkuQ5qE-_Fh1_q0Qy0oyc+JKwE3iyOoDaLHCUWtA4g@mail.gmail.com>
	<CAOA8XiUp1DaEC4VFeE-G3N2=Ck4goM-VZvr9oEM--YQeG_QUKQ@mail.gmail.com>
	<CAKoxK+6BMswm0oayBzHWUuDzkG+M0zR3HfOi1NEu+X9j-pQnBg@mail.gmail.com>
	<CAOA8XiX-iKs4XqTEMOfRWMtsGRV0S8O6ED0+EB1Y4VuGMsNRhw@mail.gmail.com>

H

When you set up streaming replication your read-only replica should be created using pg_basebackup.

for example;

Run this from the streamed/slave server.   Set variable $PGDATA.  Make sure directory structure exits and is empty( no file in $PGDATA on slave server)

pg_basebackup --pgdata=$PGDATA --label=standby --host 10.64.98.199--usernamerepuser --wal-method=stream --write-recovery-conf.


Your PGDATA direetory on the streamed/salve server needs to be empty.   The basebackup will copy ALL files from the master to the slave.   This would include PostgreSQL.conf , pg_hba.conf and all associated files for the databases.

Therefore the streaming/slave server will be EXACTLY the same as the master.   Same users, same port, same data.


Reagards

John Wiencek



> On Sep 5, 2019, at 10:27 AM, mallikarjun t <mallit333@gmail.com> wrote:
> 
> No I am connected salve server details to connect
> 
> On Thu, Sep 5, 2019, 8:52 PM Luca Ferrari <fluca1978@gmail.com <mailto:fluca1978@gmail.com>> wrote:
> On Thu, Sep 5, 2019 at 2:45 PM mallikarjun t <mallit333@gmail.com <mailto:mallit333@gmail.com>> wrote:
> > I want connect to sever by using following command  /opt/edb/as9.6/bin/psql
> >
> >
> > role "postgres" not a log in permission error message  I am getting , I am try to put port number along with that
> > error: could not connect to the server, locally running this port number 5432.
> >
> 
> I'm sorry but it is quite hard to understand what you are doing.
> If I'm getting right, from you description, you are replicating your
> server and trying to connect as 'postgres' to such clone, but how can
> the clone has a user that did not existed (or did not have
> permissions) on the original server too?
> I thinm you should connect to the "new master" with the same "old
> master" credentials.
> 
> Luca

view thread (22+ messages)  latest in thread

Message-ID: <E28CBC70-3EB7-45AB-B3BC-882FEBDCECCF@comcast.net>
Permalink:  ../E28CBC70-3EB7-45AB-B3BC-882FEBDCECCF@comcast.net/
Also on:    postgresql.org/message-id/E28CBC70-3EB7-45AB-B3BC-882FEBDCECCF@comcast.net

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: jwiencek3@comcast.net, mallit333@gmail.com, fluca1978@gmail.com, soumitra.bhandary@hotmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Streaming replication issue
  In-Reply-To: <E28CBC70-3EB7-45AB-B3BC-882FEBDCECCF@comcast.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox