I’ve followed these steps to migrate bacula database from mysql 5.1.49 to postgresql 8.4.9. I am running bacula 5.2.3 compiled from sources on Debian Squeeze.<\/p>\n
1- Install postgresql database:<\/p>\n
\n 2- Compile and install bacula with postgresql support:<\/p>\n \n 3- Create bacula user on postgresql:<\/p>\n \n 4- Create bacula database<\/p>\n 5- Create database tables<\/p>\n # 6- Grant privilejes on bacula database to bacula user.<\/p>\n # 7- take dump file from mysql. I’ve used this script to take the mysql dump and change some fields, like zero timestamp that does not fit with postgresql. <\/p>\n 8- Import dump file into postgresql<\/p>\n \n 9- Change the catalog definition in bacula-dir.conf from mysql to postgresql<\/p>\n Edit \/etc\/bacula-dir.conf and change driver and port<\/p>\n \n 10- Restart bacula director.<\/p>\n \n I’ve followed these steps to migrate bacula database from mysql 5.1.49 to postgresql 8.4.9. I am running bacula 5.2.3 compiled from sources on Debian Squeeze. 1- Install postgresql database: # apt-get install postgresql-8.4 postgresql-server-dev-8.4 postgresql-client-8.4 2- Compile and install bacula with postgresql support: # cd \/usr\/src\/bacula-5.2.5 # .\/configure –with-postgresql –with-openssl –with-python # make install 3- […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[146,38,10,37],"_links":{"self":[{"href":"https:\/\/elkano.org\/blog\/wp-json\/wp\/v2\/posts\/256"}],"collection":[{"href":"https:\/\/elkano.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/elkano.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/elkano.org\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/elkano.org\/blog\/wp-json\/wp\/v2\/comments?post=256"}],"version-history":[{"count":45,"href":"https:\/\/elkano.org\/blog\/wp-json\/wp\/v2\/posts\/256\/revisions"}],"predecessor-version":[{"id":1262,"href":"https:\/\/elkano.org\/blog\/wp-json\/wp\/v2\/posts\/256\/revisions\/1262"}],"wp:attachment":[{"href":"https:\/\/elkano.org\/blog\/wp-json\/wp\/v2\/media?parent=256"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/elkano.org\/blog\/wp-json\/wp\/v2\/categories?post=256"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/elkano.org\/blog\/wp-json\/wp\/v2\/tags?post=256"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n# apt-get install postgresql-8.4 postgresql-server-dev-8.4 postgresql-client-8.4
\n<\/code>\n<\/p>\n# cd \/usr\/src\/bacula-5.2.5
\n# .\/configure --with-postgresql --with-openssl --with-python
\n# make install<\/code>\n<\/p>\n# su - postgres
\n# psql -d template1 -U postgres
\ntemplate1=# CREATE USER bacula WITH PASSWORD 'myPassword';
\n<\/code>\n<\/p>\n# sh \/etc\/bacula\/create_postgresql_database<\/code><\/p>\n sh \/etc\/bacula\/make_postgresql_tables<\/code><\/p>\n sh \/etc\/bacula\/grant_postgresql_privileges<\/code><\/p>\n\r\n\r\n#!\/bin\/perl -w\r\n\r\nmy $line=undef;\r\nmy $catalog="bacula";\r\n\r\n\r\nsystem ("mysqldump --single-transaction --compatible=postgresql --compact --no-create-info $catalog > $catalog.sql");\r\nprint "$catalog dump completed!\\n";\r\n \r\nopen FD_CAT, "<$catalog.sql";\r\nopen FD_OUT, ">out-$catalog.sql";\r\nwhile (<FD_CAT>)\r\n{\r\n if (m\/^(INSERT\\s+INTO\\s+\\")(\\w+)(\\"\\s+.+)$\/){ \r\n $line=$1.lc($2).$3;\r\n $line=~s\/\\((\\d+)\\,\\'\/\\($1\\,e\\'\/g; \r\n $line=~ s\/\\\\\\'\/\\'\\'\/g;\r\n $line=~ s\/\\'0000-00-00 00:00:00\\'\/to_timestamp\\(0\\)\/g;\r\n print FD_OUT "$line\\n";\r\n }else{\r\n print "line not found: $_";\r\n } \r\n\r\n}\r\nclose (FD_CAT);\r\nclose (FD_OUT);\r\nprint "Dump filtered commpleted for $catalog\\n";\r\n\r\n\r\n<\/pre>\n# psql -d bacula -f out-bacula.sql<\/code>\n<\/p>\ndbdriver = \"dbi:postgresql\"; dbaddress = 127.0.0.1; dbport =5432<\/code>\n<\/p>\n# \/etc\/init.d\/bacula-dir restart<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"