[postgis-users] PostGIS/PostGres Configuration

[Paul Ramsey]

>From an unrelated post on udig-devel it looks like the error you are
seeing is common to the most recent 1.2M release... try backing up to
the last 1.1 release and using that for PostGIS access.

Also, if you're doing general desktop tests, you could try gvSIG,
CadCorp SIS and (!!) MapInfo's latest release.

P.

On Mon, Mar 15, 2010 at 5:30 PM, Steffan Chmuryk <schmuryk at icisociety.ca> wrote:
> Thanks,
>
> So now, I have set up the connection, and have tried to connect via all three applications. Here are the errors:
>
> * Udig will connect, and seems to load the data, but then gives this message: RenderingException(s) occurred during rendering: Must call hasNext before calling next
>        *Seems to be a java error.
> * OpenJump connects to the db, but gives this message: Error: syntax error at or near "ST_GeomFromText" (PSQL Exception)
>        *Seems to require a plugin.
> * QGIS seems to work fine.
>
> More to come...
>
> Steffan Chmuryk
> Technical Services Coordinator, ICIS
> www.icisociety.ca
>
> Office: (250) 381-9295
> Cell:     (250) 516-2481
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Paul Ramsey
> Sent: Monday, March 15, 2010 12:15 PM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] PostGIS/PostGres Configuration
>
> Steffan,
> Leave your localhost entry in place, it's useful. Make a copy of the
> line and edit the copy.
> Change localhost to 192.168.0.0 and change 32 to 16.
> Ensure that listen_addresses = '*' in your postgresql.conf file.
> Restart the database
> Try again.
> P
>
> On Mon, Mar 15, 2010 at 11:50 AM, Steffan Chmuryk
> <schmuryk at icisociety.ca> wrote:
>> Hello,
>>
>> This is my first post, so please go easy ;)
>>
>> I have built a PostGIS/PostGres spatial database, and have successfully
>> imported a shapefile. Now when I try to connect to the database via
>> Udig, OpenJump, or Qgis, I the following error:
>>
>> Fatal: no pg_hba.conf entry for host "192.168.x.xxx", user "postgres",
>> database "postgis1', SSL off (PSQL Exception)
>>
>> Now I have tried every combination of the following:
>>
>> * Edit pg_hba.conf so that the default 127.0.0.1/32 is replaced by the
>> 192... ip
>> * Add another access configuration to the file, so that the 192... ip,
>> the postgres user, and the database are all included
>> * Enable the SSL off configuration in the postgres.conf file, and
>> restart the machine
>> * I have even explored the JDBC stuff... argh!
>>
>> The error message in the application (Udig, OpenJump, or Qgis) does not
>> change. But upon changing the files to reflect any of the above
>> configurations, I am then unable to connect to the db within pgadminIII,
>> due to an error in loading the pg_hba.conf file.
>>
>>
>> Regarding the environment:
>> * Server used to host MSSQL and SDE;
>> * Server is Windows Server 2003 (not R2);
>>
>>
>> Steffan Chmuryk
>> Technical Services Coordinator, ICIS
>> www.icisociety.ca
>>
>> Office:   (250) 381-9295
>> Cell:     (250) 516-2481
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 9.0.733 / Virus Database: 271.1.1/2748 - Release Date: 03/15/10 00:33:00
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>