pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUsing non-Super user with PgAmdin
6+ messages / 5 participants
[nested] [flat]
* Using non-Super user with PgAmdin
@ 2022-12-07 23:00 M Sarwar <sarwarmd02@outlook.com>
2022-12-07 23:18 ` Re: Using non-Super user with PgAmdin JP Pozzi <jpp@jppozzi.dyndns.org>
0 siblings, 1 reply; 6+ messages in thread
From: M Sarwar @ 2022-12-07 23:00 UTC (permalink / raw)
To: pgsql-admin
Hello All,
After working in the databases for the decades, recently I started a project postgress side newly.
I have a question on pgadmin access.
Can I use other than super user to login into pgadmin?
I am trying to provide access to all the development team members without giving them access to super user, postgress.
Thanks,
Sarwar
8 times ocp dba
3 cloud certificates
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Using non-Super user with PgAmdin
2022-12-07 23:00 Using non-Super user with PgAmdin M Sarwar <sarwarmd02@outlook.com>
@ 2022-12-07 23:18 ` JP Pozzi <jpp@jppozzi.dyndns.org>
2022-12-07 23:51 ` Re: Using non-Super user with PgAmdin M Sarwar <sarwarmd02@outlook.com>
2022-12-08 19:08 ` RE: Using non-Super user with PgAmdin Gunnar Venaas <gunnar@venaas.org>
0 siblings, 2 replies; 6+ messages in thread
From: JP Pozzi @ 2022-12-07 23:18 UTC (permalink / raw)
To: M Sarwar <sarwarmd02@outlook.com>; +Cc: pgsql-admin
Hello,
It's quite normal and smart not to give developers superuser rights and Pgadmin is OK with that.
Regards
JP P
De: "M Sarwar" <sarwarmd02@outlook.com>
À: "pgsql-admin" <pgsql-admin@postgresql.org>
Envoyé: Jeudi 8 Décembre 2022 00:00:09
Objet: Using non-Super user with PgAmdin
Hello All,
After working in the databases for the decades, recently I started a project postgress side newly.
I have a question on pgadmin access.
Can I use other than super user to login into pgadmin?
I am trying to provide access to all the development team members without giving them access to super user, postgress.
Thanks,
Sarwar
8 times ocp dba
3 cloud certificates
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Using non-Super user with PgAmdin
2022-12-07 23:00 Using non-Super user with PgAmdin M Sarwar <sarwarmd02@outlook.com>
2022-12-07 23:18 ` Re: Using non-Super user with PgAmdin JP Pozzi <jpp@jppozzi.dyndns.org>
@ 2022-12-07 23:51 ` M Sarwar <sarwarmd02@outlook.com>
2022-12-08 01:34 ` Re: Using non-Super user with PgAmdin Erik Wienhold <ewie@ewie.name>
1 sibling, 1 reply; 6+ messages in thread
From: M Sarwar @ 2022-12-07 23:51 UTC (permalink / raw)
To: JP Pozzi <jpp@jppozzi.dyndns.org>; +Cc: pgsql-admin
Hello JP,
I appreciate the response. Actually, I have been spending time on postgress, pgadmin and google sites could not find help on this.
I tried to log off from pgadmin and it is not allowing me to log off pgadmin and re-enter the credentials.The only way to log off is CLICK X button of pgadmin.
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
________________________________
From: JP Pozzi <jpp@jppozzi.dyndns.org>
Sent: Wednesday, December 7, 2022 6:18 PM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Using non-Super user with PgAmdin
Hello,
It's quite normal and smart not to give developers superuser rights and Pgadmin is OK with that.
Regards
JP P
________________________________
De: "M Sarwar" <sarwarmd02@outlook.com>
À: "pgsql-admin" <pgsql-admin@postgresql.org>
Envoyé: Jeudi 8 Décembre 2022 00:00:09
Objet: Using non-Super user with PgAmdin
Hello All,
After working in the databases for the decades, recently I started a project postgress side newly.
I have a question on pgadmin access.
Can I use other than super user to login into pgadmin?
I am trying to provide access to all the development team members without giving them access to super user, postgress.
Thanks,
Sarwar
8 times ocp dba
3 cloud certificates
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Using non-Super user with PgAmdin
2022-12-07 23:00 Using non-Super user with PgAmdin M Sarwar <sarwarmd02@outlook.com>
2022-12-07 23:18 ` Re: Using non-Super user with PgAmdin JP Pozzi <jpp@jppozzi.dyndns.org>
2022-12-07 23:51 ` Re: Using non-Super user with PgAmdin M Sarwar <sarwarmd02@outlook.com>
@ 2022-12-08 01:34 ` Erik Wienhold <ewie@ewie.name>
2022-12-08 04:16 ` Re: Using non-Super user with PgAmdin Yogesh Mahajan <yogesh.mahajan@enterprisedb.com>
0 siblings, 1 reply; 6+ messages in thread
From: Erik Wienhold @ 2022-12-08 01:34 UTC (permalink / raw)
To: M Sarwar <sarwarmd02@outlook.com>; +Cc: pgsql-admin
Hi Sarwar,
> On 08/12/2022 00:51 CET M Sarwar <sarwarmd02@outlook.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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Using non-Super user with PgAmdin
2022-12-07 23:00 Using non-Super user with PgAmdin M Sarwar <sarwarmd02@outlook.com>
2022-12-07 23:18 ` Re: Using non-Super user with PgAmdin JP Pozzi <jpp@jppozzi.dyndns.org>
2022-12-07 23:51 ` Re: Using non-Super user with PgAmdin M Sarwar <sarwarmd02@outlook.com>
2022-12-08 01:34 ` Re: Using non-Super user with PgAmdin Erik Wienhold <ewie@ewie.name>
@ 2022-12-08 04:16 ` Yogesh Mahajan <yogesh.mahajan@enterprisedb.com>
0 siblings, 0 replies; 6+ messages in thread
From: Yogesh Mahajan @ 2022-12-08 04:16 UTC (permalink / raw)
To: Erik Wienhold <ewie@ewie.name>; sarwarmd02@outlook.com; +Cc: pgsql-admin; pgadmin-support lists.postgresql.org <pgadmin-support@lists.postgresql.org>
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@ewie.name> wrote:
> Hi Sarwar,
>
> > On 08/12/2022 00:51 CET M Sarwar <sarwarmd02@outlook.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
>
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* RE: Using non-Super user with PgAmdin
2022-12-07 23:00 Using non-Super user with PgAmdin M Sarwar <sarwarmd02@outlook.com>
2022-12-07 23:18 ` Re: Using non-Super user with PgAmdin JP Pozzi <jpp@jppozzi.dyndns.org>
@ 2022-12-08 19:08 ` Gunnar Venaas <gunnar@venaas.org>
1 sibling, 0 replies; 6+ messages in thread
From: Gunnar Venaas @ 2022-12-08 19:08 UTC (permalink / raw)
To: 'JP Pozzi' <jpp@jppozzi.dyndns.org>; 'M Sarwar' <sarwarmd02@outlook.com>; +Cc: pgsql-admin
This is not a “smart” approach.
The application should run with “least privilege”, and the developers should develop within the same context.
There are far to many applications that demands some sort of elevated permissions to work.
Gunnar Venaas
gunnar@venaas.org <mailto:gunnar@venaas.org>
932 85 069
From: JP Pozzi <jpp@jppozzi.dyndns.org>
Sent: torsdag 8. desember 2022 00:19
To: M Sarwar <sarwarmd02@outlook.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Using non-Super user with PgAmdin
Hello,
It's quite normal and smart not to give developers superuser rights and Pgadmin is OK with that.
Regards
JP P
_____
De: "M Sarwar" <sarwarmd02@outlook.com <mailto:sarwarmd02@outlook.com> >
À: "pgsql-admin" <pgsql-admin@postgresql.org <mailto:pgsql-admin@postgresql.org> >
Envoyé: Jeudi 8 Décembre 2022 00:00:09
Objet: Using non-Super user with PgAmdin
Hello All,
After working in the databases for the decades, recently I started a project postgress side newly.
I have a question on pgadmin access.
Can I use other than super user to login into pgadmin?
I am trying to provide access to all the development team members without giving them access to super user, postgress.
Thanks,
Sarwar
8 times ocp dba
3 cloud certificates
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2022-12-08 19:08 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-12-07 23:00 Using non-Super user with PgAmdin M Sarwar <sarwarmd02@outlook.com>
2022-12-07 23:18 ` JP Pozzi <jpp@jppozzi.dyndns.org>
2022-12-07 23:51 ` M Sarwar <sarwarmd02@outlook.com>
2022-12-08 01:34 ` Erik Wienhold <ewie@ewie.name>
2022-12-08 04:16 ` Yogesh Mahajan <yogesh.mahajan@enterprisedb.com>
2022-12-08 19:08 ` Gunnar Venaas <gunnar@venaas.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox