Postgres Pro
Downloads
Home   >   mailing lists

Re: Question on Starting Postgres for the first time - Mailing list pgsql-general

From missive@frontiernet.net (Lee Harr)
Subject Re: Question on Starting Postgres for the first time
Date
Msg-id slrn9frnr0.m6.missive@h.frontiernet.net
Whole thread Raw
In response to Question on Starting Postgres for the first time  ("David Stevenson" <dstevenson@eastlink.ca>)
List pgsql-general
Tree view 
On Sat, 12 May 2001 13:00:35 -0300, David Stevenson <dstevenson@eastlink.ca>
wrote:
> I am a new user of PostgreSQL and Linux.  I have my Linux up and running and
> my PostgreSQl semi-configured.  I can get into PostgreSQL using super user
> on root and then super user into postgres.  The problem is when I try to run
> psql and createdb from my home directory.  When I do that, I get the
> following messages

I think first you must, as the superuser

createuser david

and then:

>
> $ createdb david
> psql: FATAL 1:  SetUserId: user 'david' is not in 'pg_shadow'
>
> $ psql
> psql: FATAL 1:  Database "david" does not exist in the system catalog.
>
> Not sure what is going on here, but I think someone out there does.  Can you
> help.
>
> Thanks
> Dave
>
>
>
>

pgsql-general by date:

Previous
From: "Brent R. Matzelle"
Date:
Subject: New article mentions Postgres...
Next
From: "Stuart Foster"
Date:
Subject: How to save images in a table.