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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Programming PHP] [Kernel Newbies] [PHP Classes] [Find Someone Nice] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]