| From: | Jeremy Wilson <jwilson(at)clover(dot)co> |
|---|---|
| To: | Magnus Hagander <magnus(at)hagander(dot)net> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <bruce(at)momjian(dot)us>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>, Devrim Gunduz <devrim(at)gunduz(dot)org> |
| Subject: | Re: Issue upgrading from 9.5 to 13 with pg_upgrade: "connection to database failed: FATAL: database "template1" does not exist" |
| Date: | 2020-11-13 19:19:21 |
| Message-ID: | A9F0D07C-16A9-4CE0-A516-D7CE086D2CC6@clover.co |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> On Nov 13, 2020, at 1:10 PM, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
>
> The problem is that postgis, through gdal, ended up being linked to two different versions of proj at the same time.
>
> You can check it by doing:
> ldd /usr/pgsql-13/lib/postgis_raster-3.so | grep proj
>
> If that shows up two different "proj" libraries, then you have that same problem.
Just wanted to reply that this was indeed an issue. After removing the proj RPMs and reinstalling, the upgrade seems to be running now.
On a side note, you need to enable the PowerTools repo on CentOS to install PostGIS, otherwise it complains about the gdal libraries being missing.
If I run into another failure I’ll update the list - thanks!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Brannen | 2020-11-13 19:20:29 | RE: New "function tables" in V13 documentation |
| Previous Message | Adrian Klaver | 2020-11-13 18:14:53 | Re: Issue upgrading from 9.5 to 13 with pg_upgrade: "connection to database failed: FATAL: database "template1" does not exist" |