| From: | Luca Ferrari <fluca1978(at)gmail(dot)com> |
|---|---|
| To: | mallikarjun t <mallit333(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:22:12 |
| Message-ID: | CAKoxK+6BMswm0oayBzHWUuDzkG+M0zR3HfOi1NEu+X9j-pQnBg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mallikarjun t | 2019-09-05 15:27:45 | Re: Streaming replication issue |
| Previous Message | mallikarjun t | 2019-09-05 14:10:38 | Re: Streaming replication issue |