server administration problem: Database startup and permissions - Mailing list pgsql-general

From Jasbinder Bali
Subject server administration problem: Database startup and permissions
Date
Msg-id a47902760607271249o33d48587xbf2e6770a85e33b1@mail.gmail.com
Whole thread Raw
Responses Re: server administration problem: Database startup and permissions  ("Shoaib Mir" <shoaibmir@gmail.com>)
List pgsql-general
Hi,

I created a database cluster using the following commands as per what is given in the postgres server administration manual

root# mkdir /usr/local/pgsql/jas
root# chown jsbali /usr/local/pgsql/jas
root# su jsbali
jsbali# initdb -D /usr/local/pgsql/jas

After that i tried to start up the postmaster process using the follwing command

jsbali# pg_ctl start -D /usr/local/pgsql/jas

It does start the postmaster process.

Then i create a new database here using the following command

jsbali# createdb DBxyz

here in the same user account i try to open pgadmin3 and it doens't

I open pgadmin3 from the root account and try to connect to my local host and it says

An error has occured:
Error connecting to the server: FATAL:  role "postgres" does not exist

Don't know whats going on wrong.
I'm totally confused.

~Jas


pgsql-general by date:

Previous
From: Casey Duncan
Date:
Subject: Re: Can't start PostgreSQL
Next
From: Bruno Wolff III
Date:
Subject: Re: Generating unique session ids