Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Can I run Postgres 8.4 and Postgres 9 on the same machine?

Tags:

postgresql

Is it possible to run Postgres 8.4 AND 9 at the same time (two installations)?

Thank you

like image 680
code-gijoe Avatar asked Jun 23 '11 14:06

code-gijoe

People also ask

Can I install 2 versions of PostgreSQL?

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.

Are PostgreSQL versions backwards compatible?

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.

Is PostgreSQL 11 backwards compatible?

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.

1 Answers

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.

like image 82
Grzegorz Szpetkowski Avatar answered Oct 26 '22 01:10

Grzegorz Szpetkowski
Sign in to Comment

Related questions

Connection refused with Go + Postgres on Heroku
Bug in PostgreSQL locking mechanism or misunderstanding of the mechanism
Detecting column changes in a postgres update trigger
Is there a convention for named arguments in a function in PostgreSQL
Psycopg2 query returning Decimal('value')
Query performance with concatenation and LIKE
pg_dump from remote server to localhost
Why is the Postgres C library called libpq instead of libpg?
Case-insensitive search on a postgres ArrayField with django
Django migration being killed
PostgreSQL JSONB - query condition with variable key names
PostgreSQL insert if foreign key exists
How to optimize Postgresql max_connections and node-postgres connection pool?
Postgres word_similarity not comparing words
Why can't connect to Postgresql in Win 10 64bit when build release?
Inserting data into PostgreSQL jsonb column with Daper.Net and NPGSQL
Using COUNT(*) OVER() in current query with SQLAlchemy over PostgreSQL
Postgres nested if in case query
postgresql self join
PostgreSQL sequence that ensure a unique ID

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!