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 <[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
lmpx.com only provides a reader for public news (NNTP) servers. It is not
affiliated with the servers or forums shown here and is not responsible for
the content of articles, which is written by their respective authors.