Thread: cannot create new user in postgres

cannot create new user in postgres

From
joydip@cal2.vsnl.net.in
Date:
  Hi all

    I have tried to configure the pg_hba.conf with

   local        all
                                                                   trust
   host         all         127.0.0.1     255.255.255.255     trust

   then i tried to run

   psql -h localhost template1

   but any of my domain failing to use postgresql .

   They are showing error re no entry in pg_shadow.


   though it was running in root ok with user postgres

   Thanks in advance for the help



  Joydip Chakladar
  www.allindialive.com



 -----  Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web  -----
  http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups
   NewsOne.Net prohibits users from posting spam.  If this or other posts
made through NewsOne.Net violate posting guidelines, email abuse@newsone.net

Re: cannot create new user in postgres

From
tolik@aaanet.ru (Anatoly K. Lasareff)
Date:
>>>>> "j" == joydip  <joydip@cal2.vsnl.net.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@aaanet.ru
http://tolikus.hq.aaanet.ru:8080    Phone:      (8632)-710071

Re: cannot create new user in postgres

From
"mike"
Date:
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@aaanet.ru>
To: <joydip@cal2.vsnl.net.in>
Cc: <pgsql-admin@postgresql.org>
Sent: Wednesday, March 07, 2001 2:42 AM
Subject: Re: cannot create new user in postgres


> >>>>> "j" == joydip  <joydip@cal2.vsnl.net.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@aaanet.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@postgresql.org so that your
> message can get through to the mailing list cleanly
>


Re: Re: cannot create new user in postgres

From
joydip@cal2.vsnl.net.in
Date:
Dear Mike,

    I am trying to create the user but it was giving folllowing errors

    [postgres@ns data]$ su siddharta
    su: user siddharta does not exist

    This is how I created the user........

    [postgres@ns data]$ createuser siddharta
    Enter user's postgres ID -> 567
    Is user "siddharta" allowed to create databases (y/n) y
    Is user "siddharta" a superuser? (y/n) y
    createuser: siddharta was successfully added

    I am looking 4 seriuos help.

    Thanks in advance







In article <000a01c0a6e1$cac7ad70$a973fea9@neutrino>, "mike"
<mike@quadrent.net> writes:
>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@aaanet.ru>
>To: <joydip@cal2.vsnl.net.in>
>Cc: <pgsql-admin@postgresql.org>
>Sent: Wednesday, March 07, 2001 2:42 AM
>Subject: Re: cannot create new user in postgres
>
>
>> >>>>> "j" == joydip
<joydip@cal2.vsnl.net.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@aaanet.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@postgresql.org so that your
>> message can get through to the mailing list cleanly
>>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster




 -----  Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web  -----
  http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups
   NewsOne.Net prohibits users from posting spam.  If this or other posts
made through NewsOne.Net violate posting guidelines, email abuse@newsone.net

Re: Re: cannot create new user in postgres

From
jdassen@cistron.nl (J.H.M. Dassen (Ray))
Date:
joydip@cal2.vsnl.net.in <joydip@cal2.vsnl.net.in> wrote:
>    I am trying to create the user but it was giving folllowing errors
>
>    [postgres@ns data]$ su siddharta
>    su: user siddharta does not exist

Meaning: there is no Unix user 'siddharta' on your system.

>    This is how I created the user........

[createuser]

Meaning: there is now a PostgreSQL database user 'siddharta'.

PostgreSQL uses a user system that is separate from the underlying operating
system. There is no problem, just a misunderstanding on your part. You can
now use the database user you created with PostgreSQL's commands, e.g
"psql -U siddharta".

HTH,
Ray
--
"If we put in English phrases, that makes it readable".  That's COBOL.
    Larry Wall on common fallacies of language design