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

From Janning Vygen
Subject Re: Question on Starting Postgres for the first time
Date
Msg-id 01051311434900.10487@janning
Whole thread Raw
In response to Question on Starting Postgres for the first time  ("David Stevenson" <dstevenson@eastlink.ca>)
List pgsql-general
Am Samstag, 12. Mai 2001 18:00 schrieb David Stevenson:
> 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
>
> $ createdb david
> psql: FATAL 1:  SetUserId: user 'david' is not in 'pg_shadow'

change to root and call

createuser

consult man createuser or the postgres manual for further instructions.
create a user called david
[hint: linux system users and postgers users can vary and often do, there is
no link between system users and postgres users]

change to your user account david and connect with psql

janning

> $ 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.


--
Planwerk 6 /websolutions
Herzogstraße 86
40215 Düsseldorf

fon 0211-6015919
fax 0211-6015917
http://www.planwerk6.de

pgsql-general by date:

Previous
From: Justin Clift
Date:
Subject: Re: FTP Problems -- maybe?
Next
From: Peter Eisentraut
Date:
Subject: Re: [PATCHES] Re: microsecond log timestamps