[SPAM] - RE: [Mapserver-users] Mapserver Postgis connectionissues - Email found in subject

[Merlos]

To avoid having to delete the pid file each time. On the pgstart cmd window, 
hit Control+C, it does a clean shutdown.

On Monday 19 July 2004 00:24, Gregory S. Williamson wrote:
> One step I ommitted in the postGIS setup is the "createlang plpgsql foo"
> step which is needed to install the postgres language used by the stored
> procedures.
>
> The initdb.bat needs to be run only once), natch. I ended up having to
> delete a pgsql75win\data\postmaster.pid file manually when I shut down the
> postmaster.
>
> GSW
>
> -----Original Message-----
> From:	IMD Listuser [mailto:imd_listuser at comcast.net]
> Sent:	Sun 7/18/2004 2:38 PM
> To:	mapserver-users at lists.gis.umn.edu
> Cc:
> Subject:	RE: [SPAM] - RE: [Mapserver-users] Mapserver Postgis
> connectionissues - Email found in subject Hi
>
> Thanks for the speedy response. Ill start setting it up. I intend to try to
> use it from mapserver, so here goes....
>
> Charlie
>
>
> -----Original Message-----
> From: Gregory S. Williamson [mailto:gsw at globexplorer.com]
> Sent: Sunday, July 18, 2004 5:10 PM
> To: IMD Listuser; mapserver-users at lists.gis.umn.edu
> Subject: [SPAM] - RE: [Mapserver-users] Mapserver Postgis connection issues
> - Email found in subject
>
>
> Charlie,
>
> I have not used it extensively, but have downloaded the same zip file; I
> extracted its contents to my C: drive and then ran the three .bat files
> (initdb.bat, then pgstart.bat (keep that window open) and env.bat, which
> sets up a dos window at which typing "psql -d template1" gets one going.
> (At this prompt a "CREATE DATABASE foo;" command would build a database in
> the default schema; connect to it from a dos prompt with "psql -d foo" ...
>
> I do have cygwin on this box but did not use it; I don't think it is
> necessary as this port seems to be a native Windows version.
>
> I have not yet loaed the gis functions but the C:\pgsql75win\lib directory
> has DLLs that seem to apply and the contrib directory has the SQL. Proj is
> included so in theory you are good to go ... running the sql for postgis
> (postgis.sql) and spatial_ref_sys.sql should define the postgres interfaces
> to to the postGIS package.
>
> I am not sure about connecting to it from perl or Mapserver, though.
>
> HTH,
>
> Greg Williamson
> DBA
> GlobeXplorer LLC
>
> -----Original Message-----
> From:	IMD Listuser [mailto:imd_listuser at comcast.net]
> Sent:	Sun 7/18/2004 10:51 AM
> To:	mapserver-users at lists.gis.umn.edu
> Cc:
> Subject:	RE: [Mapserver-users] Mapserver Postgis connection issues
>
> Greetings
>
> I have a question regarding PostGIS & Postgresql.
>
> Ive downloaded & unzipped the same version as cited below. Do I also need
> to download and install cygwin, etc. as per the guidance on the postgres
> web site, or am I good to go with just pgsql75win.zip?
>
> Thanks
>
> PS: Any other guidance for a newcomer to postgres would be appreciated.
>
> Charlie
>
> -----Original Message-----
> From: mapserver-users-admin at lists.gis.umn.edu
> [mailto:mapserver-users-admin at lists.gis.umn.edu] On Behalf Of Swaminathan,
> Gayathri Sent: Friday, July 16, 2004 4:08 PM
> To: Vladimir Guzmán; Kathi Koebke
> Cc: mapserver-users at lists.gis.umn.edu
> Subject: [Mapserver-users] Mapserver Postgis connection issues
>
> Hi:
>
> I downloaded the latest version of mapserver (4.2.1) from mapserver's site
>
> I am using it a windows 2000 server running IIS...
>
> Postgresql version 7.5 from Mark Ayland's
> snapshot...http://www.webbased.co.uk/mca/pgsql75win.zip
>
> I have been able to compile install and run just shapefiles fine on this
> newer version..
>
> If I added a Postgis layer however..I am having the mapserver cgi run
> indefinetely and locking up.
>
> I have checked/tried the following:
>
> 1) Checked for multiple instances of dlls and verified.
> 2) Checked if my query ran fine with psql and it works fine
> 3) I am able to connect to my postgresql database using PGADMIN AND EMS2
> POSTGRESQL MANAGER. 4) Checked for my data statement issues...
>
> Here is the layer I am trying to get mapserver work on
>
> ### SEWERLINES (SELECTED) ###
> LAYER
> 	GROUP "CIP Features"
> 	CONNECTIONTYPE postgis
> 	CONNECTION "user=postgres dbname=mydb host=myhostname"
> #	Data is written on the fly from calling form.
> 	DATA "the_geom from (select oid,* from sewerline where GEO_CIP='SEWL001')
> as foo using unique gid using srid=4326"
>
> 	NAME sqlSewerline
> 	TYPE LINE
> 	STATUS OFF
> 	PROJECTION #GEOGRAPHIC NAD83
> 		proj=longlat
> 		ellps=GRS80
> 		no_defs
> 	END
> 	CLASS#
> 		NAME "Sewer lines (Selected)"
> 	    COLOR 200 0 0
> 		#COLOR 200 251 187
> 		SIZE 2
> 	END
> 	METADATA
> 		legend_order "200"
> 		"NoID" "1"
> 		"NoLabels" "1"
> 	END
>
> Am I missing something obvious? Thanks for all the help in advance.
>
> Gayathri
>
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>
>
>
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>
>
>
>
>
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>
>
>
>
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users

-- 
--
http://www.merlos.biz