Hi all,
I am a newcomer to postgreSQl. I have mandrake 9 installed in my machine and postgreSQL up and running as seen through ps -ef|grep postmaster.I am running su - postgres and running the command "psql" wherby it is showing "not in system catalogue". Do i have to enter any database name from psql when I am postgres user?? What is the database name??
Basically I have to create a database called "school"
in a directory "/dbfile" that is the database files should be in that directory. Also there is a linux user called "partha" password "partha" who should be able to connect to that database through psql as well as pgaccess.User "partha" is going to run some applications which needs connection to the database. Also how do I compile the proC scripts.Please help.Thanks in advance
Partha
I am a newcomer to postgreSQl. I have mandrake 9 installed in my machine and postgreSQL up and running as seen through ps -ef|grep postmaster.I am running su - postgres and running the command "psql" wherby it is showing "not in system catalogue". Do i have to enter any database name from psql when I am postgres user?? What is the database name??
Basically I have to create a database called "school"
in a directory "/dbfile" that is the database files should be in that directory. Also there is a linux user called "partha" password "partha" who should be able to connect to that database through psql as well as pgaccess.User "partha" is going to run some applications which needs connection to the database. Also how do I compile the proC scripts.Please help.Thanks in advance
Partha