Re: [ADMIN] Programmatically changing passwords

2006-08-09 Thread David Leangen
Awesome, thank you! That is exactly what I needed. Didn't know it was that simple... duh! On Aug 10, 2006, at 14:36, Thomas Pundt wrote: On Thursday 10 August 2006 07:12, David Leangen wrote: | > ALTER USER foo with encrypted password 'bar'; | > CREATE USER foo; | > CREATE DATABASE bar owne

Re: [ADMIN] Programmatically changing passwords

2006-08-09 Thread Thomas Pundt
On Thursday 10 August 2006 07:12, David Leangen wrote: | > 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 fr

Re: [ADMIN] Programmatically changing passwords

2006-08-09 Thread Tom Lane
David Leangen <[EMAIL PROTECTED]> writes: > Yes, that is my point. After having installed the standard postgresql > package, I would then install my custom-postgres-config package. In > this package, I tinker with the default configuration so I can put > postgres into a known state programmat

Re: [ADMIN] Programmatically changing passwords

2006-08-09 Thread David Leangen
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.

Re: [ADMIN] Programmatically changing passwords

2006-08-09 Thread David Leangen
Thank you. Reply below. On Aug 10, 2006, at 13:54, Tom Lane wrote: David Leangen <[EMAIL PROTECTED]> writes: 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

Re: [ADMIN] Programmatically changing passwords

2006-08-09 Thread Joshua D. Drake
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 N

Re: [ADMIN] Programmatically changing passwords

2006-08-09 Thread Tom Lane
David Leangen <[EMAIL PROTECTED]> writes: > 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 Basically, you can't. The