[postgis-users] trouble moving data: revisited

Sears, Jeremy Jeremy.Sears at CCRS.NRCan.gc.ca
Thu Nov 24 13:33:16 PST 2005


Hi Strk,
Following what I guessed would be you next suggestion, I set the PGHOST and
PGPORT env. vars prior to running postgis_restore.pl. The script ran, no
problems. My data are in there. Thanks so much for your suggestions, I
probably would have been considering a career change right about now had it
not worked properly.

Thanks Again!
Jeremy

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of
strk at refractions.net
Sent: November 24, 2005 4:10 PM
To: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] trouble moving data: revisited


On Thu, Nov 24, 2005 at 04:04:41PM -0500, Sears, Jeremy wrote:
> Yes, I can connect to template1. I can get cmd line access through psql, I
> also connect to it with "EMS SQL Manager 2005 for PostgreSQL" and/or
> pgAdminIII.

I mean with 'psql template1' and no other switches.
Next thing to check is:
	createdb newdb
	createlang plpgsql newdb
	psql -f lwpostgis newdb

do the above works ?

--strk;
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users



More information about the postgis-users mailing list