From: | Yogesh Mahajan <yogesh(dot)mahajan(at)enterprisedb(dot)com> |
---|---|
To: | Erik Wienhold <ewie(at)ewie(dot)name>, sarwarmd02(at)outlook(dot)com |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org>, "pgadmin-support lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Using non-Super user with PgAmdin |
Date: | 2022-12-08 04:16:15 |
Message-ID: | CAMa=N=ONgDc+FmtV8Xw=VSNa6RU_6j0VSKuNjHKcfVVAorCu2g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support pgsql-admin |
Hello,
Here is the documentation for
1.Adding pistgres server to pgAdmin -
https://www.pgadmin.org/docs/pgadmin4/6.17/server_dialog.html
2.Conecting to server -
https://www.pgadmin.org/docs/pgadmin4/6.17/connect_to_server.html
3.Connection errors -
https://www.pgadmin.org/docs/pgadmin4/6.17/connect_error.html
4.Creating new role -
https://www.pgadmin.org/docs/pgadmin4/6.17/role_dialog.html#
Thanks,
Yogesh Mahajan
EnterpriseDB
On Thu, Dec 8, 2022 at 7:04 AM Erik Wienhold <ewie(at)ewie(dot)name> wrote:
> Hi Sarwar,
>
> > On 08/12/2022 00:51 CET M Sarwar <sarwarmd02(at)outlook(dot)com> wrote:
> >
> > I have created a user with my name and unable to verify the same using
> pgadmin
> > or any other way. For many of you this question is a novice. I am
> seeking the
> > help after spending sometime on this. You can point me to the document
> if you
> > or anybody can think of anything or find it.
> > Thank you!
> > Sarwar
>
> A few questions:
>
> * What Postgres version do you use?
>
> * What error message do you get when connecting with your new user? I
> assume
> that you get an error when you say "unable to verify".
>
> * How did you create that user? Was it CREATE USER[1] or createuser via
> command
> line? In case of CREATE ROLE[2] you must also specify attribute LOGIN
> which
> effectively is the same as CREATE USER. The login privilege must also be
> enabled when creating roles via pgAdmin.[3]
>
> * What does your pg_hba.conf[4] look like? You must configure the right
> databases, usernames, and client addresses before connecting.
>
> [1] https://www.postgresql.org/docs/current/sql-createuser.html
> [2] https://www.postgresql.org/docs/current/sql-createrole.html
> [3] https://www.pgadmin.org/docs/pgadmin4/latest/role_dialog.html
> [4] https://www.postgresql.org/docs/current/auth-pg-hba-conf.html
>
> P.S. Please don't hijack threads.
>
> --
> Erik
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Gunnar Venaas | 2022-12-08 19:08:57 | RE: Using non-Super user with PgAmdin |
Previous Message | Erik Wienhold | 2022-12-08 01:34:35 | Re: Using non-Super user with PgAmdin |
From | Date | Subject | |
---|---|---|---|
Next Message | S, Kamaldeen | 2022-12-08 13:34:29 | Delaying apply log files in replica node |
Previous Message | Erik Wienhold | 2022-12-08 01:34:35 | Re: Using non-Super user with PgAmdin |