pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Configure DB 3+ messages / 3 participants [nested] [flat]
* Configure DB @ 2008-08-30 16:42 davyd <davydky@gmail.com> 0 siblings, 1 reply; 3+ messages in thread From: davyd @ 2008-08-30 16:42 UTC (permalink / raw) To: pgsql-admin Hi List, I'm working with Postgres, I'm storing spatial information, but I have any problems when I try to acces to my data..from php, visual basic and postgis too... This is the message error: *Warning*: pg_connect() [function.pg-connect<http://localhost/function.pg-connect;]: Unable to connect to PostgreSQL server: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "???" and accepting TCP/IP connections on port 5432? in *C:\Program Files\ms4w\Apache\htdocs\conexion.php* on line *4* I read that I need to configure these files: pg_hba.conf postgresql.conf I hope your help.. Thanks... ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Configure DB @ 2008-09-01 06:10 Vishal Arora <aroravishal22@hotmail.com> parent: davyd <davydky@gmail.com> 0 siblings, 1 reply; 3+ messages in thread From: Vishal Arora @ 2008-09-01 06:10 UTC (permalink / raw) To: davyd <davydky@gmail.com>; pgsql-admin Date: Sat, 30 Aug 2008 11:42:57 -0500From: davydky@gmail.comTo: pgsql-admin@postgresql.orgSubject: [ADMIN] Configure DB Hi List, I'm working with Postgres, I'm storing spatial information, but I have any problems when I try to acces to my data..from php, visual basic and postgis too...This is the message error:Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "???" and accepting TCP/IP connections on port 5432? in C:\Program Files\ms4w\Apache\htdocs\conexion.php on line 4I read that I need to configure these files: pg_hba.confpostgresql.conf Have you configured these files? Is your service running / Have you tried connecting to Postgres Server using psql or any other client like PgAdmin?I hope your help..Thanks... _________________________________________________________________ Searching for the best deals on travel? Visit MSN Travel. http://msn.coxandkings.co.in/cnk/cnk.do= ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Configure DB @ 2008-09-03 09:14 Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de> parent: Vishal Arora <aroravishal22@hotmail.com> 0 siblings, 0 replies; 3+ messages in thread From: Jan-Peter Seifert @ 2008-09-03 09:14 UTC (permalink / raw) To: pgsql-admin Hi, > Datum: Mon, 1 Sep 2008 11:40:29 +0530 > Von: Vishal Arora <aroravishal22@hotmail.com> > Betreff: Re: [ADMIN] Configure DB > Date: Sat, 30 Aug 2008 11:42:57 -0500From: davydky@gmail.comTo: > pgsql-admin@postgresql.orgSubject: [ADMIN] Configure DB > Hi List, I'm working with Postgres, I'm storing spatial information, but > I have any problems when I try to acces to my data..from php, visual basic > and postgis too...This is the message error:Warning: pg_connect() > [function.pg-connect]: Unable to connect to PostgreSQL server: could not connect to > server: Connection refused (0x0000274D/10061) Is the server running on > host "???" and accepting TCP/IP connections on port 5432? in C:\Program > Files\ms4w\Apache\htdocs\conexion.php on line 4I read that I need to configure > these files: > pg_hba.conf > postgresql.conf For testing purposes make sure that this entry is set this way in postgresql.conf: listen_addresses = '*' Don't forget to remove the '#' at the beginning of the line, if there's any! Are any firewalls running (Windows Firewall etc.)? Then add an exception for the server port (5432?) on the PostgreSQL server machine in the Firewall settings. This is most likely the case if you get this message. If this doesn't help - did you add the three '???' in the message? Maybe the host is not set otherwise? Good luck. Peter -- GMX startet ShortView.de. Hier findest Du Leute mit Deinen Interessen! Jetzt dabei sein: http://www.shortview.de/wasistshortview.php?mc=sv_ext_mf@gmx ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-09-03 09:14 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2008-08-30 16:42 Configure DB davyd <davydky@gmail.com> 2008-09-01 06:10 ` Vishal Arora <aroravishal22@hotmail.com> 2008-09-03 09:14 ` Jan-Peter Seifert <Jan-Peter.Seifert@gmx.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox