Re: trouble restoring and other bugs

On 11/22/2011 04:18 PM, John Fabiani wrote:
> On Tuesday, November 22, 2011 11:57:38 AM Colin Beckingham wrote:
>> On 11/22/2011 11:26 AM, John Fabiani wrote:
>>>> FWIW I tried upgrading to 12.1 OpenSUSE and had the nasty surprise
>>>> that
>>>> the upgrade took me from my Postgresql 9.0 to 9.1. From 9.1 I could
>>>> not
>>>> access my old data files from the previous 9.0. Fortunately I had a
>>>> backup and was secure in the knowledge I had not lost data. In the end
>>>> there were so many issues with 12.1 that I decided to go back to 11.4.
>>>> Is is possible that you were using a different upgraded server
>>>> version?
>>>
>>> I did a complete fresh install of 12.1 64 bit on a new computer. I am
>>> having some issues. Kmail is not working as well as in the past,
>>> pgadmin will not allow me to backup and restore. But mostly I'm OK.
>>>
>>> I'd like better info on how to use the new interface of pgadmin 1.14
>>> because I can't be sure I'm doing it correctly. That said - I still
>>> believe there is something wrong because of the lack the standard
>>> messages appearing.
>>>
>>> Johnf
>>
>> If you have a new install then you are using 9.1 postgresql since that
>> is what was on my 12.1 64 bit iso.
>>
>> I installed using Gnome with no KDE so I can't comment on what happens
>> in KDE. I'm sure that dbus was broken in my upgrade, could not get
>> pulseaudio to work correctly, and several other things so went back to
>> 11.4. I did not get the chance to see if pgadmin worked in 12.1 since it
>> refused to do anything once it found I had a 9.0 data backend.
>>
>> If pgamin looks strange then might be better off using a standard backup
>> restore procedure:
>>
>> http://www.postgresql.org/docs/9.1/static/backup.html
>
> I did not install postgres on the workstation. So I'm connecting to an 8.4
> install on a server.
>
> I did attempt to use the CLI also without success.
>
> I'm sure there is something wrong with the install of pgadmin because 1.14 has
> been out for sometime at this point. It might be something to do with the
> 64bit issue - but that's a guess.
>
> Johnf
>

Ah, I understand better now, thanks.

I'm sure you have checked this already, but if the CLI to psql also
fails, does this not indicate an issue with the server, and not
necessarily pgadmin since pgadmin is not involved in this case?

FWIW My 1.14 pgadmin on OpenSUSE 11.4 works fine (with a few minor
issues already noted) on local and remote servers. Backup and restore is ok.

--
---
Colin Beckingham
613-454-5369
http://www.it4gh.com