X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 12F1411F6781 for ; Thu, 30 Mar 2006 12:00:47 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 04833-08 for ; Thu, 30 Mar 2006 12:00:45 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 0D65C11F6786 for ; Thu, 30 Mar 2006 12:00:45 -0400 (AST) Received: from mail.worldcycling.com (mail.worldcycling.com [209.240.82.37]) by svr4.postgresql.org (Postfix) with SMTP id 6E7FB5AF0B3 for ; Thu, 30 Mar 2006 16:00:44 +0000 (GMT) Received: from intranet.worldcycling.com ([209.240.82.46]) by mail.worldcycling.com (JAMES SMTP Server 2.2.0) with SMTP ID 49 for ; Thu, 30 Mar 2006 10:00:42 -0600 (CST) Received: from steve.worldcycling.com (localhost.localdomain [127.0.0.1]) by steve.worldcycling.com (8.12.11.20060308/8.12.11) with ESMTP id k2UG0g6n030296 for ; Thu, 30 Mar 2006 10:00:42 -0600 Received: (from linabery@localhost) by steve.worldcycling.com (8.12.11.20060308/8.12.11/Submit) id k2UG0geD030295 for pgsql-admin@postgresql.org; Thu, 30 Mar 2006 10:00:42 -0600 X-Authentication-Warning: steve.worldcycling.com: linabery set sender to slinabery@worldcycling.com using -f Date: Thu, 30 Mar 2006 10:00:42 -0600 From: Steve Linabery To: pgsql-admin@postgresql.org Subject: can't get connection during pg_dump Message-ID: <26980667.1143734442919.JavaMail.root@mail.worldcycling.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.6i Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200603/376 X-Sequence-Number: 21133 Hi, I'm running 8.1.x on FC2 with smp. The docs claim that pg_dump should allow normal operation of the db with the exception of things like 'VACUUM FULL'. Last night during backup, I noticed that I could not get a connection, either remotely via jdbc or locally via psql. Well perhaps that is inaccurate: 'ps -ef' showed several processes with a status message of "waiting to startup" (or something similar; sorry, I was late-night coding and didn't think to write it down). My installation has three databases in use. The command used to invoke the dump of one of these databases was: /usr/local/pgsql/bin/pg_dump -Fc -b mydatabasename > /back/mydatabasename.dump I looked through the docs to see if there was some runtime configuration I was missing, but saw nothing. Anyone know what I might be doing wrong? Thanks, -- Steve Linabery, sysadmin/developer B94B C3C7 8A27 FF09 3C9D E992 5A20 2492 D5F5 EE51 This electronic message transmission contains information from the sender's organization that may be proprietary, confidential and/or privileged. The information is intended only for the use of the individual(s) or entity named above. If you are not the intended recipient, be aware that any disclosure, copying or distribution or use of the contents of this information is prohibited. If you have received this electronic transmission in error, please notify the sender immediately by replying to the address listed in the "From:"