[postgis-users] trouble with moving data

Sears, Jeremy Jeremy.Sears at CCRS.NRCan.gc.ca
Wed Nov 16 09:01:37 PST 2005


Mark,

Ive managed to get data into the database. All seemed to go well, I can
connect to the new db via QuantumGIS and view the data without problem.
However, my geometry column is messed up. In the old db the column contained
regular looking entries, in the new db I have what appears to be binary or
hex entries, this is an example of what the geom_col contains :

010600002040A50000010000000103000000020000005B020000000000602F1224C1000000A0
F4F9294100000060691224C1000000E0FDF92941000000A0721224C1000000E0C3F929410000
00A0AC1224C100000020CDF92941000000A0E61224C100000060D6F9294100000060DD1224C1
0000006010FA294100000060171324C1000000A019FA29 ... and on ..

This seems highly abnormal. Any Ideas?

Many Thanks
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 11:30 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: 16 November 2005 15:20
> To: 'PostGIS Users Discussion'
> Subject: RE: [postgis-users] trouble with moving data
> 
> 
> 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


Hi Jeremy,

My guess would be that you are executing postgis_restore.pl from the command
prompt and so it is picking up the name of your Windows user instead of the
username of the database superuser. You should be able to use the PGUSER
environmental variable to override this, e.g.:

set PGUSER=pg81
postgis_restore.pl lwpostgis.sql new_database dump_file > restore.log


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