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

help / color / mirror / Atom feed
From: gilberto.castillo@etecsa.cu
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: [MASSMAIL]Re: Streaming replication issue
Date: Thu, 05 Sep 2019 09:05:46 -0400
Message-ID: <348e59259ebb469677de80c8b4864a07@etecsa.cu> (raw)
In-Reply-To: <CAOA8XiUp1DaEC4VFeE-G3N2=Ck4goM-VZvr9oEM--YQeG_QUKQ@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>

Hello,

Please, you could check postgresql.log
or What is this : ./psql  -p 5444 -d edb -U enterprisedb.?

El 2019-09-05 08:45, mallikarjun t escribió:
> Dear  All,
> 
> Before streaming replication I will access EDB Advanced  Server below
> command by using psql
> 
> ./psql  -p 5444 -d edb -U enterprisedb.
> 
> I am happily working.
> 
> When I am starting replication process stop the server and take the
> basebackup of PostgreSQL Community version and start the new cluster.
> 
> for example
> 
> /opt/edb/as9.6/bin/pg_basebackup  -D  /home/postgres/data_96  -h
> <master ip address>  -p 5432  -X stream -R
> 
> I am  taking basebackup then  after recovery.conf file I include
> trigger_file ='/tmp/primary_down',
> 
> If my master is down unexpectedly, I will promote my Slave to Master.
> 
> the after I start the server by using following commnad
> 
> /opt/edb/as9.6/bin/pg_ctl    -D    /home/postgres/data_96  start
> 
> server started and wal receiver is working properly, but  real problem
> is happens here only,
> 
> 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.
> 
> this is the error message I am getting.
> 
> Regards,
> Malli.
> 
> On Thu, Sep 5, 2019 at 5:58 PM Luca Ferrari <fluca1978@gmail.com>
> wrote:
> 
>> On Thu, Sep 5, 2019 at 1:54 PM mallikarjun t <mallit333@gmail.com>
>> wrote:
>>> I tried these two compatibilities I will get the same issue.
>> 
>> According to the installation guide available at
>> 
> <https://www.enterprisedb.com/edb-docs/static/docs/epas/11/EDB_Postgres_Advanced_Server_Installation_...;
>> the database to connect to is 'edb' with user 'enterprisedb'.
>> So does
>> psql -U enterprisedb edb
>> allow you to connect to your cluster?
>> 
>> Luca





view thread (22+ messages)  latest in thread

Message-ID: <348e59259ebb469677de80c8b4864a07@etecsa.cu>
Permalink:  ../348e59259ebb469677de80c8b4864a07@etecsa.cu/
Also on:    postgresql.org/message-id/348e59259ebb469677de80c8b4864a07@etecsa.cu

 · 

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: gilberto.castillo@etecsa.cu, mallit333@gmail.com, fluca1978@gmail.com, soumitra.bhandary@hotmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: [MASSMAIL]Re: Streaming replication issue
  In-Reply-To: <348e59259ebb469677de80c8b4864a07@etecsa.cu>

* 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