Hello, I'm in the middle of doing a test conversion of my home Bacula setup to Postgres and noticed an issue with the conversion instructions:
http://www.bacula.org/5.2.x-manuals/en/main/main/Installing_Configuring_Post.html#SECTION004950000000000000000 For some reason, they do not tackle the quotes in the filename table right. (The MySQL dump contains the quotes escaped as \', but Postgres chokes on that. It appears to want them quoted as ''.) I'm no PSQL expert (just started using it today) so I'm not quite sure how to correctly work around this. I used the sed command from this post, but it still didn't clean up all the blobs correctly: http://stackoverflow.com/questions/2831009/migrate-from-mysql-to-postgresql-on-linux-kubuntu Maybe somebody with more PSQL knowledge could have a go at it. Versions used by me: Bacula 5.2.10 MySQL 5.1.53-0+squeeze1 (Debian package) postgresql 9.1 (Debian package) - Michel ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Bacula-devel mailing list Bacula-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-devel
