On Mon, July 30, 2012 9:14 pm, Craig Ringer wrote: > 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 > Didn't resolve it for this file. RHEL 5.4(IIRC), 64-bit, 9.1.4. I haven't had an issue with others. I'll check the sums. thanks! -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@xxxxxxxxxx US Mail: 430 Valona Loop, Round Rock, TX 78681-3893 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
