Thread: cannot create new user in postgres
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
>>>>> "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
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 >
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
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