Re: Streaming replication issue

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 <[email protected]> wrote:

> On Thu, Sep 5, 2019 at 1:54 PM mallikarjun t <[email protected]> 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_Guide_Linux_v11.pdf
> >
> the database to connect to is 'edb' with user 'enterprisedb'.
> So does
> psql -U enterprisedb edb
> allow you to connect to your cluster?
>
> Luca
>