From: | mallikarjun t <mallit333(at)gmail(dot)com> |
---|---|
To: | Luca Ferrari <fluca1978(at)gmail(dot)com> |
Cc: | soumitra bhandary <soumitra(dot)bhandary(at)hotmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Streaming replication issue |
Date: | 2019-09-05 12:45:11 |
Message-ID: | CAOA8XiUp1DaEC4VFeE-G3N2=Ck4goM-VZvr9oEM--YQeG_QUKQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)gmail(dot)com> wrote:
> On Thu, Sep 5, 2019 at 1:54 PM mallikarjun t <mallit333(at)gmail(dot)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_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
>
From | Date | Subject | |
---|---|---|---|
Next Message | gilberto.castillo | 2019-09-05 13:05:46 | Re: [MASSMAIL]Re: Streaming replication issue |
Previous Message | Luca Ferrari | 2019-09-05 12:28:21 | Re: Streaming replication issue |