I am running Ubuntu 14.04 with a postgres/postgis setup and in a weak moment removed PostgreSQL 9.1 (seemingly a legacy install from 12.04 from before I upgraded to 14.04), having erroneously convinced myself my current postgis setup relied on 9.3 alone.
That was not the case, and to make matters worse, I removed it while the instance was running, so I headed to the repositories to restore 9.1.
The repositories for Ubuntu don't have PostgreSQL 9.1 for 14.04, so I instead compiled from source so I could run pg_dump or pg_upgrade, which requires binaries from both.
But my issue then was that just because I now had a working version of 9.1 again, that didn't make my databases from earlier visible.
So, as far as I am aware, my database files are intact, but I need to 'hook' them up with the new 9.1 service I installed today. I hope it is trivial, but it has stumped me for hours. Any pointers for where to start with updating the config?
pg_ctl
to the right data directory, e.g.pg_ctl -D /path/to/database/file start
. – a_horse_with_no_name Mar 30 '15 at 6:10pg_wrapper
to manage Pg -pg_ctlcluster
,pg_createcluster
, etc. For hand-compiled it's like any other Pg. – Craig Ringer Mar 30 '15 at 8:38postgresql-9.1
in my output ofapt-cache search postgresql
... – dezso Mar 30 '15 at 11:19