maybe you could first reduce the problem
create a view of all fields of your table except the geom columns
try to pg_dump it, this don't need postgis so could go
create a second view of the geom columns specifying AsText(geom) and a
field reference
copy this view to a text file with \g option
ever when you
> restore if you want.
>
> ** **
>
> Hope that helps,
>
> Leo and Regina
>
> http://www.postgis.us
>
> ** **
> --
>
> *From:* postgis-users-boun...@postgis.refractions.net [mailto:
>
s
Gat
Sent: Tuesday, August 16, 2011 6:29 PM
To: postgis-users@postgis.refractions.net
Subject: [postgis-users] Help dumping data from an old database
Hello,
I've recently been tasked with reviving an older database that hasn't been
touch in a while. Both postgres and postgis were used
Chris,
This is probably a bad suggestion, but iff you are desparate and iff you can
build a more recent postgis, then to dump it out you may find that creating a
simlink from a more recent liblwgeom.so with the name of the missing one might
work. the COPY command won't actually take anything ot
Chris, just use the postgres copy command to copy out the data you need, and
then copy into your new DB then. It can take an arbitrary sql expression so if
needed do a query that grabs the columns you care about and ignores the
location ones.
hth
charles
On Aug 16, 2011, at 6:28 PM, Chris Gat
Hello,
I've recently been tasked with reviving an older database that hasn't been
touch in a while. Both postgres and postgis were used to create this
database. My ultimate goal at this point is to be able to dump the database
from the linux server where it currently resides, to a mac workstation.
