Skip site navigation (1) Skip section navigation (2)

Re: One question about VACUUMDB command - please

From: Euler Taveira de Oliveira <euler(at)timbira(dot)com>
To: Sasa(dot)Petrovic(at)falc(dot)biz
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: One question about VACUUMDB command - please
Date: 2012-01-26 14:51:16
Message-ID: 4F216864.2000906@timbira.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On 26-01-2012 05:31, Sasa(dot)Petrovic(at)falc(dot)biz wrote:
> Why this comand that I write belove ask me for password, even I create user
> into DB with same password like user on my server that execute this command?
> 
PostgreSQL doesn't inherit authentication properties from operational system.
Instead you could use environment variables [1], pgpass.conf file [2] or even
tune pg_hba.conf [3] to not ask the password for certain host/user/database.


[1] http://www.postgresql.org/docs/current/static/libpq-envars.html
[2] http://www.postgresql.org/docs/current/static/libpq-pgpass.html
[3] http://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html


-- 
   Euler Taveira de Oliveira - Timbira       http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

In response to

pgsql-bugs by date

Next:From: Robert HaasDate: 2012-01-26 15:19:31
Subject: Re: Different error messages executing CREATE TABLE or ALTER TABLE to create a column "xmin"
Previous:From: emre.hasegeliDate: 2012-01-26 12:46:37
Subject: BUG #6411: Backend process' crash when a foreign table is used in adependent subquery on select clause

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group