[FWTools] PGeo->Postgres on Ubuntu 9.04. Can virtualbox help?

[Frank Warmerdam]

David Epstein wrote:
> Hello,
> 
> I am running Ubuntu 9.04 and have virtualbox with Vista.
> 
> I need to extract data from an ESRI Personal Geodatabase (.mdb file) to
> a postgres/postGIS server running on my linux machine. 
> 
>>From my virtualbox Vista, I can use the fwtools "PGeo" format to access
> the data, but cannot use the PostgreSQL format and PG settings to load
> it, since the server is running on the host. Port forwarding may work,
> but I am unsure how to do it. Related posts focus on the host->guest
> direction. 
> 
>>From linux, I downloaded fwtools, but do not see the PGeo format as
> available.
> 
> I was hoping to generate an intermediate (pgdump?) file on Vista and
> then load this into my postgres server on linux. But, I do not see this
> as a format option.
> 
> I welcome any advice or ideas. Thank you in advance!

David,

PGDUMP is actually a supported output format for the development version
of ogr2ogr, but this support is not present in FWTools to the best of
my knowledge.

I'd suggest you use ogr2ogr to convert to shapefiles, and then load
those on the linux system using shp2pgsql or ogr2ogr.   There are some
downsides to going via shapefile format though - limited column name length,
amoung others.

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent