Question on Starting Postgres for the first time

Started by David Stevensonalmost 25 years ago4 messagesgeneral
Jump to latest
#1David Stevenson
dstevenson@eastlink.ca

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'

$ 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

#2Alexander Dederer
dederer@spb.cityline.ru
In reply to: David Stevenson (#1)
RE: Question on Starting Postgres for the first time

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.

Use first:
$ initdb -D /home/david/pg-data # Only Example.

#3Lee Harr
missive@frontiernet.net
In reply to: David Stevenson (#1)
Re: Question on Starting Postgres for the first time

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:

Show quoted text

$ 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

#4Janning Vygen
vygen@planwerk6.de
In reply to: David Stevenson (#1)
Re: Question on Starting Postgres for the first time

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