I try to backup my university project database. I followed the instruction, everything seems to be inputed: 1: 2: 3: But the only pop-out I get is this one in right-bottom corner of PGAdmin...

I have a live server and development box, call them live and dev respectively both running postgresql. I can see both and manage both with pgadmin4 without trouble, and both are fully functional th...

trying to using pg_dump to backup a postgres db i connected through the command prompt and here is my command following this tutorial http://www.postgresqltutorial.com/postgresql-backup-database/ ...

I'm trying to backup a local database in my laptop (PostGresSQL 9.6 ,PgAdmin3) and I see the following error. pg_dump: server version: 9.6.3; pg_dump version: 9.5.5 pg_dump: aborting because o...

I've used pg_dump --no-privileges --format custom --compress=0 some_database > my-dump.pgdump to dump a database, but I'm running into issues when I try to restore it. Specifically, it appears ...

I am trying to dump a Postgresql database using the pg_dump tool. $ pg_dump books > books.out How ever i am getting this error. pg_dump: server version: 9.2.1; pg_dump version: 9.1.6 pg_du...

I have tried using host variable PGPASSWORD and .pgpass and neither of these two will allow me to authenticate to the database. I have chmod'd .pgpass to appropriate permissions and also tried: ...

I'm looking for a way to get all rows as INSERT statements from one specific table within a database using pg_dump in PostgreSQL. E.g., I have table A and all rows in table A I need as INSERT stat...

I had created a DB testDb1 on a postgres server. After adding some data to this DB, I created a dump of this data and restored that to a new DB testDb2. After that data was added to second DB for q...

pg_dump version 10.3 started adding the schema name explicitly to the table name. So what used to be INSERT INTO table (id) VALUES (1); Is now INSERT INTO public.table (id) VALUES (1); How ca...

I am trying to run pg_dump (or even psql) over our postgresql server v13, with binaries from v13 and v16. Both don't work for me, but do work for my colleagues that are not on Mac, not sure if it's...

I'm trying to execute pg_dump for one of my PostgreSQL databases, but I am having permission problems. C:\Windows\system32>pg_dump -U postgres -p 1863 -O social_sense > C:\\Program Files\\Po...

I'm trying to create a backup from PostgreSQL database, but getting the following error: pg_dump: No matching schemas were found I'm logged in as root and running the command pg_dump -f db.dump ...

I have a Postgres 8.4 database on a linux server that I have dumped using the following command: pg_dump --format=c --exclude-table=log --file=/path/to/output my_db I then ftp the created file t...

I am trying to backup a db of postgresql and I want to use pg_dump command. I tried : psql -U postgres postgres-# pg_dump test > backup.sql But I don't know where the output file goes. Any he...

I'm on OSX Big Sur - 11.4 (20F71), and I really need to export a simple database out of my local set up. pg_dump is not working for me. I kept getting : zsh: command not found: pg_dump I got the ...

I am having some difficulties with restoring the schema of a table. I dumped my Heroku Postgres db and I used pg_restore to restore one table from it into my local db (it has more than 20 tables). ...

We have a postgresql database that is backed up nightly from a cron job with a following command: su postgres -c "pg_dump our_database | gzip > /home/smb/shared/database_backup.bak.gz" recent...

When trying to get local data to Heroku, I am encountering a version mismatch between two different versions of pg_dump. Specifically, I am getting this message: pg_dump: server version: 9.2.2; p...

I opened an SQL Shell (psql) and entered my information: username, port, host, database and password. Then the name of the database popped up like so Testing_Database-# Then I attempted to dump...

I'm creating an export of a postgres database (10.1) with some tables excluded. I followed the instructions in Is there a way to get pg_dump to exclude a specific sequence?. However, sequences for ...

I have a ton of postgresql dump files I need to peruse through for data. Do I have to install Postgresql and "recover" each one of them into new databases one by one? Or I'm hoping there's a postgr...

Is there a way to create a backup of a single table within a database using postgres? And how? Does this also work with the pg_dump command?

Problem: Use the PSQL pg_dump and pg_restore in a Python script and using the subprocess module. Background: I am using the following python 2.7 script from the localhost (i.e. Ubuntu 14.04.5 LTS)...

what is wrong with this command: pg_dump -U postgres -W admin --disable-triggers -a -t employees -f D:\ddd.txt postgres This is giving error of too many command-line arguments