PostGIS connection

[Steven De Vriendt]

Check the pg_hba.conf file and check if your login credentials allow you to
connect !

All the best,
Steven

On Jan 17, 2008 1:57 PM, Begoña Gonzalez <begodom at gmail.com> wrote:

> Postgres is running with the postmaster.
>
> When I try to connect access the database independent of mapserver there
> is the following error message:
>
> "Error connecting to the server: no se pudo conectar con el servidor:
> Connection refused (0x0000274D/10061)
> ¿Está el servidor en ejecución en el servidor <<***.***.**.*>>  y
> aceptando conexiones TCP /IP en el puerto 5432?"
>
> The server is runing so I suppose that the problem is with TCP/IP
> connections but I´m not sure of this settings. How do i check the TCP/IP
> connection of 5432 port?
>
> Thanks
>
>
> On Jan 17, 2008 11:47 AM, Steven De Vriendt <gisaalter at gmail.com> wrote:
>
> > So, is postgres up and running with the postmaster ?
> > Check if you can access the database independent of mapserver...
> >
> > Steven
> >
> > On Jan 17, 2008 11:04 AM, SUBSCRIBE MAPSERVER-USERS Bego D. <
> > begodom at gmail.com> wrote:
> >
> > > Hello
> > >
> > > We are new in Mapserver.
> > >
> > > I have installed MapServer 4 Windows version 2.2.6 on my computer and
> > > in
> > > another computer of my office we have installed Postgis 1.3.2. for 8.2
> > > PostgreSQL.
> > >
> > > Both works fine, we can work with Mapserver-Oracle Spatial or with
> > > .shp
> > > or .tab, but now we want to connect MapServer with PostGis and we get
> > > this
> > > error:
> > >
> > > msDrawMap(): Image handling error. Failed to draw layer named
> > > 'INFVIA'.
> > > msPOSTGISLayerOpen(): Query error. couldnt make connection to DB with
> > > connect string 'host=****** dbname=****  user=postgres
> > > password=****** port=5432'. Error reported was 'could not connect to
> > > server: Connection refused (0x0000274D/10061) Is the server running on
> > > host " 192.168.0.3 " and accepting TCP/IP connections on port 5432? '.
> > > This
> > > error occured when trying to make a connection to the specified
> > > postgresql
> > > server. Most commonly this is caused by (1) incorrect connection
> > > string (2)
> > > you didnt specify a 'user=...' in your connection string (3) the
> > > postmaster
> > > (postgresql server) isnt running (4) you are not allowing TCP/IP
> > > connection to
> > > the postmaster (5) your postmaster is not running on the correct port
> > > - if its
> > > not on 5432 you must specify a 'port=...' (6) the security on your
> > > system
> > > does not allow the webserver (usually user 'nobody') to make socket
> > > connections to the postmaster (7) you forgot to specify a 'host=...'
> > > if the
> > > postmaster is on a different machine (8) you made a typo
> > >
> > > My .map is:
> > >
> > >
> > > CONNECTIONTYPE POSTGIS
> > > CONNECTION "host=***.***.**.* dbname=**user=postgres password=***
> > > port=5432"
> > > DATA "the_geom geometry from INFVIA2"
> > >
> > > Any help will be appreciate.
> > >
> > > Bego
> > >
> >
> >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20080117/cbef71c6/attachment.html