- Denish Patel
- 5th June 2009
Version 8.4, Beta 1
What it Does
pg_migrator allows data stored in Postgres data files to be migrated
to a later Postgres major version without the dump/reload of data
typically required for major version upgrades, e.g. 8.3.7 -> 8.4.1.
It is not required for minor version upgrades, e.g. 8.4.1 -> 8.4.5.
Currently pg_migrator only supports upgrades from 8.3.X to 8.4.X.
pg_migrator will not work if:
o a user column is of data type tsquery
o a user column is of data type ‘name’ and is not the first column
pg_migrator will require a table rebuild if:
o a user column is of data type tsvector
pg_migrator will require a reindex if:
o an index is of type hash or gin
o an index uses bpchar_pattern_ops
All failure, rebuild, and reindex cases will be reported by pg_migrator
if they affect your installation; post-migration scripts to rebuild
tables and indexes will be automatically generated.
- Running VACUUM FULL in Non-blocking Mode
- Connection Scaling
- PSQL Helper: Managing Connections and Simplifying Queries
- Vacuum Those MVs!
- Working With Repmgr: Using Other 3rd Party Tools for Setting up a Standby
- Working with Amazon Aurora PostgreSQL: dag, standby rebooted again!
- Working with Amazon Aurora PostgreSQL: what happened to the stats?
- How to set application_name for psql command line utility?
- Is there a limit on number of partitions handled by Postgres?
- Postgres 11 partitioning