pgadmin / kpogre

[paulcompton]

Hi
I am fairly new to kubuntu (read: 2 weeks in...) and love it. I have been using Gentoo and the BSDs for the past few years, but I have to say Kubuntu is great. Everything just works.

BUT!!!
I do a lot of postgres work. It is my bread and butter. My favourite tool, kpogre (http://kpogre.sourceforge.net) is not available at all, and I do not yet trust myself to create a package. I tried using alien on the SuSE package but got nowhere, and I am struggling to make a tarball installation work too. Is there anybody here who feels comfortable enough to create a package of version 1.3.7 or newer? I am even prepared to sponsor it if need be!!!

As an alternative (but definitely my second choice) an update to the PGadmin3 package would be great. Versions prior to 1.4 are practically useless for serious management of Postgres 8.0 and later, and the latest version in the repositories (that I can find) is 1.2.2 . I know it would be better if I did this myself instead of moaning, but I am simply not yet up to speed enough and do not really have the time to learn the whole debian package structure just yet.

Thanks in advance for any offers of help.

Paul

[Nirvana]

Re: pgadmin / kpogre

did you alien all 3 pkgs and install all 3?

for pgadmin, try the fedora pkg:

[paulcompton]

Re: pgadmin / kpogre

did you alien all 3 pkgs and install all 3?

No, I didn't do the devel package. I'll try that now.

for pgadmin, try the fedora pkg:

You mean alien that package? I'll try that too...

Thanks a lot! I'll post an update here once I've tried both.

[paulcompton]

Re: pgadmin / kpogre

did you alien all 3 pkgs and install all 3?

Actually, I had just done a tgz-based install on kpogre, as alien complains that the rpms aren't even valid:

# alien kpogre-1.3.8-0.1.SuSE10.i686.rpm
argument is not an RPM package
argument is not an RPM package
cpio: premature end of archive
sh: line 0: cd: OLDPWD not set
chmod: invalid option -- /
Try `chmod --help' for more information.
mkdir: invalid option -- /
Try `mkdir --help' for more information.
-/debian/changelog: No such file or directory at /usr/share/perl5/Alien/Package/Deb.pm line 330.
find: invalid predicate `-'

# alien libpqxx-2.6.6-1.SuSE10.i686.rpm
argument is not an RPM package
argument is not an RPM package
cpio: premature end of archive
sh: line 0: cd: OLDPWD not set
chmod: invalid option -- /
Try `chmod --help' for more information.
mkdir: invalid option -- /
Try `mkdir --help' for more information.
-/debian/changelog: No such file or directory at /usr/share/perl5/Alien/Package/Deb.pm line 330.
find: invalid predicate `-'

# alien libpqxx-devel-2.6.6-1.SuSE10.i686.rpm
argument is not an RPM package
argument is not an RPM package
cpio: premature end of archive
sh: line 0: cd: OLDPWD not set
chmod: invalid option -- /
Try `chmod --help' for more information.
mkdir: invalid option -- /
Try `mkdir --help' for more information.
-/debian/changelog: No such file or directory at /usr/share/perl5/Alien/Package/Deb.pm line 330.
find: invalid predicate `-'

for pgadmin, try the fedora pkg:

Once I install that, I can't run it. It is looking for a different libssl library to what I have:

pgadmin3: error while loading shared libraries: libssl.so.6: cannot open shared object file: No such file or directory

Any thoughts would be greatly appreciated. For now I'm struggling through on pgadmin 1.2