[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: [postgis-users] Ynt: pg_restore: error: could not execute query: ERROR: function public.st_accum(pub
From: Bekir Niyaz <bagafoot () hotmail ! com>
Date: 2020-10-16 8:21:10
Message-ID: AM6PR04MB4421FFE6E8340D44CA5A2429D8030 () AM6PR04MB4421 ! eurprd04 ! prod ! outlook ! com
[Download RAW message or body]
Thank you Regina,
> Did you install PostGIS on 2.5.2 using scripts or extension? Those functions \
> shouldn’t even be in your backup if you used an extension install.
Yes I used extension install
> It could however be complaining about references in your code to those.
There is no any code, or function created by developer, only postgis functions.
> Do not drop postgis 2.5.2 as that would drop your geometry and raster columns.
If there is columns depend on postgis, should be error on droping extension, right ? \
But I easily can drop extension. May it hint to solution?
ERROR: cannot drop extension postgis because other objects depend on it
DETAIL: column geo of table tbl_sapmle depends on type geometry
HINT: Use DROP ... CASCADE to drop the dependent objects too.
> CREATE EXTENSION postgis_raster; -- raster was broken out of the postgis extension \
> in 3.0
> That should fix the raster errors.
Yes, total errors had decreased. All errors about grants cannot find functions
Command was: GRANT ALL ON FUNCTION public._st_distance(public.geography, \
public.geography, double precision, boolean) TO cedyetrapor_app;GRANT ALL ON FUNCTION \
public._st_distance(public.geography, public.geography, double precision, boolean) TO \
test_user;
other errors:
pg_restore: error: could not execute query: ERROR: function \
public._st_asgeojson(integer, public.geography, integer, integer) \
does not exist
pg_restore: error: could not execute query: ERROR: function \
public._st_asgeojson(integer, public.geometry, integer, integer) does \
not exist
pg_restore: error: could not execute query: ERROR: function \
public._st_asgml(integer, public.geography, integer, integer, text, text) does not \
exist
pg_restore: error: could not execute query: ERROR: function \
public._st_askml(integer, public.geography, integer, text) does not \
exist
pg_restore: error: could not execute query: ERROR: function \
public._st_askml(integer, public.geometry, integer, text) does not \
exist
pg_restore: error: could not execute query: ERROR: function \
public._st_buffer(public.geometry, double precision, cstring) does \
not exist
pg_restore: error: could not execute query: ERROR: function \
public._st_distance(public.geography, public.geography, double precision, boolean) \
does not exist
.......
> In your old database try to find in your views (I’m guessing might be where it’s \
> coming from) reference to ST_Accum use -- and change them to use array_agg \
> instead.
You mean functions here ?, because there is only default postgis views
public | geography_columns | view | postgres
public | geometry_columns | view | postgres
public | raster_columns | view | postgres
public | raster_overviews | view | postgres
Thank you again for your atention.
Best regards.
________________________________
Gönderen: Regina Obe <lr@pcorp.us> adýna postgis-users \
<postgis-users-bounces@lists.osgeo.org> Gönderildi: 15 Ekim 2020 Perþembe 11:28
Kime: 'PostGIS Users Discussion' <postgis-users@lists.osgeo.org>
Konu: Re: [postgis-users] pg_restore: error: could not execute query: ERROR: function \
public.st_accum(public.geometry) does not exist
Did you install PostGIS on 2.5.2 using scripts or extension? Those functions \
shouldn’t even be in your backup if you used an extension install.
It could however be complaining about references in your code to those.
Do not drop postgis 2.5.2 as that would drop your geometry and raster columns.
If you can’t upgrade the old to 3.0, do the following on new
CREATE EXTENSION postgis_raster; -- raster was broken out of the postgis extension \
in 3.0
That should fix the raster errors.
In your old database try to find in your views (I’m guessing might be where it’s \
coming from) reference to ST_Accum use -- and change them to use array_agg instead.
ST_Accum was removed in 3.0 as it’s redundant and less performant than PostgreSQL \
built in array_agg
Hope that helps,
Regina
From: postgis-users [mailto:postgis-users-bounces@lists.osgeo.org] On Behalf Of Bekir \
Niyaz
Sent: Thursday, October 15, 2020 4:07 AM
To: postgis-users@lists.osgeo.org
Subject: [postgis-users] pg_restore: error: could not execute query: ERROR: function \
public.st_accum(public.geometry) does not exist
I 'm trying restore backup from pg11 postgis 2.5.2 to pg12 postgis 3.0.0, but restore \
failing.
If I drop postgis 2.5.2 on source server and install 3.0.0 will It cause the problem \
?
details:
source db (where backup taken):
PostgreSQL 11.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 \
(Red Hat 4.8.5-28), 64-bit
POSTGIS="2.5.2 r17328" [EXTENSION] PGSQL="110" GEOS="3.7.1-CAPI-1.11.1 27a5e771" \
PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL
1.11.4, released 2016/01/25" LIBXML="2.9.1" LIBJSON="0.11" RASTER
target db (where restore):
PostgreSQL 12.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 \
(Red Hat 4.8.5-39), 64-bit
POSTGIS="3.0.0 r17983" [EXTENSION] PGSQL="120" GEOS="3.8.0-CAPI-1.13.1 " \
SFCGAL="1.3.1" PROJ="6.2.1" LIBXML="2.9.1" LIBJSON="0
.11" LIBPROTOBUF="1.0.2" WAGYU="0.4.3 (Internal)" TOPOLOGY
dump file:
Dump Version: 1.14-0
Format: CUSTOM
Integer: 4 bytes
Offset: 8 bytes
Dumped from database version: 11.1
Dumped by pg_dump version: 12.1
example errors:
pg_restore: error: could not execute query: ERROR: function \
public.st_accum(public.geometry) does not exist
Command was: GRANT ALL ON FUNCTION public.st_accum(public.geometry) TO test_app;
pg_restore: error: could not execute query: ERROR: type "public.raster" does not \
exist
Command was: GRANT ALL ON FUNCTION public.st_countagg(public.raster, boolean) TO \
test_app;
[Attachment #3 (text/html)]
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1254">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} \
</style> </head>
<body dir="ltr">
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: \
rgb(0, 0, 0);"> Thank you Regina,</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: \
rgb(0, 0, 0);"> <br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: \
rgb(0, 0, 0);"> ><span style="color: rgb(31, 73, 125); font-family: Calibri, \
sans-serif; font-size: 14.6667px; background-color: rgb(255, 255, 255); display: \
inline !important">Did you install PostGIS on 2.5.2 using scripts or extension? \
Those functions shouldn’t even be in your backup if you used an extension \
install.</span></div> <div style="font-family: Calibri, Helvetica, sans-serif; \
font-size: 12pt; color: rgb(0, 0, 0);"> <span style="color: rgb(31, 73, 125); \
font-family: Calibri, sans-serif; font-size: 14.6667px; background-color: rgb(255, \
255, 255); display: inline !important">Yes I used extension install</span></div> <div \
style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, \
0);"> <span style="color: rgb(31, 73, 125); font-family: Calibri, sans-serif; \
font-size: 14.6667px; background-color: rgb(255, 255, 255); display: inline \
!important"><br> </span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: \
rgb(0, 0, 0);"> <span style="color: rgb(31, 73, 125); font-family: Calibri, \
sans-serif; font-size: 14.6667px; background-color: rgb(255, 255, 255); display: \
inline !important">><span style="font-family: Calibri, sans-serif; \
background-color: rgb(255, 255, 255); display: inline !important">It could however \
be complaining about references in your code to those. </span></span></div> <div \
style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, \
0);"> <span style="color: rgb(31, 73, 125); font-family: Calibri, sans-serif; \
font-size: 14.6667px; background-color: rgb(255, 255, 255); display: inline \
!important"><span style="font-family: Calibri, sans-serif; background-color: rgb(255, \
255, 255); display: inline !important">There is no any code, or function created by \
developer, only postgis functions.</span></span></div> <div style="font-family: \
Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"> <span \
style="color: rgb(31, 73, 125); font-family: Calibri, sans-serif; font-size: \
14.6667px; background-color: rgb(255, 255, 255); display: inline !important"><span \
style="font-family: Calibri, sans-serif; background-color: rgb(255, 255, 255); \
display: inline !important"><br> </span></span></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: \
rgb(0, 0, 0);"> <span style="color: rgb(31, 73, 125); font-family: Calibri, \
sans-serif; font-size: 14.6667px; background-color: rgb(255, 255, 255); display: \
inline !important"><span style="font-family: Calibri, sans-serif; background-color: \
rgb(255, 255, 255); display: inline !important">><span style="font-family: \
Calibri, sans-serif; background-color: rgb(255, 255, 255); display: inline \
!important">Do not drop postgis 2.5.2 as that would drop your geometry and raster \
columns.</span></span></span></div> <div style=""><font color="#1f497d" \
face="Calibri, sans-serif"><span style="font-size: 14.6667px;">If there is columns \
depend on postgis, should be error on droping extension, right ? But I \
easily <span style="font-family: Calibri, sans-serif; background-color: rgb(255, \
255, 255); display: inline !important">can</span> drop extension. May it hint \
to solution?</span></font></div> <div style=""><font color="#1f497d" face="Calibri, \
sans-serif"><span style="font-size: 14.6667px;">ERROR: cannot drop extension \
postgis because other objects depend on it <div>DETAIL: column geo of table \
tbl_sapmle depends on type geometry</div> <div>HINT: Use DROP ... CASCADE to \
drop the dependent objects too.</div> <br>
></span></font><span style="color: rgb(31, 73, 125); font-family: Calibri, \
sans-serif; font-size: 11pt;">CREATE EXTENSION postgis_raster; -- raster was \
broken out of the postgis extension in 3.0</span><font color="#1f497d" face="Calibri, \
sans-serif"><span style="font-size: 14.6667px;"> <p class="x_MsoNormal" style="color: \
rgb(0, 0, 0); background-color: rgb(255, 255, 255); margin: 0in 0in 0.0001pt; \
font-size: 12pt; font-family: "Times New Roman", serif"> <span \
style="margin: 0px; font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(31, \
73, 125)">>That should fix the raster errors.</span></p> </span></font></div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: \
rgb(0, 0, 0);"> <br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: \
rgb(0, 0, 0);"> Yes, total errors had decreased. All errors about grants cannot find \
functions</div> <div style="font-family: Calibri, Helvetica, sans-serif; font-size: \
12pt; color: rgb(0, 0, 0);"> Command was: GRANT ALL ON FUNCTION \
public._st_distance(public.geography, public.geography, double precision, boolean) TO \
cedyetrapor_app;GRANT ALL ON FUNCTION public._st_distance(public.geography, \
public.geography, double precision, boolean) TO test_user; </div> <div \
style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, \
0);"> <br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: \
rgb(0, 0, 0);"> other errors:</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: \
rgb(0, 0, 0);">
pg_restore: error: could not execute query: ERROR: function \
public._st_asgeojson(integer, public.geography, integer, integer) does not exist \
<div>pg_restore: error: could not execute query: ERROR: function \
public._st_asgeojson(integer, public.geometry, integer, integer) does not exist</div> \
<div>pg_restore: error: could not execute query: ERROR: function \
public._st_asgml(integer, public.geography, integer, integer, text, text) does not \
exist</div> <div>pg_restore: error: could not execute query: ERROR: function \
public._st_askml(integer, public.geography, integer, text) does not exist</div> \
<div>pg_restore: error: could not execute query: ERROR: function \
public._st_askml(integer, public.geometry, integer, text) does not exist</div> \
<div>pg_restore: error: could not execute query: ERROR: function \
public._st_buffer(public.geometry, double precision, cstring) does not exist</div> \
<div>pg_restore: error: could not execute query: ERROR: function \
public._st_distance(public.geography, public.geography, double precision, boolean) \
does not exist</div> <div>.......</div>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: \
rgb(0, 0, 0);"> <br>
</div>
<div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: \
rgb(0, 0, 0);"> ><span style="color: rgb(31, 73, 125); font-family: Calibri, \
sans-serif; font-size: 14.6667px; background-color: rgb(255, 255, 255); display: \
inline !important">In your old database try to find in your views (I’m guessing might \
be where it’s coming from) reference to ST_Accum use -- and change them to use \
array_agg instead.</span></div> <div>
<div id="appendonsend"></div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; \
color:rgb(0,0,0)"> <br>
</div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; \
color:rgb(0,0,0)"> You mean functions here ?, because there is only default postgis \
views</div> <div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; \
color:rgb(0,0,0)"> public | geography_columns | view | postgres
<div> public | geometry_columns | view | postgres</div>
<div> public | raster_columns | view | postgres</div>
<div> public | raster_overviews | view | postgres</div>
<br>
Thank you again for your atention.</div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; \
color:rgb(0,0,0)"> Best regards.</div>
<div style="font-family:Calibri,Helvetica,sans-serif; font-size:12pt; \
color:rgb(0,0,0)"> </div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" \
style="font-size:11pt"><b>Gönderen:</b> Regina Obe <lr@pcorp.us> adýna \
postgis-users <postgis-users-bounces@lists.osgeo.org><br> <b>Gönderildi:</b> 15 \
Ekim 2020 Perþembe 11:28<br> <b>Kime:</b> 'PostGIS Users Discussion' \
<postgis-users@lists.osgeo.org><br> <b>Konu:</b> Re: [postgis-users] \
pg_restore: error: could not execute query: ERROR: function \
public.st_accum(public.geometry) does not exist</font> <div> </div>
</div>
<div lang="EN-US">
<div class="x_WordSection1">
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span style="font-size:11.0pt; \
font-family:"Calibri",sans-serif; color:#1F497D">Did you install PostGIS on \
2.5.2 using scripts or extension? Those functions shouldn’t even be in your \
backup if you used an extension install.</span></p> <p class="x_MsoNormal" \
style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New \
Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;"> <span style="font-size:11.0pt; \
font-family:"Calibri",sans-serif; color:#1F497D"> </span></p> <p \
class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span style="font-size:11.0pt; \
font-family:"Calibri",sans-serif; color:#1F497D">It could however be \
complaining about references in your code to those.</span></p> <p class="x_MsoNormal" \
style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New \
Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;"> <span style="font-size:11.0pt; \
font-family:"Calibri",sans-serif; color:#1F497D"> </span></p> <p \
class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span style="font-size:11.0pt; \
font-family:"Calibri",sans-serif; color:#1F497D">Do not drop postgis 2.5.2 \
as that would drop your geometry and raster columns.</span></p> <p \
class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span style="font-size:11.0pt; \
font-family:"Calibri",sans-serif; color:#1F497D"> </span></p> <p \
class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span style="font-size:11.0pt; \
font-family:"Calibri",sans-serif; color:#1F497D">If you can’t upgrade the \
old to 3.0, do the following on new</span></p> <p class="x_MsoNormal" style="margin: \
0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", \
serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New \
Roman", serif;"> <span style="font-size:11.0pt; \
font-family:"Calibri",sans-serif; color:#1F497D"> </span></p> <p \
class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span style="font-size:11.0pt; \
font-family:"Calibri",sans-serif; color:#1F497D">CREATE EXTENSION \
postgis_raster; -- raster was broken out of the postgis extension in \
3.0</span></p> <p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: \
12pt; font-family: "Times New Roman", serif;margin: 0in 0in 0.0001pt; \
font-size: 12pt; font-family: "Times New Roman", serif;"> <span \
style="font-size:11.0pt; font-family:"Calibri",sans-serif; \
color:#1F497D"> </span></p> <p class="x_MsoNormal" style="margin: 0in 0in \
0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: \
0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;"> \
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; \
color:#1F497D">That should fix the raster errors.</span></p> <p class="x_MsoNormal" \
style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New \
Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;"> <span style="font-size:11.0pt; \
font-family:"Calibri",sans-serif; color:#1F497D"> </span></p> <p \
class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span style="font-size:11.0pt; \
font-family:"Calibri",sans-serif; color:#1F497D">In your old database try \
to find in your views (I’m guessing might be where it’s coming from) reference to \
ST_Accum use -- and change them to use array_agg instead.</span></p> <p \
class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span style="font-size:11.0pt; \
font-family:"Calibri",sans-serif; color:#1F497D"> </span></p> <p \
class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span style="font-size:11.0pt; \
font-family:"Calibri",sans-serif; color:#1F497D">ST_Accum was removed in \
3.0 as it’s redundant and less performant than PostgreSQL built in \
array_agg</span></p> <p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; \
font-size: 12pt; font-family: "Times New Roman", serif;margin: 0in 0in \
0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;"> <span \
style="font-size:11.0pt; font-family:"Calibri",sans-serif; \
color:#1F497D"> </span></p> <p class="x_MsoNormal" style="margin: 0in 0in \
0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;margin: \
0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;"> \
<span style="font-size:11.0pt; font-family:"Calibri",sans-serif; \
color:#1F497D">Hope that helps,</span></p> <p class="x_MsoNormal" style="margin: 0in \
0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", \
serif;margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New \
Roman", serif;"> <span style="font-size:11.0pt; \
font-family:"Calibri",sans-serif; color:#1F497D">Regina</span></p> <p \
class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span style="font-size:11.0pt; \
font-family:"Calibri",sans-serif; color:#1F497D"> </span></p> <p \
class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span style="font-size:11.0pt; \
font-family:"Calibri",sans-serif; color:#1F497D"> </span></p> <div \
style="border:none; border-left:solid blue 1.5pt; padding:0in 0in 0in 4.0pt"> <div>
<div style="border:none; border-top:solid #E1E1E1 1.0pt; padding:3.0pt 0in 0in 0in">
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <b><span style="font-size:11.0pt; \
font-family:"Calibri",sans-serif">From:</span></b><span \
style="font-size:11.0pt; font-family:"Calibri",sans-serif"> postgis-users \
[mailto:postgis-users-bounces@lists.osgeo.org] <b>On Behalf Of </b>Bekir Niyaz<br>
<b>Sent:</b> Thursday, October 15, 2020 4:07 AM<br>
<b>To:</b> postgis-users@lists.osgeo.org<br>
<b>Subject:</b> [postgis-users] pg_restore: error: could not execute query: ERROR: \
function public.st_accum(public.geometry) does not exist</span></p> </div>
</div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> </p>
<div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black">I 'm trying restore \
backup from pg11 postgis 2.5.2 to pg12 postgis 3.0.0, but restore failing. \
</span></p> <div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black"> </span></p> \
</div> <div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black">If I drop postgis \
2.5.2 on source server and install 3.0.0 will It cause the problem ?</span></p> \
</div> <div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black"> </span></p> \
</div> <div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black">details: </span></p> \
</div> <div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black"> </span></p> \
</div> <div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black">source db (where \
backup taken):</span></p> </div>
<div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black"> </span></p> \
</div> <div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black"> \
PostgreSQL 11.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 \
(Red Hat 4.8.5-28), 64-bit</span></p> </div>
<div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black"> \
POSTGIS="2.5.2 r17328" [EXTENSION] PGSQL="110" \
GEOS="3.7.1-CAPI-1.11.1 27a5e771" PROJ="Rel. 4.9.3, 15 August \
2016" GDAL="GDAL</span></p> </div>
<div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black"> 1.11.4, \
released 2016/01/25" LIBXML="2.9.1" LIBJSON="0.11" \
RASTER</span></p> </div>
<div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black"> </span></p> \
</div> <div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black">target db (where \
restore):</span></p> </div>
<div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black"> </span></p> \
</div> <div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black"> \
PostgreSQL 12.4 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 \
(Red Hat 4.8.5-39), 64-bit</span></p> </div>
<div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black"> \
POSTGIS="3.0.0 r17983" [EXTENSION] PGSQL="120" \
GEOS="3.8.0-CAPI-1.13.1 " SFCGAL="1.3.1" PROJ="6.2.1" \
LIBXML="2.9.1" LIBJSON="0</span></p> </div>
<div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black"> \
.11" LIBPROTOBUF="1.0.2" WAGYU="0.4.3 (Internal)" \
TOPOLOGY</span></p> </div>
<div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black"> </span></p> \
</div> <div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black"> dump \
file:</span></p> </div>
<div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black"> </span></p> \
</div> <div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black"> </span></p> \
</div> <div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black"> \
Dump Version: 1.14-0</span></p> </div>
<div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black"> \
Format: CUSTOM</span></p> </div>
<div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black"> \
Integer: 4 bytes</span></p> </div>
<div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black"> \
Offset: 8 bytes</span></p> </div>
<div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black"> \
Dumped from database version: 11.1</span></p> </div>
<div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black"> \
Dumped by pg_dump version: 12.1</span></p> </div>
<div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black"> </span></p> \
</div> <div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black"> </span></p> \
</div> <div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black">example \
errors:</span></p> </div>
<div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black"> </span></p> \
</div> <div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black"> \
pg_restore: error: could not execute query: ERROR: function \
public.st_accum(public.geometry) does not exist</span></p> </div>
<div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black"> Command \
was: GRANT ALL ON FUNCTION public.st_accum(public.geometry) TO test_app;</span></p> \
</div> <div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black"> \
pg_restore: error: could not execute query: ERROR: type \
"public.raster" does not exist</span></p> </div>
<p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: \
"Times New Roman", serif;margin: 0in 0in 0.0001pt; font-size: 12pt; \
font-family: "Times New Roman", serif;"> <span \
style="font-family:"Calibri",sans-serif; color:black"> Command \
was: GRANT ALL ON FUNCTION public.st_countagg(public.raster, boolean) TO \
test_app;</span></p> </div>
</div>
</div>
</div>
</div>
</body>
</html>
[Attachment #4 (unknown)]
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic