Question on Starting Postgres for the first time
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
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.
Import Notes
Resolved by subject fallback
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
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