PostgreSQL without passwords
How to set up PostgreSQL 9.1 for local user access/tests on Ubuntu Linux
Wouldn’t it be nice if you didn’t need to type out that nasty
sudo -u postgres pqsl
and then enter a password every time you wanted to
use a local development database? Well, if you don’t mind every Tom, Dick and
Harry having a peek at your data, you can get all that “security” balderdash
out from under your feet by granting superuser access to your normal login
user. :D
-
Add the following to your
/etc/postgresql/9.1/main/pg_hba.conf
just below where is says# Put your actual configuration here
.Replace
meshy
with your login name. (If you don’t know your username you can get it by runningwhoami
in your terminal.)host all meshy 127.0.0.1/32 trust local all meshy trust local all all ident
-
Restart postgres
sudo -u postgres service postgresql restart
-
Set up postgres.
Run postgres:
sudo -u postgres psql
Create superuser and database.
create user meshy; alter role meshy with superuser; alter role meshy login; create database meshy;
-
This step is not required, and should NEVER be used in production. If you are fond of the data in any of your databases using this install of postgres Do Not Use This.
That said, if the data doesn’t matter, and your only concern is speed, this should sharply increase database creation time and speed up your tests.
Final warning: Do NOT use on machines with important data! You have been warned.
Edit
/etc/postgresql/9.1/main/postgresql.conf
with:# WARNING! This is dangerous! # These settings are likely to cause corruption across all databases. fsync = off synchronous_commit = off full_page_writes = off
-
Profit.
psql
I’m using this to run Django tests on Ubuntu 12.04 and 13.04, but I’m sure this is fit for many other purposes. Have fun, and happy hacking!