large object dump-restore problem(bug?)
От | Risko Peter |
---|---|
Тема | large object dump-restore problem(bug?) |
Дата | |
Msg-id | Pine.LNX.4.21.0204252237260.363-100000@pepehost.ike обсуждение исходный текст |
Ответы |
Re: large object dump-restore problem(bug?)
|
Список | pgsql-general |
Hello, I am using postgresql 7.2.1-2 on Debian (woody). Everything is fine, but it seems to me that lo dumping/restoring (or lo_import?) is buggy: -with psql I import some lo into the db: vegzes=# \lo_import /pl.sh 'alma' lo_import 16590 vegzes=# \lo_list Large objects ID | Description -------+------------- 16590 | alma (1 row) -It is okay, now I dump the db, in bash: pg_dump -o -b -u -Ft vegzes >vegzes.dump -It's okay, now I drop and recreate the db (bash): dropdb -U postgres vegzes createdb -T template0 -U postgres vegzes -It's ok., let me restore it (bash): pg_restore -v -u -d vegzes vegzes.dump User name: postgres pg_restore: connecting to database for restore Password: pg_restore: implied data-only restore pg_restore: executing <Init> Max OID pg_restore: disabling triggers pg_restore: restoring data for table BLOBS pg_restore: restoring large object OID 16590 pg_restore: connecting to database vegzes as user postgres Password: pg_restore: creating table for large object cross-references pg_restore: restored 1 large objects pg_restore: enabling triggers pg_restore: disabling triggers pg_restore: enabling triggers -It's okay, let me check the db (psql): vegzes=# \lo_list Large objects ID | Description -------+------------- 16600 | Here is my problem. The lo I restored has a new ID, and the description vanished. Is there a solution for this? thanks: Peter RISKO
В списке pgsql-general по дате отправления: