Question : I backed a table into a file using something like pg_dump –table=ex.tab. But when I restore the dump […]
Tag: pg-restore
Why isn’t pg_restore –create working?
Question : I backed up a database called app_data, on a 9.3 server, with this basic command: pg_dump -n public […]
reducing migration time of a large size postgresql database
Question : We have a postgresql 9.4 DB server that handles 2 DBs, each ~800GB. No replication is implemented yet. […]
Can I do a backup without extension functions?
Question : I use the PostGIS extension on my database. The thing is when I do a backup and then […]
Make a copy of database with new collation
Question : I have a small hobby project in Django backed by Cloud SQL Postgres instance. Recently I realised that […]
pg_restore: [custom archiver] could not read from input file: end of file
Question : Not going into details how that happened, all started with a corrupt DB. It was OK on the […]
pg_dump on heavily written production db causing queries to hang
Question : Trying to migrate our existing DB. There are no followers or existing backups that are available to us […]
Error using pg_restore
Question : I am using the following guide to migrate a database from my Windows 10 machine to my Managed […]
How do I copy a DB dump file to a remote computer? [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. This question does not appear to belong […]
replacing a database with pg_restore
Question : I am trying to replace an existing database with pg_restore and am running into issues. I apologize if […]