Skip site navigation (1) Skip section navigation (2)

Hanging with pg_restore and large objects

From: Alexander <goal81(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Hanging with pg_restore and large objects
Date: 2011-10-31 18:46:42
Message-ID: 1843207079.20111031224642@gmail.com (view raw or flat)
Thread:
Lists: 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(at)gmail(dot)com


Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2011-10-31 19:39:57
Subject: Re: BUG #6278: Index scans on '>' condition on field with many NULLS
Previous:From: Robert HaasDate: 2011-10-31 18:41:00
Subject: Re: BUG #6278: Index scans on '>' condition on field with many NULLS

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group