Top "Pg-dump" questions

pg_dump is a utility for backing up a PostgreSQL database.

A lot of "invalid command \N" when I try to restore PostgreSQL dump

I made a backup of a database on my mac and tried to restore it on a computer with ubuntu. …

postgresql dump database-restore pg-dump
Getting "Access is denied" error when executing pg_dump on Windows

I'm trying to execute pg_dump for one of my PostgreSQL databases, but I am having permission problems. C:\Windows\…

postgresql pg-dump
Postgres: Best way to move data from public schema of one DB to new schema of another DB

I am new to Postgres and just discovered that I cannot access data of different databases in one SQL query. …

database postgresql postgresql-9.3 pg-dump
pg_dump from remote server to localhost

Hi can anyone help me dump from a postgreSQL database on a remote AWS server to a postgreSQL database on …

postgresql ssh pg-dump
psql and pg_dump version mismatch

omnia@ubuntu:~$ psql --version psql (PostgreSQL) 9.3.4 omnia@ubuntu:~$ pg_dump --version pg_dump (PostgreSQL) 9.2.8 omnia@ubuntu:~$ dpkg -l | grep pg …

postgresql psql pg-dump
pg_dump & pg_restore password using python module subprocess

Problem: Use the PSQL pg_dump and pg_restore in a Python script and using the subprocess module. Background: I …

python subprocess psql pg-dump pg-restore
pg_dump on Database throwing error 'out of shared memory'

Getting problem when taking backup on database contains around 50 schema with each schema having around 100 tables. pg_dump throwing below …

postgresql postgresql-9.1 pg-dump
Postgresql - pg_dump - no matching schemas were found

I'm trying to create a backup from PostgreSQL database, but getting the following error: pg_dump: No matching schemas were …

postgresql database-schema pg-dump
PostgreSql : ERROR: relation "sequence" does not exist while restoring from dump file

I get the following error while restoring database from dump file on server: ERROR: relation "table_id_seq" does not …

postgresql postgresql-9.6 pg-dump postgresql-10
postgres backup script not as postgres user

I want to create a postgres backup script but I don't want to use the postgres user because the unix …

postgresql shell pg-dump