data-integrity Archives

How to add a check constraint in Postgres without locking the table?

By adminPosted on September 30, 2022

Question : I would like to add a check constraint to a very large table. Something like: ALTER TABLE “accounts” […]

By adminPosted on September 26, 2022

Question : Let’s assume I want to store phone numbers in a database. I may accept phone numbers from outside […]

By adminPosted on September 7, 2022

Question : How can we ensure MySQL backups are consistent when they are taken as full backups as well as […]

By adminPosted on August 21, 2022

Question : I am working on a database that contains our customer information as well as information about our vendors. […]

By adminPosted on May 17, 2022

Question : Business case is. 1)Users print document on paper 2)users carry printed paper to Boss, Boss sing on paper […]

By adminPosted on March 16, 2022

Question : I’m running an application who does have a shorten version of a table in the backend database. Both […]

By adminPosted on February 14, 2022

Question : We have MySQL master and replication servers both running on different machines. We have noticed some system files […]

By adminPosted on February 10, 2022

Question : What is the use of log_bin_trust_function_creators? Also, Is the value of the parameter dynamic? Will it change if […]

By adminPosted on January 14, 2022

Question : I have a postgres 9.3 db running on ubuntu server. About a month ago we’ve had some problems […]

By adminPosted on October 2, 2021

Question : Currently I am restoring SAN snapshots to another server nightly and running weekly checkdbs on that test server. […]