starting up database server + user postgres

From: Jennifer Liu <jennliu(at)MIT(dot)EDU>
To: pgsql-novice(at)postgresql(dot)org
Subject: starting up database server + user postgres
Date: 2003-09-01 16:06:19
Message-ID: 20030901160619.GA18230@jennliu.mit.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I'm a novice for using Postgres and Linux - any help or suggestions would be really appreciated, thanks!!! I'm having trouble logging on as the postgres user. I wanted to
create a database, so I tried...

root# /usr/local/pgsql/bin/createdb test
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
createdb: database creation failed

(so i thought i probably needed to logon as postgres, so i tried...)
root# su - postgres
su: user postgres does not exist

root# adduser postgres
adduser: group postgres exists - if you want to add this user to that group, use -g.

root# chown postgres /usr/local/pgsql/data
chown: `postgres': invalid user

I'm a little stuck....can anybody help? thanks so much!

jenn.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Williams, Travis L, NEO 2003-09-01 17:22:16 Re: ORDER BY question
Previous Message Luis H. 2003-09-01 13:57:04 Re: ORDER BY question