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

[Gregory S. Williamson]

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