Roland Roberts wrote: > It would appear the problem is in the backend with quoting file names. I > have some configuration files that were created via a Java webstart task. > Who cares? Well, they are arguably misconfigured 'cause they create their > config files as "c:\jobwatch.properties" which ends up in my home directory > as "/home/roland/c\:\\jobwatch.properties". That name doesn't get quoted > correctly in the SQL query that goes to PostgreSQL, so the query fails (and > I get an error in syslog from the postmaster). > > I've just unmarked those files and will see how far I can get now. It is > looking better (since it is still running).
Well, I spoke too soon. It's clear that this is not the whole story. I'm not getting any logs on the server side to help me with this. It's still quitting early, and syslog does show postgresql errors coincident with the job termination. They look like this: Nov 6 17:14:06 archos postgres[31135]: [30-1] ERROR: table "delcandidates" does not exist Nov 6 17:14:06 archos postgres[31135]: [30-2] STATEMENT: DROP TABLE DelCandidates Nov 6 17:14:06 archos postgres[31135]: [31-1] ERROR: index "delinx1" does not exist Nov 6 17:14:06 archos postgres[31135]: [31-2] STATEMENT: DROP INDEX DelInx1 Nov 6 17:14:06 archos postgres[31135]: [32-1] ERROR: index "delinx1" does not exist Nov 6 17:14:06 archos postgres[31135]: [32-2] STATEMENT: DROP INDEX DelInx1 But that may be innocuous as I also seem to get this message when I *issue* the restore command: Nov 6 17:22:09 archos postgres[31135]: [33-1] ERROR: table "temp" does not exist Nov 6 17:22:09 archos postgres[31135]: [33-2] STATEMENT: DROP TABLE temp Nov 6 17:22:09 archos postgres[31135]: [34-1] ERROR: table "temp1" does not exist Nov 6 17:22:09 archos postgres[31135]: [34-2] STATEMENT: DROP TABLE temp1 The restore seems to terminate when it gets any error like a file size not matching. This isn't what I expected from the manual where I expected it to continue on until all files were restored as best as possible. I'm now picking directories, one at a time, and restoring them. Any better ideas on tracking this down? roland -- PGP Key ID: 66 BC 3B CD Roland B. Roberts, PhD RL Enterprises [EMAIL PROTECTED] 6818 Madeline Court [EMAIL PROTECTED] Brooklyn, NY 11220 ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users