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.