[postgis-users] Conference Workshop Data Set - Poly layers won'tload

[Mark Cave-Ayland]

> From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Geo
Lists
> Sent: 12 March 2006 21:37
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] Conference Workshop Data Set - Poly layers
won'tload
>
> I am playing around with the data from the Intro to PostGis workshop at
MUM2005.  (Great workshop by the way!)  
>
> I am running postgres 8.1.2 and PostGis 1.1.1.  on Windows.  I was able to
load the
> bc_pubs and bc_municipality, but bc_roads and bc_voting_areas.  
>
> I build the sql file with shp2pgsql and then try to run it in the SQL
window of
> PGAdminIII.  The file loads (after a while) and the sql appears to excute,
but no
> messages are generated.  No table is created either.  These large shape
files do appear > to tax the laptop resources, so the only thing that I can
think of is that I am running > out of memory or something.  Anyone have an
idea or had a similar situation?  
>
> David.


Hi David,

Have you tried loading in the resulting SQL file from the command line using
psql? I can’t say that I’ve used pgAdmin III to load large datasets but I’ve
used psql without any problems. I normally fire up a command prompt in the
PostgreSQL directory and then do something like:

psql.exe –d mydatabase –f mysql.sql –U pguser

BTW a lot of people on this list don’t use PostgreSQL/PGAdminIII on Windows
and so will not be able easily read HTML emails – you’re more likely to get
a response if you post messages in plain text format.


Kind regards,

Mark.

------------------------
WebBased Ltd
17 Research Way
Plymouth
PL6 8BT

T: +44 (0)1752 797131
F: +44 (0)1752 791023

http://www.webbased.co.uk  
http://www.infomapper.com
http://www.swtc.co.uk 

This email and any attachments are confidential to the intended recipient
and may also be privileged. If you are not the intended recipient please
delete it from your system and notify the sender. You should not copy it or
use it for any purpose nor disclose or distribute its contents to any other
person.