Обсуждение: Port?
What port does the postgresql server listen on. I am
trying to connect using pg_connect from php using port
5432 with the following command:
$dbconn3 = pg_connect ("host=localhost port=5432
dbname=dbname user=myname password=mypass");
I get the following:
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? ...
How do we know the port postgresql is listening on?
Cheers.
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
Have you started postmaster with the -i option?
If not then doing so will solve your problem.
Regards,
Kallol.
-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of b b
Sent: Thursday, July 31, 2003 11:27
To: postgresql
Subject: [GENERAL] Port?
What port does the postgresql server listen on. I am
trying to connect using pg_connect from php using port
5432 with the following command:
$dbconn3 = pg_connect ("host=localhost port=5432
dbname=dbname user=myname password=mypass");
I get the following:
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? ...
How do we know the port postgresql is listening on?
Cheers.
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
On Thu, 2003-07-31 at 00:56, b b wrote:
> What port does the postgresql server listen on. I am
> trying to connect using pg_connect from php using port
> 5432 with the following command:
> $dbconn3 = pg_connect ("host=localhost port=5432
> dbname=dbname user=myname password=mypass");
>
> I get the following:
> 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? ...
>
> How do we know the port postgresql is listening on?
This should help:
$ netstat -a |grep postgresql
--
+-----------------------------------------------------------------+
| Ron Johnson, Jr. Home: ron.l.johnson@cox.net |
| Jefferson, LA USA |
| |
| "I'm not a vegetarian because I love animals, I'm a vegetarian |
| because I hate vegetables!" |
| unknown |
+-----------------------------------------------------------------+
Hi,
Include -i in the options for starting the server.
e.g. pg_ctl start -o -i &
-i enables TCP/IP connections
Regards,
Kallol
-----Original Message-----
From: b b [mailto:hell_wild_hot2@yahoo.com]
Sent: Thursday, July 31, 2003 11:56
To: Kallol Nandi
Subject: Re: [GENERAL] Port?
I looked up the pg_ctl command and it doesn't have a
-i option? what would it do anyway?
Cheers.
--- Kallol Nandi <kallol.nandi@indussoft.com> wrote:
> Have you started postmaster with the -i option?
> If not then doing so will solve your problem.
>
> Regards,
> Kallol.
>
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org]On Behalf
> Of b b
> Sent: Thursday, July 31, 2003 11:27
> To: postgresql
> Subject: [GENERAL] Port?
>
>
>
> What port does the postgresql server listen on. I
> am
> trying to connect using pg_connect from php using
> port
> 5432 with the following command:
> $dbconn3 = pg_connect ("host=localhost port=5432
> dbname=dbname user=myname password=mypass");
>
> I get the following:
> 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? ...
>
> How do we know the port postgresql is listening on?
>
> Cheers.
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site
> design software
> http://sitebuilder.yahoo.com
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose
> an index scan if your
> joining column's datatypes do not match
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
majordomo@postgresql.org
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
How come? It is working here since years.
Can you try this command and send me the screenshot of the error you are
getting if any.
pg_ctl start -o -i &
Regards,
Kallol.
-----Original Message-----
From: b b [mailto:hell_wild_hot2@yahoo.com]
Sent: Thursday, July 31, 2003 12:06
To: Kallol Nandi
Subject: Re: [GENERAL] Port?
But -i is not a valid option. I tried it said so.
Also pg_ctl --help doesn't include a -i anyway.
Cheers.
--- Kallol Nandi <kallol.nandi@indussoft.com> wrote:
> Hi,
>
> Include -i in the options for starting the server.
>
> e.g. pg_ctl start -o -i &
>
> -i enables TCP/IP connections
>
> Regards,
> Kallol
>
> -----Original Message-----
> From: b b [mailto:hell_wild_hot2@yahoo.com]
> Sent: Thursday, July 31, 2003 11:56
> To: Kallol Nandi
> Subject: Re: [GENERAL] Port?
>
>
>
> I looked up the pg_ctl command and it doesn't have
> a
> -i option? what would it do anyway?
>
> Cheers.
>
>
> --- Kallol Nandi <kallol.nandi@indussoft.com> wrote:
> > Have you started postmaster with the -i option?
> > If not then doing so will solve your problem.
> >
> > Regards,
> > Kallol.
> >
> > -----Original Message-----
> > From: pgsql-general-owner@postgresql.org
> > [mailto:pgsql-general-owner@postgresql.org]On
> Behalf
> > Of b b
> > Sent: Thursday, July 31, 2003 11:27
> > To: postgresql
> > Subject: [GENERAL] Port?
> >
> >
> >
> > What port does the postgresql server listen on. I
> > am
> > trying to connect using pg_connect from php using
> > port
> > 5432 with the following command:
> > $dbconn3 = pg_connect ("host=localhost port=5432
> > dbname=dbname user=myname password=mypass");
> >
> > I get the following:
> > 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? ...
> >
> > How do we know the port postgresql is listening
> on?
> >
> > Cheers.
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! SiteBuilder - Free, easy-to-use web site
> > design software
> > http://sitebuilder.yahoo.com
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 9: the planner will ignore your desire to
> choose
> > an index scan if your
> > joining column's datatypes do not match
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to
> majordomo@postgresql.org
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site
> design software
> http://sitebuilder.yahoo.com
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: don't forget to increase your free space map
settings
__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com
b b wrote: > > What port does the postgresql server listen on. It listens on whichever port you tell it to :) 5432 by default I think. > How do we know the port postgresql is listening on? Make sure that tcp connections are enabled in the conf file. TCP connection are *not* enabled by default. Jean-Christian Imbeault