by joonasta » Thu Dec 24, 2009 12:02 pm
That doesn't work because the db is in postgres 8.4 server, not in 8.3 server. PT3 doesn't allow me to select existing db and then change port in new database window.
I really don't understand what has happened. I have been using this db for several months and it has been working properly. The db has always been in postgres 8.4 server. I think I tried to restore the db from a backup before the error occured because I thought that I had accidently removed couple of session from the db. The restore failed and then it turned out that those sessions were still in the db. Could it be possible that the port changed during the restore? Postgres 8.3's port is 5432 and 8.4's 5433. The first one is default value for the port so it could make sense that in some certain error situation the restore process accidently changes port to default value?
However, it looks that I am not able reproduce the situation and I don't remember for sure what I did before the error occured. It may be very hard to figure out what happened in this case.