Skip site navigation (1) Skip section navigation (2)

Re: cannot create new user in postgres

From: "mike" <mike(at)quadrent(dot)net>
To: <joydip(at)cal2(dot)vsnl(dot)net(dot)in>, "Anatoly K(dot) Lasareff" <tolik(at)aaanet(dot)ru>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: cannot create new user in postgres
Date: 2001-03-07 08:37:04
Message-ID: 000a01c0a6e1$cac7ad70$a973fea9@neutrino (view raw or flat)
Thread:
Lists: pgsql-admin
as user postgres simply do the following:
createuser username

that will promt you for a couple of questions, asking if you want that user
to beable to make databases and to add users.

Mike
----- Original Message -----
From: "Anatoly K. Lasareff" <tolik(at)aaanet(dot)ru>
To: <joydip(at)cal2(dot)vsnl(dot)net(dot)in>
Cc: <pgsql-admin(at)postgresql(dot)org>
Sent: Wednesday, March 07, 2001 2:42 AM
Subject: Re: cannot create new user in postgres


> >>>>> "j" == joydip  <joydip(at)cal2(dot)vsnl(dot)net(dot)in> writes:
>
>  j> Hi all
>
>  j> I have tried to configure the pg_hba.conf with
>
>  j> local        all
>  j> trust
>  j> host         all         127.0.0.1     255.255.255.255     trust
>
>  j> then i tried to run
>
>  j> psql -h localhost template1
>
>  j> but any of my domain failing to use postgresql .
>
>  j> They are showing error re no entry in pg_shadow.
>
>
>  j> though it was running in root ok with user postgres
>
>  j> Thanks in advance for the help
>
> Who is postgres superuser? Suppose it is 'pgsql', then try
>
> psql -U pgsql templateq
>
> --
> Anatoly K. Lasareff                 Email:    tolik(at)aaanet(dot)ru
> http://tolikus.hq.aaanet.ru:8080    Phone:      (8632)-710071
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>


In response to

Responses

pgsql-admin by date

Next:From: Silky MittalDate: 2001-03-07 09:33:52
Subject: Computer with Linux OS not shown on Computers with Windows OS
Previous:From: Anatoly K. LasareffDate: 2001-03-07 07:42:40
Subject: Re: cannot create new user in postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group