Re: Programmatically changing passwords

Thank you! Reply below.

On Aug 10, 2006, at 13:59, Joshua D. Drake wrote:

> David Leangen wrote:
>> Hello!
>> I am trying to build an RPM package that will put my Postgres
>> installation into a known (usable) state, without requiring any
>> interaction.
>> To this effect, I need to do the following:
>> 1. set password for superuser
>> 2. createuser user
>> 3. createdb -O user dbname
>> No problems with (3) above. But for (1) and (2), how can I set the
>> passwords programmatically, since createuser does not let me do
>> this (requires interactive prompt from user)?
>
> ALTER USER foo with encrypted password 'bar';
> CREATE USER foo;
> CREATE DATABASE bar owner foo;

That makes perfect sense, but how can I do this from the shell? Is
there an easy way to wrap these so I can send them to postgres from
the shell?

Thank you!