Thread: Strange User Problem
i started up pgsql as i usually do... this time, though, when i tried to start psql, i got the following error: FATAL: database "Owner" does not exist psql: FATAL: database "Owner" does not exist i used "Owner" to create my database. to make matters more interesting... i was able to connect to pgAdminIII using user "Owner". when i tried to create another user "Owner", i received the following error: ERROR: user "Owner" already exists. it is pretty interesting to see both these errors, one after the other, in my cygwin bash shell. ;-) when i go to "Users(1)" in pgAdminIII and click on Owner, i see the following sql... -- User: "Owner" -- DROP USER "Owner"; CREATE USER "Owner" WITH SYSID 1 ENCRYPTED PASSWORD '' CREATEDB CREATEUSER; is the -- DROP USER "Owner"; normal? i never typed in that sql at ny time. any ideas how to get psql to recognize "Owner" exists would be appreciated. i'm running the latest cygwin (pgsql 7.4.5) on winxp. this is the 2nd time i've logged into the pgsql since installing cygwin. there were no problems the first time. tia... __________________________________ Do you Yahoo!? Yahoo! Mail - 250MB free storage. Do more. Manage less. http://info.mail.yahoo.com/mail_250
I think I understand your problem. In the shell, if you do: psql psql will try to connect to a database with the same name as the user starting psql. If you are user Owner, the psql without options is interpretted as: psql Owner If the database Owner doesn't exist, you will get the error below. Note that the user Owner exists, just not the database Owner. If instead you do something like: psql template1 and user Owner has access to template1 and template1 exists, the command will succeed. In other words, if no database called Owner exists, you have to specify one that does and that Owner has access to. Sean On Jan 20, 2005, at 11:10 AM, <operationsengineer1@yahoo.com> wrote: > i started up pgsql as i usually do... this time, > though, when i tried to start psql, i got the > following error: > > FATAL: database "Owner" does not exist > psql: FATAL: database "Owner" does not exist > > i used "Owner" to create my database. > > to make matters more interesting... > > i was able to connect to pgAdminIII using user > "Owner". when i tried to create another user "Owner", > i received the following error: > > ERROR: user "Owner" already exists. > > it is pretty interesting to see both these errors, one > after the other, in my cygwin bash shell. ;-) > > when i go to "Users(1)" in pgAdminIII and click on > Owner, i see the following sql... > > -- User: "Owner" > > -- DROP USER "Owner"; > > CREATE USER "Owner" > WITH SYSID 1 > ENCRYPTED PASSWORD '' > CREATEDB CREATEUSER; > > is the -- DROP USER "Owner"; normal? i never typed in > that sql at ny time. > > any ideas how to get psql to recognize "Owner" exists > would be appreciated. > > i'm running the latest cygwin (pgsql 7.4.5) on winxp. > this is the 2nd time i've logged into the pgsql since > installing cygwin. there were no problems the first > time. > > tia... > > > > __________________________________ > Do you Yahoo!? > Yahoo! Mail - 250MB free storage. Do more. Manage less. > http://info.mail.yahoo.com/mail_250 > > ---------------------------(end of > broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to > majordomo@postgresql.org)
sean, perfect. thank you. my world makes sense once again! --- Sean Davis <sdavis2@mail.nih.gov> wrote: > I think I understand your problem. > > In the shell, if you do: > > psql > > psql will try to connect to a database with the same > name as the user > starting psql. If you are user Owner, the psql > without options is > interpretted as: > > psql Owner > > If the database Owner doesn't exist, you will get > the error below. > Note that the user Owner exists, just not the > database Owner. If > instead you do something like: > > psql template1 > > and user Owner has access to template1 and template1 > exists, the > command will succeed. In other words, if no > database called Owner > exists, you have to specify one that does and that > Owner has access to. > > Sean > > On Jan 20, 2005, at 11:10 AM, > <operationsengineer1@yahoo.com> wrote: > > > i started up pgsql as i usually do... this time, > > though, when i tried to start psql, i got the > > following error: > > > > FATAL: database "Owner" does not exist > > psql: FATAL: database "Owner" does not exist > > > > i used "Owner" to create my database. > > > > to make matters more interesting... > > > > i was able to connect to pgAdminIII using user > > "Owner". when i tried to create another user > "Owner", > > i received the following error: > > > > ERROR: user "Owner" already exists. > > > > it is pretty interesting to see both these errors, > one > > after the other, in my cygwin bash shell. ;-) > > > > when i go to "Users(1)" in pgAdminIII and click on > > Owner, i see the following sql... > > > > -- User: "Owner" > > > > -- DROP USER "Owner"; > > > > CREATE USER "Owner" > > WITH SYSID 1 > > ENCRYPTED PASSWORD '' > > CREATEDB CREATEUSER; > > > > is the -- DROP USER "Owner"; normal? i never > typed in > > that sql at ny time. > > > > any ideas how to get psql to recognize "Owner" > exists > > would be appreciated. > > > > i'm running the latest cygwin (pgsql 7.4.5) on > winxp. > > this is the 2nd time i've logged into the pgsql > since > > installing cygwin. there were no problems the > first > > time. > > > > tia... > > > > > > > > __________________________________ > > Do you Yahoo!? > > Yahoo! Mail - 250MB free storage. Do more. Manage > less. > > http://info.mail.yahoo.com/mail_250 > > > > ---------------------------(end of > > broadcast)--------------------------- > > TIP 2: you can get off all lists at once with the > unregister command > > (send "unregister YourEmailAddressHere" to > > majordomo@postgresql.org) > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com