[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    Re: [BUGS] LINE COMMAND
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2010-08-16 14:59:47
Message-ID: 4649.1281970787 () sss ! pgh ! pa ! us
[Download RAW message or body]

Felipe Lopes <felipelopess@gmail.com> writes:
> I would like to run a line command (psql) with the supplied password without
> pausing the command, but this option is not available:

> psql --username=root --password=root my_bd < "script.sql"

This is intentionally not supported.  If it were supported it would be
insecure.  On most operating systems, every process in the machine can
see whatever is on the command line of every other process ... including
your password, if you were doing something like the above.

The recommended solution if you don't want to key in the password
separately is to use a .pgpass file.  See
http://www.postgresql.org/docs/8.4/static/libpq-pgpass.html

			regards, tom lane

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
[prev in list] [next in list] [prev in thread] [next in thread]