Pgadmin - pgadmin3 1.2.2 on Debian / sarge (Was: Can't build wxWigets...)

Author

pgadmin3 1.2.2 on Debian / sarge (Was: Can't build wxWigets...)

2005-05-25, 8:24 pm

--- blacknoz@club-internet.fr wrote:
>
> However, my request for testing can be found here:
> http://www.mail-archive.com/pgadmin...g/msg05826.html
>
> Tell me if everything is ok for you.

I tried it, I'd like to give you my first impressions so far. Basically, it's
working fine, I haven't seen any issues yet though I haven't done a lot of
testing also. If anything develops, I'll let you know.

The only small issue during installation was that I have libpq4 installed and
pgadmin3 did not want to work with it. I had to install libpq3 to get it
working.

# dpkg --install pgadmin3-libwxgtk2ud2.6_2.6.0-0.1_i386.deb
pgadmin3_1.2.2-0.1_i386.deb pgadmin3-data_1.2.2-0.1_all.deb
(Reading database ... 35673 files and directories currently installed.)
Preparing to replace pgadmin3-libwxgtk2ud2.6 2.6.0-0.1 (using
pgadmin3-libwxgtk2ud2.6_2.6.0-0.1_i386.deb) ...
Unpacking replacement pgadmin3-libwxgtk2ud2.6 ...
Selecting previously deselected package pgadmin3.
Unpacking pgadmin3 (from pgadmin3_1.2.2-0.1_i386.deb) ...
Selecting previously deselected package pgadmin3-data.
Unpacking pgadmin3-data (from pgadmin3-data_1.2.2-0.1_all.deb) ...
Setting up pgadmin3-libwxgtk2ud2.6 (2.6.0-0.1) ...

dpkg: dependency problems prevent configuration of pgadmin3:
pgadmin3 depends on libpq3 (>= 7.4); however:
Package libpq3 is not installed.
dpkg: error processing pgadmin3 (--install):
dependency problems - leaving unconfigured
dpkg: dependency problems prevent configuration of pgadmin3-data:
pgadmin3-data depends on pgadmin3 (= 1.2.2-0.1); however:
Package pgadmin3 is not configured yet.
dpkg: error processing pgadmin3-data (--install):
dependency problems - leaving unconfigured
Errors were encountered while processing:
pgadmin3
pgadmin3-data

# aptitude show libpq4
Package: libpq4
New: yes
State: installed
Automatically installed: yes
Version: 8.0.3-1
Priority: optional
Section: libs
Maintainer: Martin Pitt <mpitt@debian.org>
Uncompressed Size: 419k
Depends: libc6 (>= 2.3.2.ds1-21), libkrb53 (>= 1.3.2), libssl0.9.7
Description: PostgreSQL C client library
libpq is a C library that enables user programs to communicate with the
PostgreSQL database server. The server can be on another machine and accessed
through TCP/IP. This
version of libpq is compatible with servers from PostgreSQL 8.0 or later.

This package contains the run-time library, needed by packages using libpq.

PostgreSQL is an object-relational SQL database management system.

Another small thing is (and this is just a reminder not a complaint, I know
it's on the TODO list) it would be great if there was a way to copy a row (or
even a column if it's easier to implement) into a clipboard (Ctrl+C).

Thanks for the great work.

-----------------------------------------------------------

____________________
____________________
__________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql
.org

Raphaël Enrici

2005-05-25, 8:24 pm

ow wrote:
> --- blacknoz@club-internet.fr wrote:
>
>
>
> I tried it, I'd like to give you my first impressions so far. Basically, it's
> working fine, I haven't seen any issues yet though I haven't done a lot of
> testing also. If anything develops, I'll let you know.
>
> The only small issue during installation was that I have libpq4 installed and
> pgadmin3 did not want to work with it. I had to install libpq3 to get it
> working.

Hi ow,

As far as I see you have libpq4 installed and not libpq3. Installing
libpq3 should not remove libpq4 (that's exactly why packages are named
differently ;p).
As I did not provide packages in an apt repository, you must take care
of dependencies "manually".
Can you try this method please:

dpkg -i pgadmin3-libwxgtk2ud2.6_2.6.0-0.1_i386.deb
pgadmin3_1.2.2-0.1_i386.deb pgadmin3-data_1.2.2-0.1_all.deb

then, after it fails,
apt-get -u -f install

Apt should try to resolve the dep for you and install everything required.

Thank you for testing an comments,
Raphaël

>
> # dpkg --install pgadmin3-libwxgtk2ud2.6_2.6.0-0.1_i386.deb
> pgadmin3_1.2.2-0.1_i386.deb pgadmin3-data_1.2.2-0.1_all.deb
> (Reading database ... 35673 files and directories currently installed.)
> Preparing to replace pgadmin3-libwxgtk2ud2.6 2.6.0-0.1 (using
> pgadmin3-libwxgtk2ud2.6_2.6.0-0.1_i386.deb) ...
> Unpacking replacement pgadmin3-libwxgtk2ud2.6 ...
> Selecting previously deselected package pgadmin3.
> Unpacking pgadmin3 (from pgadmin3_1.2.2-0.1_i386.deb) ...
> Selecting previously deselected package pgadmin3-data.
> Unpacking pgadmin3-data (from pgadmin3-data_1.2.2-0.1_all.deb) ...
> Setting up pgadmin3-libwxgtk2ud2.6 (2.6.0-0.1) ...
>
> dpkg: dependency problems prevent configuration of pgadmin3:
> pgadmin3 depends on libpq3 (>= 7.4); however:
> Package libpq3 is not installed.
> dpkg: error processing pgadmin3 (--install):
> dependency problems - leaving unconfigured
> dpkg: dependency problems prevent configuration of pgadmin3-data:
> pgadmin3-data depends on pgadmin3 (= 1.2.2-0.1); however:
> Package pgadmin3 is not configured yet.
> dpkg: error processing pgadmin3-data (--install):
> dependency problems - leaving unconfigured
> Errors were encountered while processing:
> pgadmin3
> pgadmin3-data
>
> # aptitude show libpq4
> Package: libpq4
> New: yes
> State: installed
> Automatically installed: yes
> Version: 8.0.3-1
> Priority: optional
> Section: libs
> Maintainer: Martin Pitt <mpitt@debian.org>
> Uncompressed Size: 419k
> Depends: libc6 (>= 2.3.2.ds1-21), libkrb53 (>= 1.3.2), libssl0.9.7
> Description: PostgreSQL C client library
> libpq is a C library that enables user programs to communicate with the
> PostgreSQL database server. The server can be on another machine and accessed
> through TCP/IP. This
> version of libpq is compatible with servers from PostgreSQL 8.0 or later.
>
> This package contains the run-time library, needed by packages using libpq.
>
> PostgreSQL is an object-relational SQL database management system.
>
> Another small thing is (and this is just a reminder not a complaint, I know
> it's on the TODO list) it would be great if there was a way to copy a row (or
> even a column if it's easier to implement) into a clipboard (Ctrl+C).
>
> Thanks for the great work.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere
" to majordomo@postgresql
.org)

Raphaël Enrici

2005-05-25, 8:24 pm

Raphaël Enrici wrote:
> ow wrote:
>

forget my first mail... I'm tired and did not read what you wrote...Sorry!

However, libpq4 is not part of Sarge, it's in experimental, that's why I
link against libpq3.

If you find any problem using it, feel free to report! :)

Regards,
Raphaël

[color=darkred]
>
>
> Hi ow,
>
> As far as I see you have libpq4 installed and not libpq3. Installing
> libpq3 should not remove libpq4 (that's exactly why packages are named
> differently ;p).
> As I did not provide packages in an apt repository, you must take care
> of dependencies "manually".
> Can you try this method please:
>
> dpkg -i pgadmin3-libwxgtk2ud2.6_2.6.0-0.1_i386.deb
> pgadmin3_1.2.2-0.1_i386.deb pgadmin3-data_1.2.2-0.1_all.deb
>
> then, after it fails,
> apt-get -u -f install
>
> Apt should try to resolve the dep for you and install everything required.
>
> Thank you for testing an comments,
> Raphaël
>
>
>
>
>

--
Raphaël Enrici blacknoz@cl
ub-internet.fr
-- ICQ: 207246758 / Jabber: blacknoz@jabber.org --
-- Use Debian GNU/Linux http://www.debian.org/ --
-- Use pgAdmin http://www.pgadmin.org/ --

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Sponsored Links