Outer Web | Explore

/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		jinyuz.dev Using pg_dump and pg_restore to Backup and Restore PostgreSQL Database · / root
\|	\|	stribny.name Backup and restore PostgreSQL databases with Ansible [AI summary] The article provides a step-by-step guide on automating PostgreSQL database backups and restores using Ansible playbooks and modules.	2.1 parsecs Travel
\|	\|
\|	\|	minhajuddin.com How to dump a partial/sample table(1000 rows) in postgres using pg_dump \| Simplicity 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	2.5 parsecs Travel
\|	\|
\|	\|	zevross.com Use PostgreSQL's 'custom format' to efficiently backup and restore tables \| Technical Tidbits From Spatial Analysis & Data Sc... PostgreSQL allows you to easily dump tables for backup purposes into plain text files using code such as: pg_dump mytable > mytable_backup.sql But this process is not very flexible and can creat...	1.6 parsecs Travel
\|	\|
\|	\|	thecodinginterface.com Migrating Large Heroku Postgres Instances to AWS Aurora without Downtime \| The Coding Interface 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.	25.4 parsecs Travel
\|