Re: [PHP-DB] [PHP] pg_connect() unable to connect to PostgreSQLserver :could not connect to server

[Devrim GUNDUZ]

On Mon, 22 Jul 2002, Eric wrote:

> I agree, Unix domain sockets very much faster.
> 
> You have to start POSTMASTER with the -i switch to get it to listen on the
> designated port (5432 by default I think).

If you'll use Unix domain sockets, then do not use -i parameter. 

:) 

Best regards.

-- 

Devrim GUNDUZ

[EMAIL PROTECTED]
[EMAIL PROTECTED]

Web : http://devrim.oper.metu.edu.tr
-



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] [PHP] pg_connect() unable to connect to PostgreSQLserver :could not connect to server

[Devrim GUNDUZ]

Hi,

On Mon, 22 Jul 2002, Vincent wrote:

> "Warning: pg_connect() unable to connect to PostgreSQL
> server: could not connect to server: Connection
> refused Is the server running on host localhost and
> accepting TCP/IP connections on port 5432? in
> /usr/local/apache/htdocs/postgresql.php on line 8"
>  Unable to connect to database

Please avoid using host=localhost in pg_connect parameters.

As far as I guess, you have not activated the TCP-IP port in 
postgresql.conf, and if you use host=localhost parameter, pg_connect will 
try to connect to PostgreSQL via TCP-IP. If you do not use that parameter, 
then it will connect to the database via Unix domain sockets, which is 
really faster than TCP-IP sockets (and more secure).

HTH.

Best regards.

 -- 

Devrim GUNDUZ

[EMAIL PROTECTED]
[EMAIL PROTECTED]

Web : http://devrim.oper.metu.edu.tr
-






-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php