Skip to content

Content Tagged "database"

Page 1 of 1

Content Tagged "database"

Migrate PostgreSQL Between Two Machines

February 5, 2016Categories: IT, Tutorial
TL;DR : Once you prepare the connection, pg_dump is your friend. Recently, we had to migrate a large-ish DB (1.5 TB) from a Windows installation to a Linux one in order to accommodate a series of third party extensions. We have split the process in three: Prepare the migration Migrate users Migrate…

Postgres: Show Schema Sizes in a Database

October 2, 2014Category: Software
While loading a large database from files to a Postgres schema, I found very useful to know how much space on disk it actually occupies (just in case I need to re-size the disk). I found this answer online: Which results in a list like: ] HTH, PS: All credit goes to this StackOverflow answer !

All tags