pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Erik Wienhold <ewie@ewie.name>
To: M Sarwar <sarwarmd02@outlook.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Using non-Super user with PgAmdin
Date: Thu, 8 Dec 2022 02:34:35 +0100 (CET)
Message-ID: <831227649.401736.1670463275062@office.mailbox.org> (raw)
In-Reply-To: <DM4PR19MB597865AC67C826FD2E2D439FD31A9@DM4PR19MB5978.namprd19.prod.outlook.com>
References: <CAHJZqBCWK8thYBSLsAQrq=k4tN1AHV9RRd5yVEEcziQuwLb8sQ@mail.gmail.com>
	<CAMkU=1ybQA6cGN_boRF1-W4rjqesM=F+u4eZ2Wfw7_KoT9wvrA@mail.gmail.com>
	<CAHJZqBBqdH63TyFRB0dJxDCCRLwtJHHMa3gBbvWSPqXTTeDc4Q@mail.gmail.com>
	<DM4PR19MB59781B9093A74C1FE1A243CFD31A9@DM4PR19MB5978.namprd19.prod.outlook.com>
	<1248013365.2011.1670455113858.JavaMail.zimbra@jppozzi.dyndns.org>
	<DM4PR19MB597865AC67C826FD2E2D439FD31A9@DM4PR19MB5978.namprd19.prod.outlook.com>

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





view thread (6+ messages)  latest in thread

Message-ID: <831227649.401736.1670463275062@office.mailbox.org>
Permalink:  ../831227649.401736.1670463275062@office.mailbox.org/
Also on:    postgresql.org/message-id/831227649.401736.1670463275062@office.mailbox.org

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: ewie@ewie.name, sarwarmd02@outlook.com
  Subject: Re: Using non-Super user with PgAmdin
  In-Reply-To: <831227649.401736.1670463275062@office.mailbox.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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