[postgis-users] pgAdminIII crashes when import SQL

[Ervin Ramonllari]

Hi Xiaoyu,

If I understood your problem correctly, you are trying to load some ESRI shape files into PostGIS database, right?

if so, try the following with psql

>>psql -d dbname -h dbhost -U username -f mysql.sql

dbname - the name of your PostGIS database
dbhost - the host of your PostGIS database
username - your user name to log in to your database
and mysql.sql - the .sql file you created at the first step

this is the syntax you should use to load the data into PostGIS database (as it is in the manual of PostGIS, use Loader/Dumper keywords to google around and find more on it)

hope this helps,

Ervin,


Date: Tue, 19 Aug 2008 10:20:29 +0200
From: guanxiaoyu at gmail.com
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] pgAdminIII crashes when import SQL

Dear all:
Here I have some problems with pgAdminIII. I am not a PostGIS export,(neither SQL). but I still want to use PostGIS. I have two ESRI shapefiles. each file have many attribute. here is some steps what I did. 

Step 1. shp2pgsql. (win xp)
shp2pgsql -s 4326 -i -I myshapefile.shp myshapefile > myshapefile.sql

this step is work fine. I got two sql files, one is over 445MB, another one is over 122MB. 

Step 2. using query tools in pgAdmin III . 

crashes happpens when I am opening the two sql file in query tools of my database. my pc is Intel Core Dual, 2GB ram, then XP warning is that some memory(0x00b45d2c) could not be writen. I attached screen shot.

some others. then I try to use psql command. 

psql -d mydatabase -f myshapefiles.sql

then I am not sure how psql works. I can use QGIS open the database, but not my GeoServer or uDig. 

is there anyboday have similar situations before?

All the best 


Xiaoyu

-- 
Xiaoyu Guan (Sam)
Geo-information Science
Wageningen UR




_________________________________________________________________
Discover the new Windows Vista
http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080819/f80451f9/attachment.html>