On 07/24/2012 09:50 PM, Larry Rosenman wrote:
> This one is concerning. Trying to restore a backup from one system to
> another, and got this:
>
> pg_restore: restoring data for table "userid"
> pg_restore: restoring data for table "values"
> pg_restore: [compress_io] could not uncompress data: (null)
> pg_restore: *** aborted because of error
> [lrosenman@bpsandbox-db2 ~]$ ls -l db*
> -rw-rw-r-- 1 lrosenman blueprint 10838183690 Jul 23 17:58
> db.backup.2012_07_21T062258
> [lrosenman@bpsandbox-db2 ~]$
>
> The file is the same size on both systems, and was transferred with scp.
>
> Any ideas why I would see this?
I just noticed you never saw any response to this.
Did you eventually find a resolution? If not, verify the checksum on the
file with md5sum on both sides. It'd also help if you'd mention the
operating system(s) / distro(s), Pg version(s), etc involved.
--
Craig Ringer