[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    RE: [postgis-users] trouble moving data: revisited
From:       "Sears, Jeremy" <Jeremy.Sears () CCRS ! NRCan ! gc ! ca>
Date:       2005-11-24 21:33:16
Message-ID: B7F9814D6850C949947CF8DEA134778102F87971 () s5-ccr-r2 ! ccrs ! nrcan ! gc ! ca
[Download RAW message or body]

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@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net]On Behalf Of
strk@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@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

[prev in list] [next in list] [prev in thread] [next in thread]