Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: How do create a user with a bashscript



2008/9/19 Andreas Kretschmer <akretschmer(at)spamfence(dot)net>:
> A B <gentosaker(at)gmail(dot)com> schrieb:
>
>> Hi.
>> I want to create a user with the  createuser  command and supply the
>> password at the command line in a script, like this
>>
>> #!/bin/bash
>> createuser  myuser
>>
>> but I want to supply a password on the command line, is that possible?
>> The docs tells me no, but does anyone know of a workaround?
>
> Maybe with expect(1):
>
> NAME
>       expect - programmed dialogue with interactive programs, Version 5
>
> SYNOPSIS
>       expect [ -dDinN ] [ -c cmds ] [ [ -[f|b] ] cmdfile ] [ args ]
>
> INTRODUCTION
>       Expect  is  a program that "talks" to other interactive programs according to a script.  Following the script, Expect knows what can be expected
>       from a program and what the correct response should be.  An interpreted language provides branching and high-level control structures to  direct
>       the dialogue.  In addition, the user can take control and interact directly when desired, afterward returning control to the script.
>
>
>
> Andreas

I managed to do it by calling psql and setting the password in the
command (with -c option). Took some time to figure out that I had to
use the template1 database when connecting.



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group