Dear "Erik P. Olsen",
In message <20210428151738.2ad7f...@erik-pc.epolan.dk> you wrote:
> Hello,
>
> I am planning to upgrade to Bacula 11.0.2 but reading about how to convert
> the catalogue
> makes me a bit uneasy. The statement is: "Normally, it is automatic". What
> does it mean
> that it is automatic? Does it actually run the script by itself first time
> Bacula 11.02
> is started?
Just did the upgrade in Fedora 33; it was not automatic here. After
running the usual "dnf upgrade", the director could no longer
connect to the PostgreSQL DB.
To migrate the DB, run as user "postgres" (!):
$ /usr/libexec/bacula/update_bacula_tables
Altering postgresql tables
This script will update a Bacula PostgreSQL database
from any from version 12-16 or 1014-1021 to version 1022
which is needed to convert from any Bacula Enterprise
version 4.0.x, 6.x.y, 8.x.y, 10.x.y to version 12.4.x
Dumping File table to /data/pgsql/file1017.data.
The process may fail if the current user
doesn't have write permission on the current directory,
or if the system doesn't have enough space to store a
compressed export of the File table
BEGIN
DROP TABLE
DROP TABLE
CREATE TABLE
COMMIT
Loading the File table from /data/pgsql/file.748011.data...
COMMIT
Creation of indexes and PK on the File table...
SET
BEGIN
CREATE SEQUENCE
ALTER SEQUENCE
setval
------------
8269427750
(1 row)
ALTER TABLE
ANALYZE
ALTER TABLE
ALTER TABLE
ALTER TABLE
UPDATE 2
COMMIT
Upgrade of the File table succeeded. Version 1017
BEGIN
CREATE TABLE
CREATE INDEX
UPDATE 2
COMMIT
Update of Bacula PostgreSQL tables 1017 to 1018 succeeded.
UPDATE 2
Update of Bacula PostgreSQL tables 1018 to 1019 succeeded.
BEGIN
ALTER TABLE
ALTER TABLE
ALTER TABLE
UPDATE 2
COMMIT
Update of Bacula PostgreSQL tables 1019 to 1020 succeeded.
BEGIN
UPDATE 2
COMMIT
Update of Bacula PostgreSQL tables 1020 to 1021 succeeded.
BEGIN
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE TABLE
CREATE INDEX
UPDATE 2
COMMIT
Update of Bacula PostgreSQL tables 1021 to 1022 succeeded.
Best regards,
Wolfgang Denk
--
DENX Software Engineering GmbH, Managing Director: Wolfgang Denk
HRB 165235 Munich, Office: Kirchenstr.5, D-82194 Groebenzell, Germany
Phone: (+49)-8142-66989-10 Fax: (+49)-8142-66989-80 Email: w...@denx.de
What we think, or what we know, or what we believe, is in the end, of
little consequence. The only thing of consequence is what we do.
- John Ruskin
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
