Thread: Strange User Problem

Strange User Problem

From
Date:
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

Re: Strange User Problem

From
Sean Davis
Date:
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)


Re: Strange User Problem

From
Date:
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