Issues with pg_dump & pg_restore

From: "Lane Rollins" <laner(at)boyds(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Issues with pg_dump & pg_restore
Date: 2001-11-26 23:25:50
Message-ID: 000801c176d1$af498d00$4103000a@viao
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I'm trying to make a copy of a production database that's running on a
RedHat 7.0 machines with posgresql 7.1.2 and moving it to a machine
running RedHat 7.1 with postgresql 7.1.3. The database has blobs so I
first tried

pg_dump -Ft -b docarc >docarc.tar

That failed with

Archiver(tar) could not write to member (18 != 85)

I then tried replacing -Ft with -Fc and that solved the problem. On the
machine I'm try restoring the database to my test machine with

createdb docarc
pg_restore -v -Fc -d docarc docarc.cust

It runs find until the "Create table for BLOBS xrefs" then it slowly
starts eating up all available memory. It eventually gets killed due to
no more memory. The system has 512Mb of memory + 128Mb of swap. The data
base has about 500,000 entries in one table with about a 3k blob for
each entry, the other table has about 1,000,000 rows.

Thanks,
Lane Rollins

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David Stanaway 2001-11-26 23:38:44 Re: windoze accesse to pg backend
Previous Message Tom Lane 2001-11-26 22:39:30 Re: installing 7.2b3 on IRIX 6.5.13