Re: Streaming replication issue

From: mallikarjun t <mallit333(at)gmail(dot)com>
To: Luca Ferrari <fluca1978(at)gmail(dot)com>
Cc: soumitra bhandary <soumitra(dot)bhandary(at)hotmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Streaming replication issue
Date: 2019-09-05 15:27:45
Message-ID: CAOA8XiX-iKs4XqTEMOfRWMtsGRV0S8O6ED0+EB1Y4VuGMsNRhw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

No I am connected salve server details to connect

On Thu, Sep 5, 2019, 8:52 PM Luca Ferrari <fluca1978(at)gmail(dot)com> wrote:

> On Thu, Sep 5, 2019 at 2:45 PM mallikarjun t <mallit333(at)gmail(dot)com> wrote:
> > 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.
> >
>
> I'm sorry but it is quite hard to understand what you are doing.
> If I'm getting right, from you description, you are replicating your
> server and trying to connect as 'postgres' to such clone, but how can
> the clone has a user that did not existed (or did not have
> permissions) on the original server too?
> I thinm you should connect to the "new master" with the same "old
> master" credentials.
>
> Luca
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message John Wiencek 2019-09-05 15:54:26 Re: Streaming replication issue
Previous Message Luca Ferrari 2019-09-05 15:22:12 Re: Streaming replication issue