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

Re: How do create a user with a bashscript

From: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
To: A B <gentosaker(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: How do create a user with a bashscript
Date: 2008-09-23 05:29:24
Message-ID: 1222147764.3461.19.camel@laptop.gunduz.org (view raw or flat)
Thread:
Lists: pgsql-novice
On Fri, 2008-09-19 at 09:11 +0200, A B wrote:
> #!/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?

psql mydb -c "ALTER ROLE myrole WITH ENCRYPTED PASSWORD mypass"

could work, I think.
-- 
Devrim GÜNDÜZ, RHCE
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
                   http://www.gunduz.org

In response to

pgsql-novice by date

Next:From: Wright, GeorgeDate: 2008-09-24 13:14:04
Subject: query executions
Previous:From: Sean DavisDate: 2008-09-19 16:53:37
Subject: Re: Moving data from one set of tables to another?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group