From: | "Larry Rosenman" <ler(at)lerctr(dot)org> |
---|---|
To: | "Craig Ringer" <ringerc(at)ringerc(dot)id(dot)au> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: 9.1.4: pg_restore: couldn't uncompress data? |
Date: | 2012-07-31 03:08:36 |
Message-ID: | 77e58877610ce355aa72c9944898c54f.squirrel@webmail.lerctr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)bpsandbox-db2 ~]$ ls -l db*
>> -rw-rw-r-- 1 lrosenman blueprint 10838183690 Jul 23 17:58
>> db.backup.2012_07_21T062258
>> [lrosenman(at)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(at)lerctr(dot)org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893
From | Date | Subject | |
---|---|---|---|
Next Message | Julian | 2012-07-31 06:55:02 | Re: Debian upgrade with PostgreSQL |
Previous Message | Steven Schlansker | 2012-07-31 03:04:36 | Re: Postgres will not compile on Mac 10.8 with contrib/uuid-ossp |