Search Postgresql Archives

Re: pg_restore error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




Using custom output format instead of tar output (-Fc instead if -Ft) appears to work without error. My initial tests with the backup db seem to match the original db.

The compressed output files are also a lot smaller ;)

Note that the problematic tar files were never transfered between platforms. They are written to a local disk and are accessed directly from that location.

Thanks for the info!
Scott


On Dec 1, 2005, at 8:02 PM, Tom Lane wrote:

Scott Frankel <leknarf@xxxxxxxxxxx> writes:
Yes, the tar file contains a file called 1765.dat.  A `cat` of that
file shows nothing more than an empty line (i.e.: a carriage return).

	-rw-------   1 frankel  prod        1 Nov 29 11:20 1765.dat

Extracting the archive, tar reported a "lone zero block."  I don't
know what this refers to.

Hmm, how big is the tarfile, and would you be willing to send it to me?

I'm happy to either help debug Ft or switch to Fc in my scripts.  I
was under the impression, though, that Ft was required to backup db's
with blobs.  I am storing some thumbnail jpg images in my db.

Either -Fc or -Ft can handle blobs ... and actually, in 8.1 the issue
is gone entirely because plain text pg_dump can too.

I'd also be interested to know if the pg_restore error is due to my
upgrade to postgres 8.1 or macosx 10.4.3.

Your guess is as good as mine at the moment. One thought that comes to
mind --- did you move the tarfile across machines at any point, and if
so could it have been munged by a Unix/DOS newline conversion?

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux