Re: Programmatically changing passwords

[David Leangen <postgres(at)leangen(dot)net>]

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!