Re: [GENERAL] Idle processes chewing up CPU?

2009-09-20 Thread Brendan Hill
Hi Craig, I've debugged the runaway process, though I'm not sure of the solution yet. My best interpretation is that an SSL client dirty disconnected while running a request. This caused an infinite loop in pq_recvbuf(), calling secure_read(), triggering my_sock_read() over and over. Calling

Re: [GENERAL] Idle processes chewing up CPU?

2009-09-20 Thread Tom Lane
Brendan Hill brend...@jims.net writes: My best interpretation is that an SSL client dirty disconnected while running a request. This caused an infinite loop in pq_recvbuf(), calling secure_read(), triggering my_sock_read() over and over. Calling SSL_get_error() in secure_read() returns 10045

Re: [GENERAL] MD5 sum mismatch in source rpm

2009-09-20 Thread Devrim GÜNDÜZ
On Fri, 2009-09-18 at 22:38 -0300, Clodoaldo Neto wrote: Although I have already built some srpms I was just following recipes and I never really tried to understand what I was doing so it is probably my mistake. This time I was trying to install the f11 srpm (the only one I found in the

[GENERAL] How to get variable out to shell script

2009-09-20 Thread Alex Gadea
I am using psql to call an external sql file that executes a simple select count(*): ie: select into ct count(*) from table; I can't figure out how to make the ct variable available to the shell script once the external sql file completes execution. What I am trying to do is run the count

Re: [GENERAL] How to get variable out to shell script

2009-09-20 Thread Scott Marlowe
On Sun, Sep 20, 2009 at 3:49 PM, Alex Gadea alex.ga...@apptik.com wrote: I am using psql to call an external sql file that executes a simple select count(*): ie: select into ct count(*) from table; I can't figure out how to make the ct variable available to the shell script once the

Re: [GENERAL] How to get variable out to shell script

2009-09-20 Thread Devrim GÜNDÜZ
On Sun, 2009-09-20 at 16:49 -0500, Alex Gadea wrote: I am using psql to call an external sql file that executes a simple select count(*): ie: select into ct count(*) from table; I can't figure out how to make the ct variable available to the shell script once the external sql file

Re: [GENERAL] How to get variable out to shell script

2009-09-20 Thread Sam Mason
On Sun, Sep 20, 2009 at 04:49:03PM -0500, Alex Gadea wrote: ie: select into ct count(*) from table; I can't figure out how to make the ct variable available to the shell script once the external sql file completes execution. Just tell psql not to output any surrounding stuff and then just

Re: [GENERAL] How to get variable out to shell script

2009-09-20 Thread Alex Gadea
Yes, I'd like to do it via Perl, but I don't have control over the server and the admins who do may balk at the idea of loading the necessary db modules. This will work though. Thanks! Alex - Original Message - From: Sam Mason s...@samason.me.uk To: pgsql-general@postgresql.org Sent:

Re: [GENERAL] How to get variable out to shell script

2009-09-20 Thread Scott Marlowe
On Sun, Sep 20, 2009 at 4:42 PM, Alex Gadea alex.ga...@apptik.com wrote: Yes, I'd like to do it via Perl, but I don't have control over the server and the admins who do may balk at the idea of loading the necessary db modules. Was in the same position as you. Only language allowed on our

Re: [GENERAL] How to get variable out to shell script

2009-09-20 Thread Brent Wood
On Sun, 2009-09-20 at 16:49 -0500, Alex Gadea wrote: I am using psql to call an external sql file that executes a simple select count(*): ie: select into ct count(*) from table; I can't figure out how to make the ct variable available to the shell script once the external sql file

Re: [GENERAL] How can I make a two arch libpq for snow leopard?

2009-09-20 Thread Scott Ribe
The only thing that comes to mind is two separate build trees, one 32bit and the other 64bit and then somehow gluing the two libpqs together... Basically, probably the easiest way to proceed--man lipo to figure out how to combine the libraries. -- Scott Ribe scott_r...@killerbytes.com

Re: [GENERAL] How to get variable out to shell script

2009-09-20 Thread Abel Camarillo
On Sun, Sep 20, 2009 at 04:49:03PM -0500, Alex Gadea wrote: I am using psql to call an external sql file that executes a simple select count(*): ie: select into ct count(*) from table; I can't figure out how to make the ct variable available to the shell script once the external sql

Re: [GENERAL] How can I make a two arch libpq for snow leopard?

2009-09-20 Thread Jerry LeVan
On Sep 20, 2009, at 7:47 PM, Scott Ribe wrote: The only thing that comes to mind is two separate build trees, one 32bit and the other 64bit and then somehow gluing the two libpqs together... Basically, probably the easiest way to proceed--man lipo to figure out how to combine the

Re: [GENERAL] Substitutes for some Oracle packages

2009-09-20 Thread abhishekgautam009
Hi, You may also go for EnterpriseDB product(PPAS) which has oracle compatibility on postgres database. Abhi