Re: Dump and restore problem

From: Stuart Luppescu <slu(at)ccsr(dot)uchicago(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Dump and restore problem
Date: 2008-06-22 01:11:01
Message-ID: 1214097061.23413.10.camel@musume.snl.home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

--
Stuart Luppescu -=- s-luppescu .at. uchicago.edu
University of Chicago (^_^)/ CCSR
才文と智奈美の父 -=-=- Kernel 2.6.23-gentoo-r
War is never imperative. -- McCoy, "Balance of
Terror", stardate 1709.2


In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martin 2008-06-22 02:22:56 Re: Dump and restore problem
Previous Message Decibel! 2008-06-21 17:52:54 Re: function question