[simple]

i have installed mandriva linux(must be the latest) and everything is running good although i cant get the postgresql to work!! when i type in "psql" to start pgsql it says " is the unix's server running and accepting?" and it wont work. i have installed pgsql surely but still i am new to linux and i will be very happy if someone tells me how to start the pgsql in linux! plz reply ok guys! c ya!

[philg]

Not used postgreSQL but I'm sure you need to use a client to connect to the server in order to start manipulating data.

It sounds like the postgreSQL server is up and running but your trying to execute the server again instead of executing the client and connecting to the server

[simple]

still no help!! the message says, " Is the server running???" so this means it is not running( thats what i think!). it wud be helpful if u wud tell me how to start a server (sql) so that i cud peacefully do my database handling. thanx anyways!! c ya!!

[philg]

Sorry, I misunderstood you. It would be more helpful if you could quote full error messages in [ code ] tags and write in standard english.

Have you run

# pg_ctl start

to start the server?

[simple]

i tried #pg_ctl start command but it says pg_ctl command not found. also the error that i get when i type in "psql" is the following

psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket


anyways thanks for replying again so soon! i am hoping to hear from you soon[ and praying 2 ]
see ya!!

[philg]

Did you try that command as root? The hash (#) isn't part of the command it is to signify that you should run the following command as the root user, according to the docs `pg_ctl start` is how to start the server, or depending on your distribution you could try /etc/init.d/postgresql start

Read this install guide http://www.oryx.com/ams/postgresql.html and see what you have missed out.

If your still stuck please tell me what distribution you are using and how you installed postgresql by the distributions's package manager or by source? As I have already said I haven't used postgresql, when I looked at the different database servers MySQL fit the bill better so I went with that, but I'll help you as much as I can

[simple]

YIPEE!!!!!!!! now my pgsql is up and running ( atleast for now ) . i downloaded the latest version from linux site and got a book "databases with postgresql" by richard stones and neil matthew. i failed quite a few times but in the end hopefully now everything has come out fine!! by the way philg thanks a lot for taking time to help me!! you are a nice dude!! goodluck !!! c ya!!