[postgis-users] trouble with moving data

Sears, Jeremy Jeremy.Sears at CCRS.NRCan.gc.ca
Wed Nov 16 07:20:18 PST 2005


Mark,
Thanks for the response. I think this topic should indeed be featured more
prominently in an FAQ or on the Wiki. 

I am still not able load the data into the new db with out error. I have
used postgis_restore.pl however with no success. When I run the script, I am
prompted for password three times. On the third time It alaways bails
indicating that the password is incorrect. This is odd because its the same
pass I had already entered twice! ... I suspect the wires may be crossed
somewhere in the user access dept.

When I am installing PostgreSQL 8.1, should I opt to have POSTgis installed
as well or should I opt out of this option and let 'postgis_restore.pl'
install it for me?

Best Regards
Jeremy


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of Mark
Cave-Ayland
Sent: November 16, 2005 4:05 AM
To: 'PostGIS Users Discussion'
Subject: RE: [postgis-users] trouble with moving data



> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Sears, Jeremy
> Sent: 15 November 2005 20:13
> To: 'postgis-users at postgis.refractions.net'
> Subject: [postgis-users] trouble with moving data
> 
> 
> Good day all,
> 
> Im attempting to load GIS data into PostgreSQL 8.1. 
> 
> I have a fresh install on a winXP machiene. My data are in a 
> dump file that was produced by an earlier version of the 
> database using pg_dump exe. I have tried to load these data 
> into my new database using the pg_restore command. I get no 
> errors however no data are loaded. After a number of attempts 
> the best I seem to get is that pg_restore will create my 
> schema and tables, but wont populate the tables wih data.
> 
> Has anyone had a simmilar experience? What am I missing?
> Any suggestions or comments are welcome.
> 
> 
> Many Thanks
> Jeremy


Hi Jeremy,

You probably want to take a look at this thread here:
http://postgis.refractions.net/pipermail/postgis-users/2005-October/009730.h
tml. Perhaps this needs to be featured more prominently in an FAQ or on the
Wiki somewhere?


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.


_______________________________________________
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