From holec@email.cz Sun May 31 23:44:36 2026 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WHxMm-000797-J3 for pgsql-docs@arkaria.postgresql.org; Mon, 24 Feb 2014 15:22:48 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WHxMl-0004Rq-UW for pgsql-docs@arkaria.postgresql.org; Mon, 24 Feb 2014 15:22:47 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WHxMl-0004Rj-6g for pgsql-docs@postgresql.org; Mon, 24 Feb 2014 15:22:47 +0000 Received: from smtp1.seznam.cz ([77.75.72.43]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WHxMg-0005XA-QZ for pgsql-docs@postgresql.org; Mon, 24 Feb 2014 15:22:46 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=email.cz; s=beta; t=1393255359; bh=bbJz9nuaDxr4HKbS1fvZHfFu9nI34vS3SPYQrgPPsvw=; h=Received:From:To:Subject:Date:Message-ID:MIME-Version: Content-Type:X-Mailer:Thread-Index:X-MimeOLE: Disposition-Notification-To:X-Smtpd:X-Seznam-User:X-Session: X-Country; b=l4I2uHsI6aeluzLOpIPz24w739mLEBxkqgsU+NVlT2whkFLhsmZrgVJv+qD1+hbSW uFtmtNsrAqFvKozGGn7x7R3fg8w/isuHtUkj7aLb3KUR8UwydaT4rJgLq3B0TfPfA9 YceSdFhDrIKQtP4UumtFCSA07N5lTVqMNSyxRjLg= Received: from pavel (unknown [212.158.144.203]) by email-relay3.go.seznam.cz (Seznam SMTPD UNKNOWN@UNKNOWN) with ESMTP; Mon, 24 Feb 2014 16:22:38 +0100 (CET) From: "Pavel Holec" To: Subject: pg_dump hangs Date: Mon, 24 Feb 2014 16:22:33 +0100 Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0086_01CF317C.9FA6FAE0" X-Mailer: Microsoft Office Outlook 11 Thread-Index: Ac8xdD04kmWqatVmS3G9LtetcY/s3A== X-MimeOLE: Produced By Microsoft MimeOLE V6.3.9600.16384 X-Smtpd: UNKNOWN@UNKNOWN X-Seznam-User: holec@email.cz X-Session: 13 X-Country: CZ X-Pg-Spam-Score: 0.7 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org This is a multi-part message in MIME format. ------=_NextPart_000_0086_01CF317C.9FA6FAE0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Hi All, =20 On clear Windows XP pro and clear Windows 7 pro pg_dump hangs after = creation backup file. (backup file is successfully created) Clear Win I mean after install with vc redist 2010 only. =20 Problem is in pg_dump 9.3.2. and 9.3.3 only. My testing was in Oracle VM Virtual box and erlier versions pg_dump = from 9.2 to 8.3 has no problem. =20 My tests was with cmd: SET PGPASSWORD=3D*** pg_dump.exe -i -h 192.168.0.2 -p 5432 -U backup -Fc -b -v -f file.backup = mydb =20 But tests with DB on localhost was no problem. =20 Pavel ------=_NextPart_000_0086_01CF317C.9FA6FAE0 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: quoted-printable =EF=BB=BF

Hi=20 All,

On = clear Windows XP=20 pro and clear Windows 7 pro pg_dump hangs after creation backup file. = (backup=20 file is successfully created)
Clear Win I mean after install with vc = redist=20 2010 only.

Problem is in=20 pg_dump 9.3.2. and 9.3.3 only.
My testing was in Oracle VM = Virtual box=20 and erlier versions pg_dump from 9.2 to 8.3 has no = problem.

My = tests was with=20 cmd:
SET PGPASSWORD=3D***
pg_dump.exe -i -h 192.168.0.2 -p 5432 -U = backup=20 -Fc -b -v -f file.backup mydb

But = tests with DB on=20 localhost was no problem.

Pavel

------=_NextPart_000_0086_01CF317C.9FA6FAE0-- From polobo@yahoo.com Sun May 31 23:44:36 2026 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WI2W8-0001vp-9P for pgsql-docs@arkaria.postgresql.org; Mon, 24 Feb 2014 20:52:48 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WI2W7-000591-PE for pgsql-docs@arkaria.postgresql.org; Mon, 24 Feb 2014 20:52:47 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WI2W7-00058u-6C for pgsql-docs@postgresql.org; Mon, 24 Feb 2014 20:52:47 +0000 Received: from sam.nabble.com ([216.139.236.26]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WI2W4-000867-Eb for pgsql-docs@postgresql.org; Mon, 24 Feb 2014 20:52:46 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1WI2W3-0006Q3-10 for pgsql-docs@postgresql.org; Mon, 24 Feb 2014 12:52:43 -0800 Date: Mon, 24 Feb 2014 12:52:43 -0800 (PST) From: David Johnston To: pgsql-docs@postgresql.org Message-ID: <1393275163023-5793389.post@n5.nabble.com> In-Reply-To: References: Subject: Re: pg_dump hangs MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: 1.8 (+) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org Holec wrote > Hi All, > > On clear Windows XP pro and clear Windows 7 pro pg_dump hangs after > creation backup file. (backup file is successfully created) > Clear Win I mean after install with vc redist 2010 only. > > Problem is in pg_dump 9.3.2. and 9.3.3 only. > My testing was in Oracle VM Virtual box and erlier versions pg_dump from > 9.2 to 8.3 has no problem. > > My tests was with cmd: > SET PGPASSWORD=*** > pg_dump.exe -i -h 192.168.0.2 -p 5432 -U backup -Fc -b -v -f file.backup > mydb > > But tests with DB on localhost was no problem. > > Pavel First, this should have been posted to -general or, if you really feel strongly about it, -bugs. Not sure why you thought to post it to -docs... I recommend re-posting to -general along with adding additional information. The specific information you should include would be any rows from "pg_stat_activity" that show activity; especially any that appear to belong to the pg_dump process. Depending on what activity is reported the information returned from "pg_locks" may also prove helpful. A couple of observations: "-i" is deprecated (since at least 8.4)... "-b" is only needed for selective dumps... "-v" you've turned on verbose mode - maybe include the last handful of output lines in your complaint... Given the apparent testing of different versions of PostgreSQL you should also provide the pairing of pg_dump and postgres that you are using (or confirm they are the same). David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/pg-dump-hangs-tp5793304p5793389.html Sent from the PostgreSQL - docs mailing list archive at Nabble.com. -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs