Re: problems with pg_dumplo (was Re: backup with blobs) - Mailing list pgsql-general

From Peter Pilsl
Subject Re: problems with pg_dumplo (was Re: backup with blobs)
Date
Msg-id 20010420113712.A16365@i3.atat.at
Whole thread Raw
In response to Re: problems with pg_dumplo (was Re: backup with blobs)  (Karel Zak <zakkr@zf.jcu.cz>)
Responses Re: problems with pg_dumplo (was Re: backup with blobs)
List pgsql-general
On Fri, Apr 20, 2001 at 10:27:11AM +0200, Karel Zak wrote:

> >
> > Thanx to Tom for this great tool.
>
>  Sure :-)
>

sorry !! I ment to say, Thnx for giving this tool to me. Even more
thanx for writing this great tool to you !! :)

>
>  pg_dumplo -i (without -r) add *new* LO to DB and update LO oid in some
> tab.attr only. The option '-r' remove old LO and import new.
>
> Try:
>
>  pg_dumplo -a -d my_db -s /my_dump/dir
>  pg_dump [with relevant options for your DB] > my.dump
>  DROP DATABASE my_db;
>  CREATE DATABASE my_db;
>  psql my_db < my.dump
>  pg_dumplo -i -d my_db -s /my_dump/dir
>

when working on an own database things works perfect. However I have a
reproduceable problem on a different database when importing blobs
into a single table while the old blobs still existing (no matter if
using -r or not)

However: the problem is not happening on a new created database, so
maybe there is a problem on my system.

I will install 7.1 on a different machine and try if I can import all
my data before migrating to 7.1 on a production-server.

When I want to migrate _all_ data from one 7.1 to another 7.1 : does a
brute filecopy do it ?

Thanx a lot for your help,

peter

--
mag. peter pilsl

phone: +43 676 3574035
fax  : +43 676 3546512
email: pilsl@goldfisch.at
sms  : pilsl@max.mail.at

pgp-key available

pgsql-general by date:

Previous
From: Michaël Fiey
Date:
Subject: Database Connect
Next
From: "Richard Huxton"
Date:
Subject: Re: very slow execution of stored procedures