Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 5FB121337B4F for ; Tue, 11 Jan 2011 01:55:59 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 72305-04 for ; Tue, 11 Jan 2011 05:55:52 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from sam.nabble.com (sam.nabble.com [216.139.236.26]) by mail.postgresql.org (Postfix) with ESMTP id EE6CE1337B39 for ; Tue, 11 Jan 2011 01:55:51 -0400 (AST) Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.69) (envelope-from ) id 1PcXCx-0007Ax-9W for pgsql-admin@postgresql.org; Mon, 10 Jan 2011 21:55:51 -0800 Date: Mon, 10 Jan 2011 21:55:51 -0800 (PST) From: somnathzankar To: pgsql-admin@postgresql.org Message-ID: <1294725351273-3335952.post@n5.nabble.com> Subject: problem about postgresql installation and user login MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.766 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RFC_ABUSE_POST=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01, URI_HEX=1.122 X-Spam-Level: X-Archive-Number: 201101/50 X-Sequence-Number: 36490 hi sir, sorry but I'm in trouble as i don't known exactly but postgresql on a system is reset or remove. so when I'm again trying to install postgresql then follow thing happen.. $ sudo apt-get install postgresql [sudo] password for pragmaticvps: Reading package lists... Done Building dependency tree Reading state information... Done The following NEW packages will be installed: postgresql 0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded. Need to get 274kB of archives. After this operation, 344kB of additional disk space will be used. WARNING: The following packages cannot be authenticated! postgresql Authentication warning overridden. Get:1 http://debian.newdream.net lenny/main postgresql 8.3.12-0lenny1 [274kB] Fetched 274kB in 0s (4974kB/s) Selecting previously deselected package postgresql. (Reading database ... 158998 files and directories currently installed.) Unpacking postgresql (from .../postgresql_8.3.12-0lenny1_all.deb) ... Setting up postgresql (8.3.12-0lenny1) ... $ sudo su - postgres No directory, logging in with HOME=/ so when I'm trying to install postgresql then above warning got to me and it install. but when I'm trying to login by postgres user then above error it shows. I'm new on ubuntu and openerp so please help we. please tell me steps to solve above problem.. Thanking You OS----->Debian -- View this message in context: http://postgresql.1045698.n5.nabble.com/problem-about-postgresql-installation-and-user-login-tp3335952p3335952.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.