PgBouncer is a lightweight connection pooler for PostgreSQL, connection pooling makes Postgres connection much faster, which is important in Web applications.

Setting up a Postgres replaication

If you to connect to PostgreSQL without typing a password, you can do it by having your password in the file “.pgpass”.

For each new project that need PostgreSQL you should create its own user and its own DB, the following are the steps need for that. Installation $ sudo aptitude install postgresql $ sudo aptitude install python-psycopg2 # For Django access Require a Password $ sudo vi /etc/postgresql/9.1/main/pg_hba.conf : #local all all peer local all all md5 : $ sudo service postgresql restart Create Postgres User $ sudo -u postgres createuser -P my_user Enter password for new role: Enter it again: Shall the new role be a superuser?