Mark Cave-Ayland pisze:
Ivan Mincik wrote:
Also for me, it is more comfortable to do dump/restore upgrade. I have
also some experience with problematic "hard" upgrades.
Mark, which pg_dump/pg_restore options do You for dumping tables. Can
You explain little bit "You way" ?
How do You extract commands which create old version postgis fuctions ?
Do You extract tables with "-t" options, so the resulting SQL is
containing only CREATE TABLE and INSERT commands?
Ivan
Sure. Depending upon the amount of data/dump format I normally either:
1) pg_dump -t individual tables/sequences into individual files
or
2) Use pg_restore -L/-l options to remove all PostGIS functions from a
compressed format dump catalogue, then restore the remaining data into a
new database.
On my new machine I then create a brand new PostGIS database and then
simply restore any backup files into it. This guarantees that the SQL
definitions and the PostGIS shared library are always in sync.
Thanks for your answers!
So you think that best way is to make single dump for every
table/sequence ? How to do that if i have lots of tables (about 500),
views and sequences ? And how to dump user functions ?
I am not sure if my description in first email was clear enough. For
every function from list (and only them):
public.asgml(geometry, integer, integer)
public.asukml(geometry, integer, integer)
public.asukml(geometry, integer)
public.asukml(geometry)
public.st_pointn(geometry)
i have same error: missing "$libdir/liblwgeom.so.1.2". So something
like that:
CREATE FUNCTION asgml(geometry, integer, integer) RETURNS text
AS '$libdir/liblwgeom.so.1.2', 'LWGEOM_asGML'
LANGUAGE c IMMUTABLE STRICT;
ERROR: could not access file "$libdir/liblwgeom.so.1.2": No suchfile or
directory
I was looking to file lwpostgis.sql - and there are no such functions !
(asukml at all, asgm and st_pointn exist but with different arguments) .
Another question. Is there a way to check if my Postgis is ok after
upgrade ?
Mateusz Naskręt
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
