Re: Dump and restore problem

From: David <wizzardx(at)gmail(dot)com>
To: "Stuart Luppescu" <slu(at)ccsr(dot)uchicago(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Dump and restore problem
Date: 2008-06-22 08:13:39
Message-ID: 18c1e6480806220113y42c4c46ak6b8946ea00dbfb5b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Jun 22, 2008 at 3:11 AM, Stuart Luppescu <slu(at)ccsr(dot)uchicago(dot)edu> 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 commands, and verify that the dump, restore,
>> and rsync still work correctly at each step.
>
> It looks like it's working:
> file postgresql_database-db-backup
> postgresql_database-db-backup: tar archive
>
> tar tfv postgresql_database-db-backup
> -rw------- 2048/1024 62764 2008-06-20 03:00 toc.dat
> -rw------- 2048/1024 4590795 2008-06-20 03:00 1765.dat
> -rw------- 2048/1024 391040 2008-06-20 03:00 1771.dat
> -rw------- 2048/1024 1262932 2008-06-20 03:00 1770.dat
> -rw------- 2048/1024 4472 2008-06-20 03:00 1769.dat
> -rw------- 2048/1024 5 2008-06-20 03:00 1796.dat
> -rw------- 2048/1024 5 2008-06-20 03:00 1787.dat
> -rw------- 2048/1024 5456 2008-06-20 03:00 1762.dat
> -rw------- 2048/1024 435981 2008-06-20 03:00 1767.dat
> -rw------- 2048/1024 54185 2008-06-20 03:00 1774.dat
> -rw------- 2048/1024 109 2008-06-20 03:00 1764.dat
>
> etc.
>
> This only weird thing is the ownership is weird. Where did that
> 2048/1024 come from?
>

I'm not sure about that. But if your manual process is working, then
your script should work fine too. Try adding more logging & error
checking/capturing to your mirroring scripts to check where the
problem is occurring. Debug lines like 'echo "TESTING ($LINENO) -
<Description>"' to trace which parts of the scripts get run when can
also help.

David.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Josh Tolley 2008-06-22 15:48:47 Re: postgres generates too much processes per minute
Previous Message Martin 2008-06-22 02:22:56 Re: Dump and restore problem