pg_dump is a utility for backing up a PostgreSQL database.
Questions tagged [pg-dump]
656 questions
0
votes
1 answer
PostgreSQL / Dumping 9.0 and reimporting in 9.2
When dumping my database 9.0 with the aim to re import it in 9.2, I have issues with schemas.
For example, my table bar in schema foo is exported like this :
SET search_path = foo, pg_catalog;
...
CREATE TABLE bar (
...
);
ALTER TABLE foo.bar…
Lionel Tressens
- 461
- 5
- 13
-1
votes
1 answer
pg_dump of postgresql pod with no terminal access as it's a prod env
So I want to take pg_dump of postgresql running on pod(openshift). I was thinking to create a cron job which would ssh into postgresql pod and run the pg_dump command. But cronjob actually created it's own pod and execute the command in it's own…
Charvee Punia
- 423
- 1
- 6
- 17
-1
votes
1 answer
How to copy a database table from one database to another
I am looking to perform some database operations programatically inside a Django application, namely, I want to:
Copy Table A in Database A over to Table A (table name preserved) in Database B, then clean-up and remove Table A.
Therefore, I have a…
Micheal J. Roberts
- 3,735
- 4
- 37
- 76
-1
votes
1 answer
Convert PostgreSQL dump to Oracle
Can we convert PostgreSQL (database and dump) to Oracle without lose information and without using another application from the Internet?
Mary Smith
- 361
- 1
- 2
- 11
-1
votes
1 answer
pg_dump does not see a table
I have three tables 'xdb.resources', 'xdb.resources_ref', 'xdb.resources_tmax'. All three belong to the same user and same schema. I try do export them using the following command
pg_dump -U xdb -t 'xdb.resources*'
Unfortunately, only two of them…
GMichael
- 2,726
- 1
- 20
- 30
-1
votes
1 answer
pg_restore cant find the input file "X" no such directory or file
first off im relatively new to pgadmin and postgresql
so i have a backup done with pgadmin in plain text which dumps the data i need from one table into a file called lodging. it came from a plans_to_lodge table from our live server. now to test a…
user1778743
- 333
- 2
- 7
- 19
-1
votes
1 answer
Program exe not making backup files on network drive when run as service
I am creating a program that runs as a service and makes database backups (using pg_dump.exe) at certain points during the day. The service runs fine normally, but fails to make backups when you try to put them in a network drive. If I stop the…
user2437443
- 2,067
- 4
- 23
- 38
-2
votes
1 answer
Move several databases from one remote database to another in PostgreSQL
I have to move several tables from one remote database to another in PostgreSQL.
From my understanding the only way of doing it is via the pg_dump.
pg_dump -h -U -d -f database_dump.sql
psql -h…
YIF99
- 51
- 1
- 8
-2
votes
1 answer
Database backup error: Postgres subprocess ....--no-owner', '--file=C:\\windows\\TEMP\\tmpf9zumbp9\\dump.sql', 'CP3') error 1
A have odoo 15 installed on Windows server 2016; everything is working very well but;
When i try to backup the database i get this error:
Database backup error: Postgres subprocess ('C:\Odoo15\PostgreSQL\bin\pg_dump.exe', '--no-owner',…
-2
votes
1 answer
postgresql, restore error, COPY failed for table "pat": ERROR: pattern_in is not implemented
Dump Commond:
pg_dump -Fc test > /home/backup/test4.sql.gz
Restore Commond:
bash-4.1$ pg_restore -d test /home/backup/test4.sql.gz
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error…
jiejia
- 1
- 2
-4
votes
2 answers
Backup of Postgresql database with pg_dump
after a search on the internet with no result, I turn to you!
I would like to create a java program, that if you click on a button, it makes a backup of a database in postgresql.
I saw that i must use pg_dump but do not understand how to make it…
Massimiliano Smillovich
- 43
- 1
- 2
- 7