It must be linked to the "standard_conforming_strings" parameter: it changed with PostgreSQL 9.1.
In SQL, quotes are escaped with a second quote. Historically, MySQL and PostgreSQL both use a "C" syntax for strings. For PostgreSQL, the behaviour can be changed with the standard_conforming_strings parameter. The default value is true since 9.1. Try doing your import with standard_conforming_strings set to off/false. On 09/05/2012 09:46 PM, Michel Meyers wrote: > 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 ------------------------------------------------------------------------------ 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
