Re: [GENERAL] Dump and restore problem

2008-06-22 Thread David
On Sun, Jun 22, 2008 at 3:11 AM, Stuart Luppescu [EMAIL PROTECTED] wrote: On 木, 2008-06-19 at 11:57 +0200, David wrote: pg_restore: [tar archiver] could not open TOC file for input: No such file or directory It sounds like the tar file is no longer being created. Try manually running the

Re: [GENERAL] Dump and restore problem

2008-06-21 Thread Stuart Luppescu
On 木, 2008-06-19 at 11:57 +0200, David wrote: pg_restore: [tar archiver] could not open TOC file for input: No such file or directory It sounds like the tar file is no longer being created. Try manually running the commands, and verify that the dump, restore, and rsync still work

Re: [GENERAL] Dump and restore problem

2008-06-21 Thread Martin
@postgresql.org Sent: Saturday, June 21, 2008 9:11 PM Subject: Re: [GENERAL] Dump and restore problem On 木, 2008-06-19 at 11:57 +0200, David wrote: pg_restore: [tar archiver] could not open TOC file for input: No such file or directory It sounds like the tar file is no longer being created. Try manually

Re: [GENERAL] Dump and restore problem

2008-06-19 Thread David
On Wed, Jun 18, 2008 at 11:41 PM, Stuart Luppescu [EMAIL PROTECTED] wrote: [...] pg_restore: [tar archiver] could not open TOC file for input: No such file or directory It sounds like the tar file is no longer being created. Try manually running the commands, and verify that the dump,

[GENERAL] Dump and restore problem

2008-06-18 Thread Stuart Luppescu
Hello, I had a very nice system where I mirrored everything to another machine each night, so in case of disaster, I could easily switch over to the mirror. The backup script uses a line like this: pg_dump -b -F t -h $postgresql_hostname $i $location_backup_dir/`date