assigning password from script

On 7/2/07, Ashish Karalkar <ashish.karalkar@info-spectrum.com> wrote:

Hello All,

I want to create a user through script and dont want user to assign
password
interactively, I want it to be assigned through some file or anything
else

some this like

createuser -P ***** OR createuser -P <file >

Is there any way?

What scripting language are you using?

in bash you can do something like:

pwd=`cat /home/pgsql/password`

to get it.

Hello All,

I want to create a user through script and dont want user to assign password
interactively, I want it to be assigned through some file or anything else

some this like

createuser -P ***** OR createuser -P <file >

Is there any way?

Thanks in Advance

With Regards
Ashish...

----- Original Message ----- >

2007/7/2, Ashish Karalkar <ashish.karalkar@info-spectrum.com>:

Hello All,

I want to create a user through script and dont want user to assign
password
interactively, I want it to be assigned through some file or anything
else

some this like

createuser -P ***** OR createuser -P <file >

Is there any way?

From: "Pavel Stehule" <pavel.stehule@gmail.com>
To: "Ashish Karalkar" <ashish.karalkar@info-spectrum.com>
Cc: <pgsql-general@postgresql.org>
Sent: Monday, July 02, 2007 11:24 AM
Subject: Re: [GENERAL] assigning password from script

Hello

look on http://www.postgresql.org/docs/8.0/interactive/libpq-pgpass.html

Pavel Stehule

Thanks Pavel Stehule for your replay,

As far as I understand the guide lines talk about providing the password
from .pgpass whene ever server requires it and not to assign the password to
the user.

" The file .pgpass in a user's home directory or the file referenced by
PGPASSFILE can contain passwords to be used if the connection requires a
password"

Please correct me if I am wrong and if I understood correctly then Please
suggest me the way to assign password to user while its creation from a
file/ or anything else than prompting for password from terminal

With Regards
Ashish....