Index ¦ Archives ¦ Atom > Tag: postgresql

Easier PostgreSQL Extension Installations

Postgres has a number of extensions which require superuser access for a user to install them, PostGIS being one of them. If you're wanting to install a GeoDjango app, you'll probably encounter an error such as:

$ ./ migrate
Traceback (most recent call last):
django.db.utils.ProgrammingError: permission denied …

Be careful with Django's .create_or_update()!

Although using Model.objects.create_or_update() with a Django model is extremely convenient, sometimes you might want to consider using it carefully with certain usage patterns.

Excessive Postgres WAL files

To allow point-in-time recovery (PITR), I usually setup Barman. Set it up on a remote server, get your Postgres instance to …

© Alex Tomkins.