Re: F27 to F28 - Postgresql upgrade fails

[Samuel Sieb]

On 06/15/2018 02:28 PM, Clifford Snow wrote:
I did not receive any error messages during or after the upgrade. My 
first clue was a cron entry that failed with a message that the 
postgresql db wasn't running.


There would have been a message in the journal about why it wasn't 
starting.  "systemctl status postgresql" would have given you some info 
as well.

___
users mailing list -- users@lists.fedoraproject.org
To unsubscribe send an email to users-le...@lists.fedoraproject.org
Fedora Code of Conduct: https://getfedora.org/code-of-conduct.html
List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines
List Archives: 
https://lists.fedoraproject.org/archives/list/users@lists.fedoraproject.org/message/EON5VLAKL4YY4F2KRJN3CH7TJ66DLJHI/

Re: F27 to F28 - Postgresql upgrade fails

[Clifford Snow]

Samuel,
I did not receive any error messages during or after the upgrade. My first
clue was a cron entry that failed with a message that the postgresql db
wasn't running.

Like you, I thought the problem was fixed. (I did add to the bugzilla
report you referenced in 2017) From searching on the problem, it appears
that it is still happening. That's where I found what appeared to be a
solution, which didn't work for me.

Because I have currently daily backups, I went ahead and restored my
database manually.

The good news is that Postgresql 10.4 has better support for partitioning.
I'm now in the process of learning how to partition my almost 60M record
table. I've been putting it off until Fedora included postgresql 10.

Clifford

On Thu, Jun 14, 2018 at 11:38 PM Samuel Sieb  wrote:

> On 06/14/2018 09:43 AM, Clifford Snow wrote:
> > I just upgraded from Fedora 27 to 28. Everything working except the
> > upgrade from Postgresql 9.6 to 10
> >
> > Searching for help led me to manually add postgis-2.3.so
> >  and rtpostgis-2.3.so 
> > to /usr/lib64/pgsql/ and /usr/lib64/pgsql/postgresql-9.6/lib/
>
> Was there an error message that led you to that?  The postgis upgrade
> problem is supposed to be fixed:
> https://bugzilla.redhat.com/show_bug.cgi?id=1055293
>
> Giving the original error message would be helpful.
> ___
> users mailing list -- users@lists.fedoraproject.org
> To unsubscribe send an email to users-le...@lists.fedoraproject.org
> Fedora Code of Conduct: https://getfedora.org/code-of-conduct.html
> List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines
> List Archives:
> https://lists.fedoraproject.org/archives/list/users@lists.fedoraproject.org/message/XGGXI6ALY4MFRYGXKVS3LNYKBUH7JEI4/
>


-- 
@osm_seattle
osm_seattle.snowandsnow.us
OpenStreetMap: Maps with a human touch
___
users mailing list -- users@lists.fedoraproject.org
To unsubscribe send an email to users-le...@lists.fedoraproject.org
Fedora Code of Conduct: https://getfedora.org/code-of-conduct.html
List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines
List Archives: 
https://lists.fedoraproject.org/archives/list/users@lists.fedoraproject.org/message/TGWGKD5YIUA5U52NPYWI633EDR4OWKY6/

Re: F27 to F28 - Postgresql upgrade fails

[Samuel Sieb]

On 06/14/2018 09:43 AM, Clifford Snow wrote:
I just upgraded from Fedora 27 to 28. Everything working except the 
upgrade from Postgresql 9.6 to 10


Searching for help led me to manually add postgis-2.3.so 
 and rtpostgis-2.3.so  
to /usr/lib64/pgsql/ and /usr/lib64/pgsql/postgresql-9.6/lib/


Was there an error message that led you to that?  The postgis upgrade 
problem is supposed to be fixed:

https://bugzilla.redhat.com/show_bug.cgi?id=1055293

Giving the original error message would be helpful.
___
users mailing list -- users@lists.fedoraproject.org
To unsubscribe send an email to users-le...@lists.fedoraproject.org
Fedora Code of Conduct: https://getfedora.org/code-of-conduct.html
List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines
List Archives: 
https://lists.fedoraproject.org/archives/list/users@lists.fedoraproject.org/message/XGGXI6ALY4MFRYGXKVS3LNYKBUH7JEI4/

Re: F27 to F28 - Postgresql upgrade fails

[Gordon Messmer]

On 06/14/2018 09:43 AM, Clifford Snow wrote:
I just upgraded from Fedora 27 to 28. Everything working except the 
upgrade from Postgresql 9.6 to 10


Searching for help led me to manually add postgis-2.3.so 
 and rtpostgis-2.3.so  
to /usr/lib64/pgsql/ and /usr/lib64/pgsql/postgresql-9.6/lib/


Don't do that.  Make sure you haven't overwritten something, first:

rpm -qf /usr/lib64/pgsql/{postgis-2.3.so 
,rtpostgis-2.3.so } 
/usr/lib64/pgsql/postgresql-9.6/lib/{postgis-2.3.so 
,rtpostgis-2.3.so }


If rpm reports that those files aren't owned by a package, then remove 
them.  If they are, then use dnf to reinstall the package.


Once that's straightened out, install postgresql-upgrade and use that to 
upgrade your data files.

___
users mailing list -- users@lists.fedoraproject.org
To unsubscribe send an email to users-le...@lists.fedoraproject.org
Fedora Code of Conduct: https://getfedora.org/code-of-conduct.html
List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines
List Archives: 
https://lists.fedoraproject.org/archives/list/users@lists.fedoraproject.org/message/IB6VYGR2XYGHP2MXNYLZ46Q5THR27CAZ/

F27 to F28 - Postgresql upgrade fails

[Clifford Snow]

I just upgraded from Fedora 27 to 28. Everything working except the upgrade
from Postgresql 9.6 to 10

Searching for help led me to manually add postgis-2.3.so and
rtpostgis-2.3.so to /usr/lib64/pgsql/ and
/usr/lib64/pgsql/postgresql-9.6/lib/

Then when postgresql-setup --upgrade is run a fatal error is reported for
missing libraries.
the file loadable_libraries.txt contains

could not load library "$libdir/postgis-2.3": ERROR:  could not load
library "/usr/lib64/pgsql/postgis-2.3.so": /usr/lib64/pgsql/postgis-2.3.so:
undefined symbol: Float8GetDatum
could not load library "$libdir/rtpostgis-2.3": ERROR:  could not load
library "/usr/lib64/pgsql/rtpostgis-2.3.so": /usr/lib64/pgsql/
rtpostgis-2.3.so: undefined symbol: DatumGetFloat8
could not load library "$libdir/postgis_topology-2.3": ERROR:  could not
load library "/usr/lib64/pgsql/postgis_topology-2.3.so": /usr/lib64/pgsql/
postgis_topology-2.3.so: undefined sy
mbol: DatumGetFloat8
could not load library "$libdir/address_standardizer-2.3": ERROR:  could
not access file "$libdir/address_standardizer-2.3": No such file or
directory


Any suggestions to solve this without having to manually restore from my
dump?

Thanks in advance,
Clifford

-- 
@osm_seattle
osm_seattle.snowandsnow.us
OpenStreetMap: Maps with a human touch
___
users mailing list -- users@lists.fedoraproject.org
To unsubscribe send an email to users-le...@lists.fedoraproject.org
Fedora Code of Conduct: https://getfedora.org/code-of-conduct.html
List Guidelines: https://fedoraproject.org/wiki/Mailing_list_guidelines
List Archives: 
https://lists.fedoraproject.org/archives/list/users@lists.fedoraproject.org/message/5GEUPDWYQZBPRDREV3J754YXC3OWTO55/