June 17th, 2001, 09:31 PM
-
psql start error
I've setup an account on my Linux box of postgres. But when I try to run psql I get this error;
psql: connectDBStart() -- connect() failed: Connection refused
Is the postmaster running at 'localhost'
and accepting connections on Unix socket '5432'?
Anyone know how to fix this? I've got mysql running fine on Linux, but I'd like to experiment with postgres too. Thx.
November 7th, 2001, 08:24 AM
-
Where is the ### script?
Looking on PgAccess site I found a tutorial which suggests a solution:
If you have installed the prewritten script to start postgreSQL automatically, this option is (currently) commented out:
# PGOPTS="-i"
just remove the hash and space and comment out the "blank" option above:
PGOPTS=""
My question is:
"Where the hell is that script????'"
Thanks in advance for your help.
Pabloj
November 11th, 2001, 10:53 AM
-
OK
I've found the answer, I'm posting it here for others who might be interested:
On Mdk 8.0 edit: /var/lib/pgsql/data/postmaster.opts.default and add:
-i 5432
Default db is postgres and user is the same.