-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Michael Neuendorf wrote: > Dear bacula community, > > I started to implement a bacula solution a few weeks ago and it works > pretty good. > > Now I've a little problem. I use the script from the wiki to dump my > PostgreSQL database via fifo to the file daemon. The backup seems to > work (2 GB of data was written to the tape). Then I tried to restore to > a different server, but there (surprise) was just created a fifo file. I > tried to do a pg_restore with reading from the fifo, but the director > give an error (ERR=Interrupted system call). > > Has someone a clue? Maybe a code sniplet from a restore script?
I ran into this problem today as well, so here's the answer for the archives. In order to restore from a job whose FileSet has readfifo=True [1], you need to have a program to read from the fifo that's created. I.e., simply doing: $cat /tmp/bacula-restores/path/to/fifo > /path/to/final/file.sql Should be enough. In order to restore that to pg, you'd have to use pg_restore, as the instructions on the wiki use the custom format for the dump. David Blewett 1. http://www.bacula.org/rel-manual/Configuring_Director.html#readfifo -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFHjlLWZmlc6wNjtLYRAgxHAKCFCShL25BiFwuBvlYmKZkvMkEuggCfXP+n XVDUuZdq0PNX3tefcIUvNtw= =IiVR -----END PGP SIGNATURE----- ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users