Just to clarify, this is my problem: $ pg_lsclusters Ver Cluster Port Status Owner Data directory Log file 9.5 main 5432 online postgres /var/lib/postgresql/9.5/main /var/log/ postgresql/postgresql-9.5-main.log 10 main 5433 online postgres /var/lib/postgresql/10/main /var/log/ postgresql/postgresql-10-main.log
On Thursday, September 6, 2018 2:25:24 PM EDT Ivan Adzhubey wrote: > Hi, > > After some investigation, it turns out it's even more complicated. > > The OS upgrade has actually installed Postgres 10 *but* also left Postgres > 9.5 installed as well. And now I have two versions of the Postgres code at > the same time: 'psql' command shows some dubious version string which looks > like a mess: > > # psql -h localhost bacula bacula > Password for user bacula: > psql (10.5 (Ubuntu 10.5-0ubuntu0.18.04), server 9.5.14) > <...> > > Seems that the client version is 10.5 but the server it connects to is still > v9.5.14. > > Any ideas on how one would migrate to Postgres v10 properly? > > Thanks, > Ivan > > On Thursday, September 6, 2018 1:13:26 PM EDT Ivan Adzhubey wrote: > > Hi all, > > > > I have just upgraded from Ubuntu 16.04 LTS to Ubuntu 18.04.1 LTS in our > > backup server and was greeted during the upgrade process by a message > > saying that the installed version 9.5 of Postgres (which the server have > > been using for Bacula database) is now obsolete and will no longer be > > supported. The message suggested upgrading to Postgres 10 but I was unable > > to find any Bacula compatibility information for this version. Do you know > > if it will be safe to upgrade? Bacula itself has been seamlessly updated > > to > > version 9.0.6 during the OS upgrade and so far seems to be working fine > > but > > it still uses obsolete Postgres v9.5. > > > > Thanks, > > Ivan The information in this e-mail is intended only for the person to whom it is addressed. If you believe this e-mail was sent to you in error and the e-mail contains patient information, please contact the Partners Compliance HelpLine at http://www.partners.org/complianceline . If the e-mail was sent to you in error but does not contain patient information, please contact the sender and properly dispose of the e-mail. ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
