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...

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 got a little problem when I try to restore a large database (almost 32Go in custom format) on my devel database node (this node has less RAM, CPU... than my production server). My database dumps...

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...

I get the following error when running pg_restore pg_restore: error: unsupported version (1.15) in file header Versions the Docker container (running image postgres:14.10) provides root@c33fdb601e...

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 take backup using pg_dump db_production > postgres_db.dump and then I copy it to localhost using scp. Now when I import on my local db it gives an error pg_restore: [archiver] input fil...

I'm working through the Postgres DVD tutorial and am running into issues importing their sample database. Running pg_restore -U postgres -d dvdrental ~[filepath]/dvd-database.tar.gz gives me pg_re...

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 dumping a large Postgres table like this: pg_dump -h myserver -U mt_user --table=mytable -Fc -Z 9 --file mytable.dump mydb The above creates a mytable.dump file. I now want to restore this ...

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). ...

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)...

I am using pg_dump and pg_restore for backup and restore of postgres database. Here is some information from documentation that will be relevant for this question For Pg_restore, -C option is des...

I am trying to dump the database in my local system by using the command : pg_restore --host=localhost --port=5432 --dbname=dev_db --no-owner --no-privileges db_dump_new.backup but I am getting ...

I have to take backup of my database but when I right click DB and then backup The button for backup is disabled. Similarly in existing database ,not able to restore because the Restore button too ...

Postgres version : PostgreSQL 9.2.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-3), 64-bit We transfer from one server to another (with better cpu an ram) o...

i was using the following syntax for pg_dump and restore pg_dump eval --inserts -b -c --encoding UTF8 -Fc -f eval.sql.tar.gz -x -U postgres createdb -T template0 test -U postgres pg_restore -d tes...

I have two host servers s1 and s2. In both the servers I have a schema named n1. Now I have made some changes to some of the tables present in schema n1 of s1. I want the same change to be done to ...

I am trying to restore a cluster backup in PostgreSQL. I used pg_dumpall and it generated a plain text file with SQL queries. However, when I try to restore it, I get this error: pg_restore: [ar...

Ever since I got a new ARM-based M1 MacBook Pro, I've been experiencing severe and consistent PostgreSQL issues (psql 13.1). Whether I use a Rails server or Foreman, I receive errors in both my bro...

UserX has following grants: CREATE ROLE "UserX" LOGIN PASSWORD 'pass'; CREATE DATABASE "DBX" WITH OWNER="UserX" ENCODING='UTF8' TABLESPACE=pg_default CONNECTION LIMIT=-1; GRANT CONNECT ON DATABASE...

I use pg_restore on Windows 10 with a dump file made on Linux. I search on the web but I don't find answer. [NEW] : I install Ubuntu on my computer to use pg_restore but when I send pg_restor...

I am using PostgreSQL as my DB. I have SCPed a .sql file on my remote Ubuntu VM. I did sudo su - postgres and create a DB. then I switch backed to my original account and tried this: sudo -su p...

I run a daily backup of my database using pg_dump and pg_restore that recently stopped working after I pushed an update. I have a function validate_id that's a Case/When statement just as a quick c...

My question is similar to this I even vote up it, but unfortunately in my case I have text dump and I can not restore using pg_restore =( zcat /home/kes/work/projects/bennet/db/bennet.sql.gz | \ p...