Django dbbackup - Postgresql .psql.bin file format?

Question

I have been installing and using django-dbbackup extension today (https://github.com/jazzband/django-dbbackup).

I use the S3 Storage option.

When i run a 'dbbackup', i obtain a file in format 'filename-2022-08-26-171845.psql.bin'.

Is there a way to uncompress/read inside this '.psql.bin' file format ?

I would like to access the query that have been backup, like i would do with a '.sql' file.

Thanks for your explanation.

averta · Accepted Answer · 2022-08-28 10:24:36Z

3

Found my answer.

There is two connectors existing for PostgreSQL in django-dbbackup :

If you want to use the non-binary, you need to specify connector mapping in your settings :

> DBBACKUP_CONNECTOR_MAPPING = {  
> 'django.db.backends.postgresql_psycopg2':'dbbackup.db.postgresql.PgDumpConnector',
> }

answered Aug 28, 2022 at 10:24

averta

915 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Anybody finding this in 2025 should know that for Django 4.2.7 it's 'django.db.backends.postgresql':'dbbackup.db.postgresql.PgDumpConnector'.