/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

 zevross.com
Use PostgreSQL's 'custom format' to efficiently backup and restore tables | Technical Tidbits From Spatial Analysis & Data Sc...
| | kgrz.io
PostgreSQL backup notes
5.6 parsecs away

Travel
| |
| | minhajuddin.com
How to dump a partial/sample table(1000 rows) in postgres using pg_dump | Simplicity
6.0 parsecs away

Travel
| | The other day, I wanted to export a sample of one of my big Postgres tables from the production server to my local computer. This was a huge table and I didn't want to move around a few GBs just to ge
| | jinyuz.dev
Using pg_dump and pg_restore to Backup and Restore PostgreSQL Database ยท / root
1.6 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.
| | daenney.github.io
Arch Linux and the XPS 13 9360 - Daenney's blog
18.9 parsecs away

Travel
| I blog about what catches my fancy