Just a simple script to create a user and its database easily.
Tested w/ PostgreSQL 8.4 on Mint 11 (±Ubuntu).
Be careful to use md5 in your pg_hba.conf.
sudo su postgres
mkdir ~/bin
wget <URL of the following script>sudo su postgres
sh ~/bin/create-user-and-database.shThe script will prompt for username, password and database (using username as a default value). That's it!
| #!/bin/sh | |
| read -p "Enter username: " username | |
| stty -echo | |
| read -p "Enter password: " password | |
| stty echo | |
| echo | |
| read -p "Enter database name (${username}): " database | |
| database=${database:-$username} | |
| createuser -SRD $username | |
| createdb $database | |
| echo -n "Setting user's password: " | |
| stty -echo | |
| echo "alter user ${username} with encrypted password '${password}';" | psql | |
| stty echo | |
| echo -n "Grant all privileges on database ${database}: " | |
| echo "grant all privileges on database ${database} to ${username};" | psql |