----- Original Message ----- >
2007/7/2, Ashish Karalkar <ashish.karalkar@xxxxxxxxxxxxxxxxx>:
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@xxxxxxxxx>
To: "Ashish Karalkar" <ashish.karalkar@xxxxxxxxxxxxxxxxx>
Cc: <pgsql-general@xxxxxxxxxxxxxx>
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....