[Q] 6.3.2->6.5.1, pg_dump with large object & backend cache...
От | Chul-Su Park |
---|---|
Тема | [Q] 6.3.2->6.5.1, pg_dump with large object & backend cache... |
Дата | |
Msg-id | 19990820013342.A26893@bsunsrv1.kek.jp обсуждение исходный текст |
Список | pgsql-general |
Hello, We are using v6.3.2 with patches, and using many tables which uses 'large object'. Main problem with it is (1) cannot dump large object, is this still true in v6.5.1 ? or no plan for immplementing dumping blobs in near future? (2) if I want to clone dbs from linux to solaris machine, due to the above lo & pg_dump problem, lots of manual works needed to dump dbs -> restore to another architecture machine... Is there any utility to ease duplication(backup) of dbs? (3) to upgrade v6.3.2 dbs to v6.5.1, including large objects, is there ways to dump/restore? Another problem with v6.3.2 is frequent messages(error?) related to the backend cache invalidation failure -- probably posted many times... like this: NOTICE: SIAssignBackendId: discarding tag 2147430138 Connection databese 'request' failed. FATAL 1: Backend cache invalidation initialization failed (1) Increasing max connection # from 32 to 64 in src/include/storage/sinvaladt.h will simply fix above problem? (2) If I want to keep v6.3.2, which PATCH will FIX above problem? (3) already fixed in v6.5.1? Best Regards, C.S.Park
В списке pgsql-general по дате отправления: