I'm having problems with a PostgreSQL database instance on Windows. It may be a problem with the database, or it may be a problem with the installation.
I'd like to try re-installing the same version of PostgreSQL.
I have two basic questions....
Without being able to run psql (since the database won't start) how can I determine exactly which version of PostgreSQL I'm running? I'm pretty sure it's nine point something, but would like a definitive answer. Is it written in a config file somewhere?
SOLVED - see comments below
How do I repair the installation? I know the normal upgrade path is to
- dump all tables,
- install new version,
- import old data back.
This isn't open to me because I can't actually open the database. Will a new installation be able to pick up all the existing data files without problems? The installation package from www.enterprisedb.com doesn't actually come with a repair option (not that I can spot) so I'm concerned that all my configuration information for my database may simply get overwritten.
The first problem I've encountered is that when I'm prompted for a location for my data files it objects to the fact that there are already data files in that location.
I can't believe I'm the only person ever to try a PostgreSQL repair, but I'm having trouble finding any useful links.