Explore >> Select a destination
|
You are here 
|
boyter.org | ||
| | | | |
jinyuz.dev
|
|
| | | | | So, I was trying to reproduce some issues and bugs that only happened in production. I needed an exact copy of the production database and run it locally. Here's how I did it using pg_dump and pg_restore. $ pg_dump -U postgres -Fc -Z 9 -j 8 production.dump -d postgres Here's the breakdown for the arguments: U means username. It's used to connect to your postgres database. In this case, my username is postgres. | |
| | | | |
fak3r.com
|
|
| | | | | ||
| | | | |
blog.thms.uk
|
|
| | | | | Running pg_repack regularly on your Mastodon instance can stop the database from growing too large. | |
| | | | |
devremote.io
|
|
| | | PostgreSQL is a powerful, open-source object-relational database management system (ORDBMS) widely used for web, mobile, geospatial, and analytics applications. It is known for its robust features, including support for complex queries, foreign keys, and triggers, and its ability to handle large volumes of data. Docker is a containerization platform that | ||
