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 DDEEA9DD7C9 for ; Fri, 13 Jan 2006 22:59:51 -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 53008-09 for ; Fri, 13 Jan 2006 22:59:55 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 603869DD7BF for ; Fri, 13 Jan 2006 22:59:49 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id k0E2xkoA007741 for ; Sat, 14 Jan 2006 02:59:46 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id k0E2cUxh005865 for pgsql-admin@postgresql.org; Fri, 13 Jan 2006 22:38:30 -0400 (AST) (envelope-from news) From: Christopher Browne X-Newsgroups: pgsql.admin Subject: Re: Unable to connect to a specific database Date: Fri, 13 Jan 2006 21:19:30 -0500 Organization: cbbrowne Computing Inc Lines: 16 Message-ID: References: <00ea01c4940d$59f54b30$ad01a8c0@zaphod> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1006 (Gnus v5.10.6) XEmacs/21.4 (Jumbo Shrimp, berkeley-unix) Cancel-Lock: sha1:BbMRo5D2Bf0E+T+MEMDHX8siUBY= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=-0.849 required=5 tests=[ALL_TRUSTED=-1.44, AWL=-0.222, INFO_TLD=0.813] X-Spam-Score: -0.849 X-Spam-Level: X-Archive-Number: 200601/169 X-Sequence-Number: 20257 > I had to kill a vacuum in the middle with -9. I shut down and > restarted the postgres server several times after that but I am unable > to connect to the db that I was initially running vacuum on > I'm doing "psql dbname" and it hangs for a while. I'm still > waiting. Any ideas? "Kill -9" is distinctly not recommended. It is possible that you have corrupted the database by issuing "kill -9." You might want to look into what backups you have... -- wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','gmail.com'). http://linuxdatabases.info/info/nonrdbms.html "Very funny, Scotty. Now beam down my clothes."