[postgis-users] PostGIS/PostGres Configuration

[Steffan Chmuryk]

Thank you for your help Paul;

I have successfully loaded a dataset, a 30mb administrative boundaries file. I have also viewed this information successfully. Now I am trying to load a larger, 2gb, file. Using the shp2pgsql tool, I have encountered an error:

An unhandled win32 exception occurred in shp2pgsql-gui.exe [3996]. Just-in-Time debugging this exception failed with the following error: No installed debugger has Just-In-Time debugging enabled.

So I installed a new debugger, the WinDbg debugger, and executed it; however, now I am not getting an error message, and my data is still not being loaded to postgis/postgre. I then modified the data execution prevention to work only for windows programs. Still haven't gotten anywhere.

I am using the shp2pgsql tool by itself, am I missing a step?

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 8:38 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] PostGIS/PostGres Configuration

>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
>
_______________________________________________
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 12:33:00