On 07/31/2013 04:28 AM, Stephen Brearley wrote:
Hi Thomas **Thanks for getting back to me** I would not normally do anything in the Registry, as I am aware that is asking for trouble. However, I hadn’t noted that I could specify a data location on my original install, so I checked the web and this appeared to be the only way to do this for some programs. I edited PostgreSQL|Installations|postgresql-9.2|Data Directory and changed the default from the C: drive to my folder on the D: drive as D:\_SDB\Database\RDBMS\PostgreSQL\9.2\data. This worked fine until I had the password problems I mentioned above, and tried to do a reinstall, so I don’t think this registry edit is causing the problem.
Actually, per Albans comment it is. The installer is seeing the data directory on D:\. Might try undoing that registry entry.
The basic problem is you have two instances of a Postgres cluster(one on C:\ and one on D:\) and one instance of Postgres running with confusing information on where to find the appropriate cluster(the registry entry, the recent install information). To make head way on this you need to unclutter things. Before we go down that path, how important is the data in the database you initially created?
-- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
