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
