I would look at the above to see how you can use the Debian tools to maintain/create multiple Postgres clusters.
> 9.2 is uninstalled now.
You will need to install it again to be able to access the data in the 9.2 data directory you show above(/pgsql/data2). I would maintain that copy(/pgsql/data2) and just copy it into the 9.2 cluster when you get it reinstalled. If you want to upgrade to 9.3, then use the 9.3 pg_dumpall to dump the 9.2 data and then the 9.3 pg_restore to restore it into the 9.3 instance.
Thanks. BR,Ashish
I am by no means an expert on any of this, but Adrian, I think you have a typo in your instructions? Should it read:
"use the [9.2] pg_dumpall to dump the 9.2 data and then the 9.3 pg_restore to restore it into the 9.3 instance." (in the original it said [9.3] where my brackets are).
I think you meant to say that v 9.2 server binary should be used to call pg_dumpall (and run against the v9.2 running server instance), and then the resulting dump file can be read into the 9.3 server by using the v9.3 binary for pg_restore. The pg_restore (v9.3) command will operate using source files created by pg_dumpall, and load that into 9.3 running server instance.
If I'm wrong about this, please correct me. But given the context of debugging on this email thread, it seemed like I should point this (possible) typo out, so there was no ambiguity for Ashish and his team.