Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VEEi7-0004EP-3N for pgsql-admin@arkaria.postgresql.org; Tue, 27 Aug 2013 08:33:11 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VEEi5-0000sO-FN for pgsql-admin@arkaria.postgresql.org; Tue, 27 Aug 2013 08:33:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VEEi4-0000sI-MH for pgsql-admin@postgresql.org; Tue, 27 Aug 2013 08:33:08 +0000 Received: from mail01.pnet.xcon.it ([62.48.53.71]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VEEhy-000632-Vc for pgsql-admin@postgresql.org; Tue, 27 Aug 2013 08:33:08 +0000 Received: from localhost (av.pnet.xcon.it [10.68.1.18]) by mail01.pnet.xcon.it (Postfix) with ESMTP id AAC5130190BE5; Tue, 27 Aug 2013 10:33:01 +0200 (CEST) X-Virus-Scanned: Debian amavisd-new at av Received: from mail01.pnet.xcon.it ([10.68.1.19]) by localhost (av.pnet.xcon.it [10.68.1.18]) (amavisd-new, port 10024) with LMTP id zr6XAcVCphrq; Tue, 27 Aug 2013 10:32:28 +0200 (CEST) Received: from bnc1.pnet.xcon.it (bnc1.pnet.xcon.it [10.68.1.23]) by mail01.pnet.xcon.it (Postfix) with ESMTP id 45F6C3014CA78; Tue, 27 Aug 2013 10:33:01 +0200 (CEST) Received: from webmail.xcon.it (unknown [62.48.53.98]) (Authenticated sender: gabriele.bartolini@2ndquadrant.it) by bnc1.pnet.xcon.it (Postfix) with ESMTPSA id 3C97E1022D8F; Tue, 27 Aug 2013 10:33:01 +0200 (CEST) Received: from eggIB-wan.comune.prato.it ([193.43.108.2]) by webmail.xcon.it with HTTP (HTTP/1.1 POST); Tue, 27 Aug 2013 10:33:01 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Date: Tue, 27 Aug 2013 10:33:01 +0200 From: Gabriele Bartolini To: prakhar jauhari Cc: Subject: Re: Does postgres user on linux need login =?UTF-8?Q?permission=3F?= In-Reply-To: References: Message-ID: X-Sender: Gabriele.Bartolini@2ndQuadrant.it User-Agent: [X]con Webmail/0.4.2 X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On Tue, 27 Aug 2013 13:28:47 +0530, prakhar jauhari wrote: > Hey, > > I am using postgres9.2, on a linux 6.3 box. > For start i created a user postgres on linux with login permission > and no password. I usually advice to set it up as a system user (see the -r option for useradd) and access to it through the "root" user using sudo/su or public SSH key authentication. Just leave it as is, with no password. Cheers, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support Gabriele.Bartolini@2ndQuadrant.it - www.2ndQuadrant.it -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin