[postgis-users] trouble with moving data

[Nicolas Ribot]

Hello Jeremy,

I think this is completely normal: Postgis changed the way it stores
geographical data. Before 1.x series, the canonical representation for
geometries was a textual one based on WKT.
Now, postgis uses extended WKB (binary) representation (EWKB) to store
geometries internally.

You can test your data converting them into a textual format before display.
A query like
select astext(the_geom) from myTable;
should do the trick.

Nicolas

On 11/16/05, Sears, Jeremy <Jeremy.Sears at ccrs.nrcan.gc.ca> wrote:
> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>