I was looking at pg_dump, but I heard it doesn't work with binary (blob) data?
pgsql-admin by date:
Соглашаюсь с условиями обработки персональных данных