Postgres Pro
Downloads
Home   >   mailing lists

Thread: system cataloge?

system cataloge?

From
David Scullion
Date:
whenever i try to run the psql command it always tells
me
psql: FATAL 1: Database (dave) does not exist in the
system catalogue

then when i try createdb dave i get the same message
except that it is user dave who doesn't exist in the
system catalogue.

Thanks in advance

DavidScullion



__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

Re: system cataloge?

From
"Henshall, Stuart - Design & Print"
Date:

David Scullion wrote:
> whenever i try to run the psql command it always tells me
> psql: FATAL 1: Database (dave) does not exist in the system catalogue
>
> then when i try createdb dave i get the same message
> except that it is user dave who doesn't exist in the system catalogue.
>
> Thanks in advance
>
> DavidScullion
>
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> http://mailplus.yahoo.com
>
Try:
createuser -a -d --username=postgres dave
To create user dave
then
createdb dbname
psql dbname
hth,
- Stuart