----- Original Message ----- From: Stephen Brearley
<Snip>
Having been able to successfully connect to Postgres using both Navicat and pgAdmin, I then moved my \data_old back to the \9.2 folder on the D: drive, and modified the registry reference to point to this location..however I can't see my old tables.
I can change my registry reference to point to D:\..\9.2\data or D:\..\9.2\data_old without any (apparently) undesirable consequences, but I just can't see my tables in the system, which makes me think I need to do more than this. I am unable to rename \data to move all my old files wholesale into that folder, as Windows won't let me, but if I move \base which appears to have all the database in it (and is about double the size in my old dataset), I get the same result, I can't see my tables.
I realise Thomas at least will frown most deeply at these 'operations', though they often work as a low-tech solution in many programs. Clearly the best result would be able to pg_dump from my old data and pg_restore it into my new set up, but it seems I am not able to properly see my old data in the first place.
You could try: 1. Changing the registry entry to point to the default data location on the C: drive 2. Using pg_ctl to point postgresql to D:\..\9.2\data or D:\..\9.2\data_old George <Snip> -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
