Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
Tag: pg-restore
Restoring a backup gives “Failed exit code 1”
Question : I’m migrating from Heroku’s Postgres to AWS RDS. I’ve generated a pg_backup.dump file from Heroku, installed Postgres on […]
pg_restore: error: could not execute query: ERROR: materialized view “ws1_all_formate” has not been populated
Question : I had this error after the execution of pg_restore: pg_restore: finished item 19181 MATERIALIZED VIEW DATA avenant_f pg_restore: […]
OpenProject pg_restore – input file does not appear to be a valid archive
Question : I’m trying to restore my OpenProject’s database created with the command sudo openproject run backup this command created […]
how to automatically create the associated schema when I `pg_restore` a table?
Question : I backed a table into a file using something like pg_dump –table=ex.tab. But when I restore the dump […]
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 […]