# Main settings cdb=/tmp srv=localhost # Clear old files rm -f $cdb/*.backup # Set PostgreSQL password for access to remote DB PGPASSWORD=postgres export PGPASSWORD # Dumping DB pg_dump -h $srv -p 5432 --username postgres --format custom --blobs --verbose set > $cdb/set.backup 2> $cdb/set.log pg_dump -h $srv -p 5432 --username postgres --format custom --blobs --verbose set_operday > $cdb/set_operday.backup 2> $cdb/set_operday.log pg_dump -h $srv -p 5432 --username postgres --format custom --blobs --verbose set_loyal > $cdb/set_loyal.backup 2> $cdb/set_loyal.log