Hanging with pg_restore and large objects
От | Alexander |
---|---|
Тема | Hanging with pg_restore and large objects |
Дата | |
Msg-id | 1843207079.20111031224642@gmail.com обсуждение исходный текст |
Ответы |
Re: Hanging with pg_restore and large objects
|
Список | pgsql-bugs |
Hi all. I've encountered the following problem: pg_restore hangs while restoring LOBs. The situation is as follows: 1) TARed dump, created by pg_dump 8.3.6 2) pg_restore from Postgresql 9.1.1 3) pg_restore restores schema and most of LOBs, but hangs on one of them (the same LOB every time). 'ps' shows 'R+' state for pg_restore, and GDB (attached to pg_restore) gives the following: (gdb) bt #0 0x0000003ec6ec6750 in __read_nocancel () from /lib64/libc.so.6 #1 0x0000003ec6e6cd57 in _IO_new_file_underflow () from /lib64/libc.so.6 #2 0x0000003ec6e6ba4e in _IO_file_xsgetn_internal () from /lib64/libc.so.6 #3 0x0000003ec6e61dd2 in fread () from /lib64/libc.so.6 #4 0x000000000040d0e2 in PQconnectdbParams () #5 0x000000000040d7fd in PQconnectdbParams () #6 0x000000000040e78a in PQconnectdbParams () #7 0x0000000000408035 in PQconnectdbParams () #8 0x0000000000409116 in PQconnectdbParams () #9 0x0000000000403b91 in PQconnectdbParams () #10 0x0000003ec6e1d994 in __libc_start_main () from /lib64/libc.so.6 #11 0x0000000000402f99 in PQconnectdbParams () #12 0x00007fff51ae6188 in ?? () #13 0x0000000000000000 in ?? () Does anyone know, what can be wrong? -- Ñ óâàæåíèåì, Alexander mailto:goal81@gmail.com
В списке pgsql-bugs по дате отправления: