[pgadmin-support] SSL and Query tool crashing continued

2003-12-03 Thread timothy . r . morley

I believe this is part 3.  Anway, here are my lastest tinkerings using the Query Tool(not the Visual Query Builder) on Mandrake 9.1.  

Using the Query Tool in the 20031203 snapshot rpm for Mandrake 9.1 I still get a crash of the entire application when using the Query Tool on a connection to an SSL enabled Postgresql server.  I've tried this using the wxGTK2ud packages from 20030831 and the wxGTK2ud packages from 20031010(the .7 packages).

However, I can get the Query Tool to work just fine on an SSL connection if I build from the src snapshot from 20031203 !!  I do the build of pgadmin3 with the wxGTK2ud 20031010(.7) packages.  I have a home build of PostgreSQL 7.4 installed.  It was compiled with the --with-openssl option.  I built pgadmin3 with this command: ./configure --enable-debug --enable-static --with-wx-config=wxgtk2ud-2.5-config(Straight from the pgadmin.org website.  I can read! ).  So I'm not sure what that indicates about the problem but that is the latest on my Query Tool / SSL endeavors.

Pgadmin3 is a great tool.  Thanks for all the work you've put in on this.

Tim

Re: [pgadmin-support] SSL and Query tool crashing continued

2003-12-03 Thread Andreas Pflug
[EMAIL PROTECTED] wrote:

I believe this is part 3.  Anway, here are my lastest tinkerings using 
the Query Tool(not the Visual Query Builder) on Mandrake 9.1.  

Using the Query Tool in the 20031203 snapshot rpm for Mandrake 9.1 I 
still get a crash of the entire application when using the Query Tool 
on a connection to an SSL enabled Postgresql server.  I've tried this 
using the wxGTK2ud packages from 20030831 and the wxGTK2ud packages 
from 20031010(the .7 packages).

However, I can get the Query Tool to work just fine on an SSL 
connection if I build from the src snapshot from 20031203 !!  I do the 
build of pgadmin3 with the wxGTK2ud 20031010(.7) packages.  I have a 
home build of PostgreSQL 7.4 installed.  It was compiled with the 
--with-openssl option.  I built pgadmin3 with this command: 
./configure --enable-debug --enable-static 
--with-wx-config=wxgtk2ud-2.5-config(Straight from the pgadmin.org 
website.  I can read! ).  So I'm not sure what that indicates about 
the problem but that is the latest on my Query Tool / SSL endeavors.


Jean-Michel,

I'm wondering if you're using libpq 7.3 for packaging. This should work, 
but IMHO we should use the latest versions for all libraries. Maybe 
Timothy and  you got this worked out finally.

Pgadmin3 is a great tool.  Thanks for all the work you've put in on this.


We like it! Your appreciation is the fuel we're running on.

Regards,
Andreas


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
  http://www.postgresql.org/docs/faqs/FAQ.html


Re: [pgadmin-support] SSL and Query tool crashing continued

2003-12-03 Thread Jean-Michel POURE
Le Mercredi 03 Décembre 2003 15:35, Andreas Pflug a écrit :
> Jean-Michel,
> I'm wondering if you're using libpq 7.3 for packaging. This should work,
> but IMHO we should use the latest versions for all libraries. Maybe
> Timothy and  you got this worked out finally.

libpq3 packages are installed. Timothy compiled  PostgreSQL with a home 
install, using the --with-openssl. Mandrake also compiles PostgreSQL with 
OpenSSL. So, I do not see a solution.

Cheers, Jean-Michel


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly


[pgadmin-support] R: porting for redhat 8.0

2003-12-03 Thread Ivan Luzzi
> What specific problems are you having with the binary distribution on
> RH 8?  Where did you download the binary distribution from?  The more
> information you can provide, the easier it will be for us to help you.
> 
> ahp
> On Monday, Dec 1, 2003, at 04:38 US/Eastern, Ivan Luzzi wrote:
> 
> > I would like to ask if you could do a port of pgadmin3 on redhat 8.0
> >
> > I used it with redhat9 and found it a really great tool, then for
> > other reasons I had to switch back to redhat 8.0 and the binary you
> > distribute for rh9 don't work on rh8

I downloaded the rpm from the italian mirror of pgadmin site.
This is what I get when I try to install it:

root::/usr/src/redhat/rpms\> rpm -U pgadmin3-1.0.1-1.i386.rpm
error: Failed dependencies:
libcrypto.so.4 is needed by pgadmin3-1.0.1-1
libpthread.so.0(GLIBC_2.3.2) is needed by pgadmin3-1.0.1-1
libssl.so.4 is needed by pgadmin3-1.0.1-1


