Re: Dump and restore problem - Mailing list pgsql-general

From Martin
Subject Re: Dump and restore problem
Date
Msg-id BLU142-DAV73E2B723239CD5F33E521AEA70@phx.gbl
Whole thread Raw
In response to Dump and restore problem  (Stuart Luppescu <slu@ccsr.uchicago.edu>)
List pgsql-general
Most files systems allocate in 1k(1024) block(s)
If the resource requests more.. the OS FS allocates one more 1024 block
(thus the display of 2048 allocation..)

hope this makes sense,
Martin
----- Original Message -----
From: "Stuart Luppescu" <slu@ccsr.uchicago.edu>
To: <pgsql-general@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 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





--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


pgsql-general by date:

Previous
From: Stuart Luppescu
Date:
Subject: Re: Dump and restore problem
Next
From: David
Date:
Subject: Re: Dump and restore problem