CODEWITHSUNDEEP
postgresql
BrainLikeADullPencil
BrainLikeADullPencil

Reputation: 11653

Installing an older version of postgres to run pg_dump

I have a data directory on my system installed by an older version of Postgres (9.1) that is incompatible with 9.2. After I ran these commands..

which psql /usr/local/bin/psql

which postgres /usr/local/bin/postgres

I was told that my packaging system might not support multiple installs and the simplest solution for me is to install 9.1 again run pg_dump

Therefore, I uninstalled 9.2.3, after which running

'which postgres' returned nothing and 'which psql' returns /usr/bin/psql

I read on SO that I could find version directories by running brew search postgres, which would maybe give me a response like 

postgresql
homebrew/versions/postgresql8    homebrew/versions/postgresql9

However, I didn't get a version directory. I got this brew search postgres postgres-xc postgresql

Can anyone tell me how I might install the older version of postgres and get rid of the data directory created by 9.1

Upvotes: 0

Views: 1085

Answers (1)

BrainLikeADullPencil
BrainLikeADullPencil

Reputation: 11653

I found it very complicated to get the various versions of Postgresql installed in order to run pg_dump. Therefore, I removed every trace of 9.1. and 9.2 from my system after which I reinstalled 9.2. Now it's working.

Upvotes: 1

Related Questions