redhat9 comes with glibc.2.3 while redhat8 still uses glibc.2.2.95
I cannot upgrade glibc libs because of incompatibilities with other libs.
I also downloaded the wx rpm's and those get insalled without problems.
Then I tried to compile pgadmin but the configure procedure stops saying to
Define the pgsql dir; I declared it but it seems to ignore...
What should it find there, the whole installation included the devel rpm's?

Thanks again,
Ivan




---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


Re: [pgadmin-support] SSL and Query tool crashing continued

2003-12-03 Thread Andreas Pflug
Jean-Michel POURE wrote:

Le Mercredi 03 Décembre 2003 15:35, Andreas Pflug a écrit :
 

Jean-Michel,
I'm wondering if you're using libpq 7.3 for packaging. This should work,
but IMHO we should use the latest versions for all libraries. Maybe
Timothy and  you got this worked out finally.
   

libpq3 packages are installed.

So you're using 7.3, not 7.4?
Please verify that this problem is not related to libpq version.
Regards,
Andreas


---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings


Re: [pgadmin-support] SSL and Query tool crashing continued

2003-12-03 Thread Jean-Michel POURE
Le Mercredi 03 Décembre 2003 17:02, Andreas Pflug a écrit :
> So you're using 7.3, not 7.4?
> Please verify that this problem is not related to libpq version.

Do you mean I should install PostgreSQL 7.4 under Mandrake 9.1? This would 
break package dependencies. Or would you like a test before libpq4 is being 
compiled staticly? Can you explain more?

Cheers, Jean-Michel


---(end of broadcast)---
TIP 8: explain analyze is your friend


Re: [pgadmin-support] SSL and Query tool crashing continued

2003-12-03 Thread Dave Page
 

> -Original Message-
> From: Jean-Michel POURE [mailto:[EMAIL PROTECTED] 
> Sent: 03 December 2003 16:37
> To: Andreas Pflug
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: [pgadmin-support] SSL and Query tool crashing continued
> 
> Le Mercredi 03 Décembre 2003 17:02, Andreas Pflug a écrit :
> > So you're using 7.3, not 7.4?
> > Please verify that this problem is not related to libpq version.
> 
> Do you mean I should install PostgreSQL 7.4 under Mandrake 
> 9.1? This would break package dependencies. Or would you like 
> a test before libpq4 is being compiled staticly? Can you explain more?

Build from source in an isolated directory if you prefer. You *should* be compiling 
against libpq from 7.4 though.

Regards, Dave.

---(end of broadcast)---
TIP 8: explain analyze is your friend


[pgadmin-support] Error Message: ERROR: Relation "pg_cast" does not exist

2003-12-03 Thread info

-- System Information --

Platform: Windows 2000
Version: 5.0
Build: 2195 Service Pack 4

-- Application Information --

Name: pgAdmin II
Version: 1.6.0
Descripton: 

Name: pgSchema
Version: 1.6.0
Descripton: PostgreSQL Schema Objects v1.6.0

-- Database Information --

Version: 7.2.1
Descripton: PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.95.4

-- Driver Information --

Name: PostgreSQL
Version: 7.3.100
Descripton: PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.95.4

-- Error Information --

Description: ERROR:  Relation "pg_cast" does not exist
Number: -2147467259
Routine: pgAdmin II:frmMain.mnuFileSaveDBSchema_Click



Insert your comment:




---(end of broadcast)---
TIP 8: explain analyze is your friend


Re: [pgadmin-support] Literaturhinweise

2003-12-03 Thread Tom.Zschockelt

Hi,

sorry, ich hab den Eintrag im Adressbuch verwechselt. Ich wollte diese Mail eigentlich an [EMAIL PROTECTED] schicken.

Gruß Tom
-- Weitergeleitet von Tom Zschockelt/Penig/Flender on 04.12.2003 06:53 ---
An:        [EMAIL PROTECTED]
Kopie:         
Thema:        Re: [pgadmin-support] Literaturhinweise

[EMAIL PROTECTED] wrote:

>
> Hallo zusammen,
>
> ich habe festgestellt, dass das Buch von Peter Eistentraut 
>  (offizielles Handbuch) zwar auf der englischen Website
> als Link verfügbar ist, jedoch fehlt diese Information auf der 
> deutschen Website unter der Rubrik Literatur.
>
> Vielleicht könnte dieser Link noch eingearbeitet werden .
>
Hm, was meinst Du mit "deutsche Website"?
Diese Liste ist für pgAdmin Support, wende Dich daher bitte nicht an 
diese oder eine andere Liste, sondern den webmaster der Site die Du meinst.

Gruß,
Andreas