El 2019-09-05 09:39, mallikarjun t escribió:
> Dear Gilberto,
>
> ./psql -p 5444 -d edb -U enterprisedb this one is accessing the EDB
> Advanced Server by using this command.
> Iam already checked the logs role "postgres" is not a login permission
> error message is there.
Do you check it?
/opt/edb/as9.6/bin/pg_ctl -p 5444 -D /home/postgres/data_96 start
>
> Regards,
> Malli.
>
> On Thu, Sep 5, 2019 at 6:35 PM <[email protected]> wrote:
>
>> 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.