With a fresh install of Redhat 9 and an apt-get update I am having
pg_restore hang, while it appears to be opening
/usr/lib/locale/locale-archive which is probably related to a lock or
something along those lines. Anyone have any ideas? Doing lsof on the
local-archive file resulted in 61 processes and none of them are
hanging, so other processes must be using the file.
Paul Sundling
spam<AT>tkz.net
[tkz@honesty tmp]$ strace pg_restore
[snip snip snip long strace output]
open("/usr/lib/locale/locale-archive", O_RDONLY|O_LARGEFILE) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=30301680, ...}) = 0
mmap2(NULL, 2097152, PROT_READ, MAP_PRIVATE, 3, 0) = 0x402b7000
close(3) = 0
time(NULL) = 1051178259
fstat64(0, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 0), ...}) = 0
mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1,
0) = 0x40017000
read(0, <****HANGS HERE*****>
[root@honesty lock]# rpm -qf /usr/lib/locale/locale-archive
file /usr/lib/locale/locale-archive is not owned by any package
[root@honesty lock]# ls -l /usr/lib/locale/locale-archive
-rw-r--r-- 1 root root 30301680 Apr 24 02:09
/usr/lib/locale/locale-archive
[root@honesty lock]# rpm -qa | grep postg
postgresql-test-7.3.2-3
postgresql-libs-7.3.2-3
postgresql-7.3.2-3
postgresql-docs-7.3.2-3
postgresql-odbc-7.2.5-1
postgresql-contrib-7.3.2-3
postgresql72-libs-1-3
postgresql-server-7.3.2-3
postgresql-devel-7.3.2-3
gnucash-backend-postgres-1.8.1-3
postgresql-tcl-7.3.2-3
postgresql-jdbc-7.3.2-3
postgresql-pl-7.3.2-3
postgresql-python-7.3.2-3