/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 www.valentinog.com
A PostgreSQL cheat sheet
| | jinyuz.dev
Using pg_dump and pg_restore to Backup and Restore PostgreSQL Database ยท / root
3.2 parsecs away

Travel
| | 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.
| | joisig.com
Stellar way to roll back PostgreSQL during development | joisig gone awol
2.3 parsecs away

Travel
| |
| | devremote.io
Setup Local Postgres Database Using Docker
1.9 parsecs away

Travel
| | 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
| | thecodinginterface.com
Migrating Large Heroku Postgres Instances to AWS Aurora without Downtime | The Coding Interface
25.5 parsecs away

Travel
| In this article I discuss a general process I used recently to migrate a large multi-terabyte Heroku Postgres Database from the Heroku Platform to Amazon Aurora Postgres on a live Heroku based application architecture with near zero downtime and builtin failover during the process.