...
| Code Block |
|---|
yum install zlib.x86_64 zlib-devel.x86_64 |
During pg_restore you may see the following:
| Code Block |
|---|
pg_restore --host localhost --port 5432 --username postgres --dbname mad ./mad-1_0-beta-2.backup
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 734; 1255 116672554 FUNCTION st_simplifypreservetopology(geometry, double precision) postgres
pg_restore: [archiver (db)] could not execute query: ERROR: could not find function "topologypreservesimplify" in file "/usr/lib64/pgsql/liblwgeom.so"
Command was: CREATE FUNCTION st_simplifypreservetopology(geometry, double precision) RETURNS geometry
AS '$libdir/liblwgeom', 'topolo...
pg_restore: [archiver (db)] could not execute query: ERROR: function public.st_simplifypreservetopology(geometry, double precision) does not exist
Command was: ALTER FUNCTION public.st_simplifypreservetopology(geometry, double precision) OWNER TO postgres;
WARNING: errors ignored on restore: 2
[postgres@CentOSDB17882 ~]$
|
solution
Don't worry about it.
This is because we upgraded postgres and postgis.
Moreover, we do not use these functions.