Top "Pg-dump" questions

pg_dump is a utility for backing up a PostgreSQL database.

How to restore pg_dump file into postgres database

So I regularly backup and restore databases and schema's using pgadmin4. I would like to do it with a batch …

postgresql pg-dump pg-restore
Set sslmode=allow with pg_dump

I need to specify sslmode=allow when using psql to connect to my PostgreSQL DB, like: psql sslmode=allow -h …

postgresql ssl pg-dump
Is it possible to import one database from pg_dumpall

I would like to get a database by name from a pg_dumpall and import it into my local postgres. …

postgresql pg-dump
Comparing two postgres dump files

How to compare postgres dump files? I have two dump files, dump1 and dump2 . And I want to compare these …

postgresql pg-dump
Unable to restore psql database from pg_dump with a different username

I need to dump a postgres database from computer1 with postgres username1 and then restore it on computer2 with postgres …

postgresql psql pg-dump pg-restore