From: Rudi Starcevic <rudi@oasis.net.au>
To: pgsql-sql@postgresql.org
Subject: psql and password
Date: Thu, 28 Mar 2002 11:47:52 +1000
Message-ID: <3CA27648.7060307@oasis.net.au> (raw)
Hi,
I'm wondering how I can create a database for a user from within a script.
I have Pg in 'password' mode.
To create this database I'm trying to pass in the password from the script.
For example :
echo myPgPassword | /usr/local/pgslq/bin/createdb yourNewPgDatabase
But it's not working.
I'm still prompted for the password.
My goal is to create the database then change ownership of the database.
The user can then log straight in using phpPgAdmin.
Can you see where I'm going wrong ?
Any suggestions ?
Perhaps I need to use 'Expect' or something ( this is a Debian box )
Thanks
Kind Regards
Rudi.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rudi@oasis.net.au
Subject: Re: psql and password
In-Reply-To: <3CA27648.7060307@oasis.net.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox