[TriLUG] Help with postgresql upgrade

[Andrew Perrin]

On Mon, 3 Aug 2009, Chander Ganesan wrote:

> Andrew Perrin wrote:
>> Greetings all-
>> 
>> Running postgresql under debian, my standard apt-get upgrade upgraded me
>> from 8.3 to 8.4. As a result, I no longer have access to the databases
>> that were created under 8.3. Typically I would use pg_upgradecluster to
>> fix this problem; however, the upgrade also removed 8.3, and so I have no
>> access to these databases! Reinstalling 8.3 does not restore the
>> access, although it does appear that the raw files are still there.
>> 
>> I do have regular tape backups of the databases, but am having trouble
>> getting them to read. So I would love advice on one (or both) of the
>> following questions:
>> 
>> 1.) Is there a way to "reconnect" the 8.3 server, after reinstalling it,
>> to the raw files, so that the databases are there? I will then do a
>> pg_upgradecluster and be happy; or, alternatively, 
> Sure.  The following command should do it (make sure you stop 8.4 before 
> trying to start 8.3):
>
> [path to 8.3 pg_ctl version]/pg_ctl -D [directory of old cluster files] start
>

That did it - many thanks!

Andy


----------------------------------------------------------------------
Andrew J Perrin - andrew_perrin (at) unc.edu - http://perrin.socsci.unc.edu
Associate Professor of Sociology; Book Review Editor, _Social Forces_
University of North Carolina - CB#3210, Chapel Hill, NC 27599-3210 USA