Re: [GENERAL] server administration problem: Database startup and permissions

2006-07-27 Thread Shoaib Mir
This is because in the pgadmin3 server settings for PostgreSQL database you did set the user as 'postgres' (default behavior) and never changed it. Now as you did run the 'initdb' process with user 'jsbali' so that is the user which exists in the database not the 'postgres' user. So the solution fo

[GENERAL] server administration problem: Database startup and permissions

2006-07-27 Thread Jasbinder Bali
Hi,I created a database cluster using the following commands as per what is given in the postgres server administration manualroot# mkdir /usr/local/pgsql/jasroot# chown jsbali /usr/local/pgsql/jasroot# su jsbali jsbali# initdb -D /usr/local/pgsql/jasAfter that i tried to start up the postmaster pr