From: | Peter Pilsl <pilsl(at)goldfisch(dot)at> |
---|---|
To: | Karel Zak <zakkr(at)zf(dot)jcu(dot)cz> |
Cc: | postgres mailinglist <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: problems with pg_dumplo (was Re: backup with blobs) |
Date: | 2001-04-20 09:37:13 |
Message-ID: | 20010420113712.A16365@i3.atat.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)goldfisch(dot)at
sms : pilsl(at)max(dot)mail(dot)at
pgp-key available
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Elphick | 2001-04-20 10:10:56 | Re: password authentication |
Previous Message | Richard Huxton | 2001-04-20 09:26:13 | Re: very slow execution of stored procedures |