Re: [pgadmin-support] pgagent + faikure + Bug

2010-01-04 Thread Guillaume Lelarge
Le 04/01/2010 22:11, Florent THOMAS a écrit : > Hy folks, > > First I foud a bug. > While I edit a jod and try to modify a step or a schedule from this > window, pgadmin crashed as I validate. > Which pgAdmin release? if 1.10.0, you should upgrade to 1.10.1. Some bugs are fixed wrt pgagent dialo

Re: [pgadmin-support] PgAdmin Crash

2010-01-04 Thread Guillaume Lelarge
Le 04/01/2010 21:20, Franz Fritsche a écrit : > Local installation: > Windows 2000 Professional > PgAdmin III: V. 1.10.1 > PostgreSQL: 8.4.2 > > ~~~ > > Starting PgAdmin with doublecklicking an icon, target: > > C:\Programme\PostgreSQL\8.4\bin\pgAdmin3.exe /s "PostgreSQL 8.4"

[pgadmin-support] pgagent + faikure + Bug

2010-01-04 Thread Florent THOMAS
Hy folks, First I foud a bug. While I edit a jod and try to modify a step or a schedule from this window, pgadmin crashed as I validate. Then I have a probleme with the syntax of the steps. I created a function that is called each night : fn_myfunction (returns void) When I exexute select fn_myfu

[pgadmin-support] PgAdmin Crash

2010-01-04 Thread Franz Fritsche
Local installation: Windows 2000 Professional PgAdmin III: V. 1.10.1 PostgreSQL: 8.4.2 ~~~ Starting PgAdmin with doublecklicking an icon, target: C:\Programme\PostgreSQL\8.4\bin\pgAdmin3.exe /s "PostgreSQL 8.4" /q This way PgAdmin auto connects to my database and opens a Que

[pgadmin-support] pgagent, problem with running the jobs in FreeBSD

2010-01-04 Thread Sergey Stepanov
Hi! I have a problem running tasks in the scheduler pgagent (from the package pgAdmin 1.8.4) on a server running FreeBSD 7.2. Tasks run scripts in the shell interpreter bash. If you run two tasks with the scheduler, then one task starts, and the other not. After a run for the first task will be

[pgadmin-support] Bug: PgAdmin not displaying typmod column types correctly in create or display

2010-01-04 Thread Obe, Regina
I assume this is a PgAdmin III bug, but I could be wrong. I'm using PgAdmin 1.10.1 on Windows, but seems to be an issue with even 1.8 since I tried on that too. The upcoming PostGIS 1.5 has a new type called geography that uses the Typmod functionality introduced in 8.3. I'm guessing this is a

Re: [pgadmin-support] pgagent 3.0.1

2010-01-04 Thread Ashesh Vashi
*mkdir ~/temp cd ~/temp ln -s libssl.so.0* ... (And, for all the missing libraries) *LD_LIBRARY_PATH=$HOME/temp:$LD_LIBRARY_PATH export LD_LIBRARY_PATH* And now, try to run the pgagent. Hope this helps.. (NOTE: This is just work around. You may not like to do the same on your production server o

Re: [pgadmin-support] pgagent 3.0.1

2010-01-04 Thread Florent THOMAS
so how to tell to pgagent to choose libssl.so.0.9.8 instead of libssl.so.0? How can I do it during the compiling? Or where can I find the appropriate librarie Le lundi 04 janvier 2010 à 16:51 +0530, Ashesh Vashi a écrit : > In fact, it is not. > > > On Mon, Jan 4, 2010 at 4:23 PM, Florent THOM

Re: [pgadmin-support] pgagent 3.0.1

2010-01-04 Thread Ashesh Vashi
In fact, it is not. On Mon, Jan 4, 2010 at 4:23 PM, Florent THOMAS wrote: > Maybe that could come from this error : > > > CMake Error at cmake/FindWX.cmake:271 (MESSAGE): >The selected wxWidgets configuration (version: 2.8, debug: no, static: > yes, >unicode: yes, modules: base) is not

Re: [pgadmin-support] pgagent 3.0.1

2010-01-04 Thread Florent THOMAS
Maybe that could come from this error : CMake Error at cmake/FindWX.cmake:271 (MESSAGE): The selected wxWidgets configuration (version: 2.8, debug: no, static: yes, unicode: yes, modules: base) is not available. Call Stack (most recent call first): CMakeLists.txt:91 (FIND_PACKAGE) Mayb

Re: [pgadmin-support] pgagent 3.0.1

2010-01-04 Thread Florent THOMAS
Unfortunately, it was already installed!! Le lundi 04 janvier 2010 à 15:08 +0530, Ashesh Vashi a écrit : > Hi, > > Please install openssl on your system, it should resolve the issue. > > -- > Ashesh Vashi > EnterpriseDB INDIA - Enterprise Postgres Company > > On Mon, Jan 4, 2010 at 3:05 PM,

Re: [pgadmin-support] pgagent 3.0.1

2010-01-04 Thread Ashesh Vashi
Hi, Please install openssl on your system, it should resolve the issue. -- Ashesh Vashi EnterpriseDB INDIA - Enterprise Postgres Company On Mon, Jan 4, 2010 at 3:05 PM, Florent THOMAS wrote: > Thanks for the info. > > I ran this command > ldd -v /usr/bin/pgagent >

Re: [pgadmin-support] pgagent 3.0.1

2010-01-04 Thread Florent THOMAS
Thanks for the info. I ran this command ldd -v /usr/bin/pgagent linux-gate.so.1 => (0xe000) libssl.so.0 => not found libcrypto.so.0 => not found libcrypt.so.1 => /lib/libcrypt.so.1 (0xb776b000) libz.so.1 => /lib/libz.so.1 (0xb7757000) libdl.s

Re: [pgadmin-support] pgagent 3.0.1

2010-01-04 Thread Ashesh Vashi
The actual problem is - there're some libraries are not available on your system or not in ldconfig. You can use 'ldd' utility of linux to check the dependent libraries of an executable/library. On Mon, Jan 4, 2010 at 2:46 PM, Florent THOMAS wrote: > Actually, > > I retried to install the pgag

Re: [pgadmin-support] pgagent 3.0.1

2010-01-04 Thread Florent THOMAS
Actually, I retried to install the pgagent and I have this problem in config : CMake Error at cmake/FindWX.cmake:271 (MESSAGE): The selected wxWidgets configuration (version: 2.8, debug: no, static: yes, unicode: yes, modules: base) is not available. Call Stack (most recent call first):

Re: [pgadmin-support] pgagent 3.0.1

2010-01-04 Thread Ashesh Vashi
How did you install pgagent? -- Ashesh Vashi EnterpriseDB INDIA - Enterprise Postgres Company On Mon, Jan 4, 2010 at 1:59 PM, Florent THOMAS wrote: > Hello everybody, > > I wish you an appear new year. > I run on mandriva 2009.0 and I hav a problem with the install

[pgadmin-support] pgagent 3.0.1

2010-01-04 Thread Florent THOMAS
Hello everybody, I wish you an appear new year. I run on mandriva 2009.0 and I hav a problem with the installation. I installed pgagent by compiling and as I try to run the agent I have this message : "/usr/bin/pgagent: error while loading shared libraries: libssl.so.0: cannot open shared object