Hi Steven,
On Thursday, September 6, 2018 2:55:23 PM EDT Steven Hammond wrote:
> I'm no way a db expert, but we use Bacula on Ubuntu 18.04 with
> Postgresql 10 with no issues. We had the same issue but just used
> pg_upgradecluster and pg_dropcluster to migrate to v10.
That sounded encouraging enough, so I bit the bullet. Used standard cluster
upgrading procedure as described in the README.Debian to migrate my bacula
catalog database on the fly to v10 cluster and it seemed to work. I would keep
my eye on it for a few days but so far my test restores worked as expected, so
the catalog looks like it is in good shape.
Thanks,
Ivan
> On 9/6/2018 1:50 PM, Dimitri Maziuk via Bacula-users wrote:
> > On 09/06/2018 01:34 PM, Ivan Adzhubey wrote:
> >> 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
> >
> > They're set up to coexist. You could switch port to 5434 and give v.10 a
> > try but I have a suspicion there is no sane way to do that in bacula.
> >
> > FWIW we have not seen any compatibility problems in v.10, but we're not
> > using it with bacula. All I can see in bacula is
> >
> > /usr/libexec/bacula/create_postgresql_database:
> >> case ${PSQLVERSION} in
> >>
> >> 9.*)
> >>
> >> ENCODING="ENCODING 'SQL_ASCII' LC_COLLATE 'C' LC_CTYPE 'C'"
> >>
> >> ;;
> >> 8.[456789])
> >>
> >> ENCODING="ENCODING 'SQL_ASCII' LC_COLLATE 'C' LC_CTYPE 'C'"
> >>
> >> ;;
> >> *)
> >>
> >> ENCODING="ENCODING 'SQL_ASCII'"
> >>
> >> ;;
> >>
> >> esac
> >
> > I don't see why duplicating the "9.*)" block for "10.*)" wouldn't work.
> >
> >
> >
> > --------------------------------------------------------------------------
> > ---- 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
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
