Thread: trouble restoring and other bugs

trouble restoring and other bugs

From
John Fabiani
Date:
Hi,
openSUSE 12.1
pgadmin version 1.14.0(Oct 30, 2011) REl-1_14_0
Postgres 8.4

I installed pgadmin using Yast.

First I'm new to this interface and it could be that I'm doing something 
wrong.  I have used earlier version of pgadmin for years without issues. 
1. None of the messages that normally appear in dialog boxes - i.e. the 
standard message about saving passwords dialog text is completely blank after 
adding a server.

2.  I can't restore any of the backups I make (I always get an exit with error 
) Yet I don't see anything in the command from earlier versions.  The backups 
exit with a 0.  

Could someone explain the correct procedure to make a restore-able backup and 
what is required to restore the backup. 

Thanks in advance,

Johnf









Re: trouble restoring and other bugs

From
John Fabiani
Date:
On Monday, November 21, 2011 12:53:31 PM John Fabiani wrote:
> Hi,
> openSUSE 12.1
> pgadmin version 1.14.0(Oct 30, 2011) REl-1_14_0
> Postgres 8.4
> 
> I installed pgadmin using Yast.
> 
> First I'm new to this interface and it could be that I'm doing something
> wrong.  I have used earlier version of pgadmin for years without issues.
> 
> 1. None of the messages that normally appear in dialog boxes - i.e. the
> standard message about saving passwords dialog text is completely blank
> after adding a server.
> 
> 2.  I can't restore any of the backups I make (I always get an exit with
> error ) Yet I don't see anything in the command from earlier versions.  The
> backups exit with a 0.
> 
> Could someone explain the correct procedure to make a restore-able backup
> and what is required to restore the backup.
> 
> Thanks in advance,
> 
> Johnf

I have moved backwards by changing the version and all works.  I hope somebody 
will check the install from openSUSE 12.1 and determine the problem.  I don't 
know enough to really help (other than reporting here).

Johnf


Re: trouble restoring and other bugs

From
Colin Beckingham
Date:

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
-- 
---
Colin Beckingham
613-454-5369
http://www.it4gh.com


Re: trouble restoring and other bugs

From
John Fabiani
Date:
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


Re: trouble restoring and other bugs

From
Guillaume Lelarge
Date:
On Tue, 2011-11-22 at 13:18 -0800, 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.
> 

Well, I don't have the issue, either in 32bit or 64bit. I don't have
opensuse, so I guess it might be the problem. I don't have time to check
this right now, but it'll be on my (longer and longer) todo list.


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com



Re: trouble restoring and other bugs

From
Colin Beckingham
Date:

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