| From: | "Jasbinder Bali" <jsbali(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | server administration problem: Database startup and permissions |
| Date: | 2006-07-27 19:49:08 |
| Message-ID: | a47902760607271249o33d48587xbf2e6770a85e33b1@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2006-07-27 20:13:02 | Re: Generating unique session ids |
| Previous Message | Richard Huxton | 2006-07-27 18:08:26 | Re: PostgreSQL theoretical maximums. |