pg_dump -U [user] -d [database] -h [host] -p [port] -f [filename] -O -F tar pg_restore -O -d [database] [filename] # -O => --no-owner => cancel ownership of object to match original db # -F => --format => tar -> Output a tar-format archive suitable for input into pg_restore.