-----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

Reply via email to