Re: Streaming replication issue

Luca Ferrari <[email protected]>
Newsgroups gmane.comp.db.postgresql.admin
Message-ID <CAKoxK+6egeUv-zzMBXfHuFAZtr=X5ZgRZsvnhk_O821ndsrv+A@mail.gmail.com>
On Thu, Sep 5, 2019 at 11:39 AM mallikarjun t <[email protected]> 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
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.