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
roland AT rlenter DOT com                            6818 Madeline Court
roland AT astrofoto DOT org                           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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users