Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: pg-restore

Postgres very slow on server [closed]

By adminPosted on January 26, 2023

Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]

Restoring a backup gives “Failed exit code 1”

By adminPosted on January 20, 2023

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

By adminPosted on December 21, 2022

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

By adminPosted on October 6, 2022

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?

By adminPosted on September 27, 2022

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?

By adminPosted on September 12, 2022

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

By adminPosted on August 21, 2022

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?

By adminPosted on July 19, 2022

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

By adminPosted on July 19, 2022

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

By adminPosted on June 13, 2022

Question : Not going into details how that happened, all started with a corrupt DB. It was OK on the […]

  • 1
  • 2
  • 3
  • 4

Recent Posts

  • SQL Server Failed Login – SQL Server login (not windows) – Random times
  • Steps or evaluation order of the SQL statement
  • Can I kill these MSCRM related SQL processes?
  • Postgres to Postgres DBLink with AWS/RDS
  • What are the pros and cons of having more data-bearing members in a MongoDB replica set? [closed]
  • Transaction log backup after full backup is too big
  • Strange behavior with Quotename and substring [closed]
  • MySQL slow select from a view
  • CREATE INDEX vs ALTER TABLE ADD INDEX – MySQLism, or SQL Standard?
  • How to run my query on a one-to-many relation to run efficiently
  • Can I get SSMS to show me the Actual query costs in the Execution plan pane?
  • What are the best Database Analytics Companies for analyzing several 1000s or Mio. of products,sum them together and analyze them for statistics?
  • How to list the permissions on User-Defined Table Types?
  • Do I need an auto-generated ID in addition to a unique field?
  • Why should foreign keys be implemented in my relational database? [duplicate]
  • Difference between changed compatibility level database and new database
  • Does a query with a primary key and foreign keys run faster than a query with just primary keys?
  • What is the limit on the number of INSERT statements you can paste into SSMS and run?
  • String or separate Table
  • Database layout to keep track of the “freshness” of a column value in a specific row

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding