This is for testing purposes I am checking, we can do streaming replication between same server version is possible, but EDB Advanced servers is possible or not? I have doubt, but it is possible but these are the error messages are coming to connected. How to resolve this issue?
Regards,
Malli.
On Thu, Sep 5, 2019 at 4:04 PM soumitra bhandary <soumitra.bhandary@xxxxxxxxxxx> wrote:
Create one postgres os user in slave similar in master and then try once
Sent from my iPhoneI tried different ways it is not connected, but streaming replication is happening. IAM happily connected to master server, not the slave server, what reason I don't know? I think postgres user don't have login permission on Edb advanced server , by default Enterprise db user is there. That's why it's not connected I am thinking. Any one know about this one please clarify the issue.
Regards,Malli.
On Thu, Sep 5, 2019, 3:26 PM Luca Ferrari <fluca1978@xxxxxxxxx> wrote:
On Thu, Sep 5, 2019 at 11:39 AM mallikarjun t <mallit333@xxxxxxxxx> wrote:
> ERROR: psql.bin: FATAL: role "postgres" is not permitted to log in
I don't know about EDB, but sounds like role postgres has not the
login privilege, that is they use another administrator?
> ./psql -p 5432
>
> psql.bin: could not connect to server: No such file or directory
>
> Is the server running locally and accepting connections on unix domain socket.
>
> "/tmp/.s.PGSQL.5432"?
Without the -h localhost option psql tries to connect to unix socket,
not TCP/IP, and it could be your server is not listening on unix
socket.
Luca
