Jeremy Ashcraft <[EMAIL PROTECTED]> writes:
> in /proc
> codd 13262 # cat status {proc "filesystem"}
> Name: postmaster
> State: D (disk sleep)
> Because of the "D" state, it can't be killed as it is not interuptible
> (waiting on IO ?).
If the process is stuck in D state then it's not Po
On Fri, Feb 03, 2006 at 09:18:32AM +0700, [EMAIL PROTECTED] wrote:
> %bin/createlang plpythonu template1;
> createlang: language installation failed: ERROR: could not load library
> "/usr/local/pgsql/lib/plpython.so": dlopen
> (/usr/local/pgsql/lib/plpython.so) failed:
> /usr/local/pgsql/lib/pl
%bin/createlang plpythonu template1;
createlang: language installation failed: ERROR: could not load library
"/usr/local/pgsql/lib/plpython.so": dlopen
(/usr/local/pgsql/lib/plpython.so) failed: /usr/local/pgsql/lib/plpython.so:
Undefined symbol "pthread_create"
%
in my w2k box i use this fun
If it's not sensitive information, what does this show?
>> lsof | grep 'pid of hung process'
>>
>From my systems guy:
in /proc
codd 13262 # cat status {proc "filesystem"}
Name: postmaster
State: D (disk sleep)
Because of the "D" state, it can't be killed as it is not interuptible
(w
Ben Kim wrote:
>> We're running 7.4.9 and have run into something strange.
>> A group of processes seem to have hung and cannot be killed. netstat
>> showed that there were no active TCP connections at the time.
>> Sending SIGTERM to the parent process caused PG to begin its
>> shutdown, but it n
>We're running 7.4.9 and have run into something strange.
>A group of processes seem to have hung and cannot be killed. netstat
>showed that there were no active TCP connections at the time. Sending
>SIGTERM to the parent process caused PG to begin its shutdown, but it
>never finished. We th
Title: RE: [ADMIN] Postmaster errors
Great, thank you for the additional info.
Tim
-Original Message-
From: Michael Fuhr [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 02, 2006 1:05 PM
To: mcelroy, tim
Cc: 'pgsql-admin@postgresql.org'
Subject: Re: [ADMIN]
On Thu, Feb 02, 2006 at 12:34:44PM -0500, mcelroy, tim wrote:
> That was it, a fellow admin is watching the postmaster with OpenNMS
I think OpenNMS has a way to set up a custom poller that can do
anything you want (e.g., connect to the database, issue a query,
check the results). I was playin
Title: RE: [ADMIN] Postmaster errors
That was it, a fellow admin is watching the postmaster with OpenNMS
Thanks for the tip!
Tim
-Original Message-
From: Michael Fuhr [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 02, 2006 11:10 AM
To: mcelroy, tim
Cc: 'pgs
I forgot to include the process list:
postgres 13214 5142 0 Jan09 ?00:00:00 postgres: postgre edgate
10.1.1.3 authentication
postgres 13215 5142 0 Jan09 ?00:00:00 postgres: postgre edgate
10.1.1.1 authentication
postgres 13216 5142 0 Jan09 ?00:00:00 postgres: postg
We're running 7.4.9 and have run into something strange.
A group of processes seem to have hung and cannot be killed. netstat
showed that there were no active TCP connections at the time. Sending
SIGTERM to the parent process caused PG to begin its shutdown, but it
never finished. We then k
Brad Nicholson a écrit :
Cédric BUSCHINI wrote:
Hello,
question in 2 times :
1 - "select * from pg_stat_activity ;" gives me serverals lines but
all lines have in current_query
I have set "stats_command_string" to true...
Have you restarted the postmaster since making the change? This
Brad Nicholson <[EMAIL PROTECTED]> writes:
> Cédric BUSCHINI wrote:
>> 1 - "select * from pg_stat_activity ;" gives me serverals lines but
>> all lines have in current_query
>> I have set "stats_command_string" to true...
>>
> Have you restarted the postmaster since making the change? This sett
On Thu, Feb 02, 2006 at 10:58:52AM -0500, mcelroy, tim wrote:
> Has anyone encountered these errors? They repeat every five (5) minutes in
> my log file. Is there something I may have set incorrectly in my
> postgresql.conf file? Odd as I find them in my DEV & QA logs but not
> Production
>
Cédric BUSCHINI wrote:
Hello,
question in 2 times :
1 - "select * from pg_stat_activity ;" gives me serverals lines but
all lines have in current_query
I have set "stats_command_string" to true...
Have you restarted the postmaster since making the change? This setting
requires restart (r
Title: Postmaster errors
Good morning,
Has anyone encountered these errors? They repeat every five (5) minutes in my log file. Is there something I may have set incorrectly in my postgresql.conf file? Odd as I find them in my DEV & QA logs but not Production
2006-02-02 10:52:33 EST US
Hello,
question in 2 times :
1 - "select * from pg_stat_activity ;" gives me serverals lines but all
lines have in current_query
I have set "stats_command_string" to true...
2 - I wanna to log users activity : connections, disconnection,
queries, ... I assume there is a good way to do that
Well, according to the docs at http://www.postgresql.org/docs/8.1/interactive/plpython.htmlthe correct name would be "plpythonu".
As a matter of facts, you can do a 'select tmplname from pg_pltemplate;'to check wich languages are available.Hope it helps.Best regardsDario
On 2/2/06, [EMAIL PROTECTE
18 matches
Mail list logo
