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.
Steven Hammond
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
------------------------------------------------------------------------------
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
