|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
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. |
|
#2
|
||||
|
||||
|
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
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias) |
|
#3
|
||||
|
||||
|
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. |
![]() |
| Viewing: Dev Shed Forums > Databases > PostgreSQL Help > psql start error |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|