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

Re: Пароль

From: "Alexander M(dot) Pravking" <fduch(at)antar(dot)bryansk(dot)ru>
To: pgsql-ru-general <pgsql-ru-general(at)postgresql(dot)org>
Subject: Re: Пароль
Date: 2005-05-05 11:08:38
Message-ID: 20050505110838.GF64261@dyatel.antar.bryansk.ru (view raw or flat)
Thread:
Lists: pgsql-ru-general
On Thu, May 05, 2005 at 02:56:48PM +0400, Oleg Bartunov wrote:
> On Thu, 5 May 2005, Viktor Vislobokov wrote:
> 
> >Кто-нибудь знает как в командной строке (или как-то
> >по-другому, неинтерактивно) задать пароль для psql?
> >Мне надо скрипт написать, который бы автоматом сам
> >пароль вводил.
> 
> несколько способов
> 1. прописать в ~/.psqlrc - не пробовал
> 2. PGPASSWORD=tvoy_password psql .....

http://www.postgresql.org/docs/8.0/static/libpq-envars.html

PGPASSWORD sets the password used if the server demands password
authentication. Use of this environment variable is not recommended for
security reasons (some operating systems allow non-root users to see
process environment variables via ps); instead consider using the
~/.pgpass file (see Section 27.12).

Собственно, вот.

-- 
Fduch M. Pravking

In response to

pgsql-ru-general by date

Next:From: Denis A. EgorovDate: 2005-05-11 08:09:30
Subject: =?koi8-r?B?7sUgydPQz8zY2tXA1NEgyc7ExcvT?==?koi8-r?B?2S4=?=
Previous:From: Viktor VislobokovDate: 2005-05-05 11:02:07
Subject: Re: Пароль в psq

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