Hello, I got some problems with the update_postgresql_tables skript. The exported file-table file is headed with a triple SET line so the import failed. The reason are the three headed SET commands in the sql in front of the dump table command piped to the file. The fix for my pg13 server with adding a -q is working well.
It is allready described here and is working well still with postgresql 13 from debian 12 <https://sourceforge.net/p/bacula/mailman/message/54707411/> By the way it was not included in my fresh installed debian package so I added the -q for the dump and a second one described in the bug. The other problem was on step 1024 to 1025. Here are $$ used in do $$ ... end $$ clause. These are replaced by the schell with a pid and the step could not finished. The manual processing by copy & paste from the script to the psql console where fine. I suggest hiding $$ by the shell should do the trick. \$\$ could be used or maybe <<'END-OF-DATA' with ticks. But because I made the steps manually I did not test it. Maybe some others could find this helpfull. Cheers, Pierre _______________________________________________ Bacula-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/bacula-users
