Hi Dimitri,
I was hoping someone has done this before with the Bacula catalog
specifically. Anyway, I followed generic Debian Postgres documentation for the
upgrade procedure and it has worked as expected. Have run some tests on my
Bacula catalog after migrating it to v10 and do not see any problems so far.
Hopefully, there will be none in the future but we will see.
Thanks,
Ivan
On Thursday, September 6, 2018 2:50:06 PM EDT 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.
--
Ivan Adzhubey, Ph.D.
Instructor
Division of Genetics, Dept of Medicine
Brigham & Women's Hospital
Harvard Medical School
New Research Building, Room 0464C
77 Avenue Louis Pasteur
Boston, MA 02115
tel.: (617) 525-4728
fax: (617) 525-4705
web: http://genetics.bwh.harvard.edu/wiki/sunyaevlab/
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
