Menu
Is it possible to run Postgres 8.4 AND 9 at the same time (two installations)?
Thank you
680
On local machines, it is a collection of databases that are managed by a single database server. Clusters allow us to install multiple versions of Postgresql on our macOS. To manage these clusters, we will be using a package called Postgresql Common.
Upgrading. We always recommend that all users run the latest available minor release for whatever major version is in use. Major versions usually change the internal format of system tables and data files. These changes are often complex, so we do not maintain backward compatibility of all stored data.
Postgres 11 broke backward compatibility (columns proisagg and proiswindow are dropped from pg_catalog. pg_proc) This new column more clearly identifies functions, procedures, aggregates, and window functions.
Short answer: yes
Long answer:
You didn't specify your OS, so it's difficult to say how to do it. For example in Debian/Ubuntu you can just install second version from package (postgresql-8.4 and postgresql-9.0) and everything works out of the box (thanks to postgresql-common). On other systems you probably need to do it manually using "low level" commands such initdb and pg_ctl. Make sure that second installation (database cluster) uses different port (for example 5433) and not same data directory.
82
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
