Postgres 9.2.4 for Windows (Vista) Dell Vostro 400, re-installation failure PLEASE CAN SOMEONE HELP!! (nearly fixed)

From: "Stephen Brearley" <mail(at)stephenbrearley(dot)name>
To: <pgsql-general(at)postgresql(dot)org>
Cc: "'Adrian Klaver'" <adrian(dot)klaver(at)gmail(dot)com>, "'Alban Hertroys'" <haramrae(at)gmail(dot)com>, "'George Weaver'" <gweaver(at)cleartagsoftware(dot)com>, "'Raymond O'Donnell'" <rod(at)iol(dot)ie>, <spam_eater(at)gmx(dot)net>
Subject: Postgres 9.2.4 for Windows (Vista) Dell Vostro 400, re-installation failure PLEASE CAN SOMEONE HELP!! (nearly fixed)
Date: 2013-08-02 09:40:52
Message-ID: 000501ce8f64$613ef2e0$23bcd8a0$@name
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Folks (hope I haven't left anyone out)

SUCCESS (ALMOST)!!

>>I've managed to re-install Postgres *without any install errors* and

>>I've managed to login *without any connection errors*

But..I'm not 100% sure how I did it and..

>>I can't access my table data

I think I got Postgres to install properly because of one or more of the
following, after performing a(nother) uninstall:

1) I set the registry Postgres data reference to point to the default
location on the C: drive

2) I made sure that I didn't have anything in the \data folder on the
D: drive, by putting my \data_old well away from my intended data location,
to avoid any 'interference' or confusion by the Postgres during installation

3) I had a problem performing step 2, because I'd just started a
reinstall when I thought (2) was a good idea, so I aborted the installation,
which resulted in a file that just would not move, and so forced me to run
chkdsk. This found the offending orphaned file, but may have fixed something
else??

4) I chose a database password during the install that did not include
any special characters

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.

>Any ideas please?

Feeling much more at home in the community -and cheered by so many of you
coming to help!

Much thanks

Stephen

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2013-08-02 09:50:37 Re: Postgres 9.2.4 for Windows (Vista) Dell Vostro 400, re-installation failure PLEASE CAN SOMEONE HELP!!
Previous Message Klaus Ita 2013-08-02 09:29:45 Re: Recovery_target_time misinterpreted?