[udig-devel] How can I add Layers from PostGIS?

[Cory Horner]

오명운 wrote:

> I installed PostgreSQL 8.1.4, PostGIS 1.1.3, u-Dig 1.0.6 on my 
> WindowsXP computer.
> In u-Dig,
> I tried to add layers from PostGIS using 'File>New>New Layer>PostGIS'.
> I typed the PostGIS Server Information(Host, Username, Password, 
> Database, Schema) and clicked 'Next' button in 'Add layers to Map' 
> pop-up window.
> Then u-Dig shows Error messages like below.
> ------
> org.geotools.data.DataSourceException: ERROR: function 
> postgis_version() does not exist

Hello!

It sounds like PostGIS isn't properly set up, as it cannot find the 
postgis_version function. Options are to fire up the pgAdmin tool that 
came with postgres, or use the psql command line, and look at your 
database to see if it has functions properly installed. Chances are the 
lwpostgis.sql has not been imported; note that your have to 
postgis-enable *each* database you intend to use. More details here 
(starting at point #5):

http://postgis.refractions.net/docs/ch02.html#PGInstall

Cheers,
Cory.