From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | "Ashish Karalkar" <ashish(dot)karalkar(at)info-spectrum(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: assigning password from script |
Date: | 2007-07-03 06:25:27 |
Message-ID: | 162867790707022325i7e0a82bbj400cb5a43554456b@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello
try
psql postgres -c "create role tom login password 'hello'"
Regards
Pavel
2007/7/3, Ashish Karalkar <ashish(dot)karalkar(at)info-spectrum(dot)com>:
> ----- Original Message ----- >
> > 2007/7/2, Ashish Karalkar <ashish(dot)karalkar(at)info-spectrum(dot)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(dot)stehule(at)gmail(dot)com>
> To: "Ashish Karalkar" <ashish(dot)karalkar(at)info-spectrum(dot)com>
> Cc: <pgsql-general(at)postgresql(dot)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....
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2007-07-03 07:08:29 | Re: Tables not created in proper schema |
Previous Message | Ashish Karalkar | 2007-07-03 06:02:02 | Re: assigning password from script |