Solved how to deal with postgresql95 orphaned packages

[circus78]

Hi, I am using FreeBSD 13.0-RELEASE with binary packages.

I get this from my cron ( pkg version -vqRL=):

e2fsprogs-libuuid-1.46.2 < needs updating (remote has 1.46.3)

libGLU-9.0.2 < needs updating (remote has 9.0.2_1)

postfix-3.6.1,1 < needs updating (remote has 3.6.2,1)

postgresql95-client-9.5.25 ? orphaned: databases/postgresql95-client

postgresql95-server-9.5.25 ? orphaned: databases/postgresql95-server

py27-setuptools-44.0.0 ? orphaned: devel/py-setuptools

I just upgraded e2fsprogs-libuuid-1.46.2, libGLU-9.0.2 and postfix-3.6.1,1 with pkg upgrade.
How should I manage the postgresql packages? I checked on another system (with ports) the file /usr/ports/UPDATING but it seems there are no indications about it.

Thank you

 

[SirDice]

pkg-autoremove(8) will remove old and unused dependencies. In this case you probably installed databases/postgresql95-server by hand. If you still require PostgreSQL server then make a backup of the datebases, remove the old databases/postgresql95-server and install databases/postgresql12-server, then import your backed up databases.

 

[Tieks]

How should I manage the postgresql packages?

The current ports tree has databases/postgresql96-client and databases/postgresql96-server. likely a new version. You can try to set the origin of the old port to the new one:
portupgrade -o databases/postgresql96-client databases/postgresql95-client. Else delete the old ones using pkg delete -f .. and install the new ones.

 

[SirDice]

The current ports tree has databases/postgresql96-client and databases/postgresql96-server. likely a new version.

The current default PostgreSQL version is 12. So I would use that to prevent any dependency issues with packages.

Don't migrate to 9.6, it will be EoL in November 2021:

The PostgreSQL community will stop releasing updates for the 9.6.X release series in November 2021. Users are encouraged to update to a newer release branch soon.

Release 9.6.23

www.postgresql.org