PosgreSQL server with mandrake 9.1 ?
 

Hi, can anyone help me with setting up aa pgsql server with mandrake 9,1 with the postgres that comes with it ? Im stuck, cant find the directory with DATA.

I am assuming the postgresql package was selected during the install?

So how are you stuck? What problems are you having? Is postmaster running?

I've changed my directories from the default and its been awhile... but it is in /var/pgsql I do believe.

I do not have 9.1 installed but I would assume that MDK has not changed from previous versions.

Yeah it was selected during install, postmaster isnt running off the bat tho, I need to activate and I "think" this does it : please tell me if im wrong
" from root # /etc/rc.d/init.d/postgresql start "... after this i checked my running processes and it has three postgres processes running,
postmaster...postgres data retrieve .. and cant remember the third one. Does this mean my pqsql server is running ?

Ill look for the pgsql dir you just told me about .... and ill try running postmaster from that if I do find it.

thx

I do not run the latest version of postgresql but it appears to be correct. If postmaster is running try starting the frontend:
psql

Unless you add the regular user to postgresql you will see some errors.
For documentation see www.postgresql.org. The first things to do are add your regular user to postresql so it can manage databases. You will need to su to the postgresql user - postgres and then use the createuser command. After that your regular user will be able to create databases.

You can configure postgresql to start at boot. Look at Mandrake Control Center under services. The init scripts tell postmaster where the database is located.

Only if you start postmaster from the command line as below would you need to include the database location

#postmaster -D /usr/local/pgsql/data >logfile 2>&1 &