psql hanging - Mailing list pgsql-general

From David J. Trombley
Subject psql hanging
Date
Msg-id 3DBED8A5.5000406@bumba.net
Whole thread Raw
Responses Re: psql hanging  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general


    I'm running 7.2.2 on x86 linux, and trying to execute a very large
(200Mb or so) sql script by cat'ing it to psql.

    After about 2000 lines, psql hangs.

    An strace yields the following output after the process is in the
hung state:

    rt_sigprocmask(SIG_BLOCK, NULL, [], 8)  = 0
    rt_sigaction(SIGINT, {0x804d528, [], SA_RESTART|0x4000000},
{0x804d528, [], SA_RESTART|0x4000000}, 8) = 0

    over and over again.

    After I kill the process, the server doesn't need to be restarted
for a new psql instance to function; it seems just this
conenction/process is messed up.

    Any ideas?

    -dj



pgsql-general by date:

Previous
From: "Robert John Shepherd"
Date:
Subject: TSearch and phrase searches
Next
From: Kevin Old
Date:
Subject: Stream data into Postgres via Perl