Re: Streaming replication issue

mallikarjun t <[email protected]>
Newsgroups gmane.comp.db.postgresql.admin
Message-ID <CAOA8XiWAcatiS7EDLcmO5frkwj9AncC+JB_DBXfrBWowrajN+w@mail.gmail.com>
I 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 <[email protected]> wrote:

> 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.