Обсуждение: Performance problem postgresql 9.5

On 2018-Jun-08, Miguel Angel Sanchez Sandoval wrote:

> Hi guys, migrate from 8.4 to 9.5, all OK except that 2-3 days pass and the
> database experiences slowness, I execute the linux top command and it shows
> me a postgres user process executing a strange command (2yhdgrfrt63788)
> that I consume a lot of CPU, I see the querys active and encounter select
> fun ('./ 2yhdgrfrt63788') , this did not happen in version 8.4, any help
> would appreciate it.

Hmm, has your database been compromised?  You may have an intruder there --
beware.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

On 2018-Jun-08, Miguel Angel Sanchez Sandoval wrote:

> Hi guys, migrate from 8.4 to 9.5, all OK except that 2-3 days pass and the
> database experiences slowness, I execute the linux top command and it shows
> me a postgres user process executing a strange command (2yhdgrfrt63788)
> that I consume a lot of CPU, I see the querys active and encounter select
> fun ('./ 2yhdgrfrt63788') , this did not happen in version 8.4, any help
> would appreciate it.

Hmm, has your database been compromised?  You may have an intruder there --
beware.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

On 06/08/2018 03:56 PM, Miguel Angel Sanchez Sandoval wrote:
> I see the querys active and encounter
> select fun ('./ 2yhdgrfrt63788') 

Would it be possible (observing appropriate precautions for
a compromised server) to report here the language and definition
of any function(s) named 'fun' in that database? Effectively:

select lanname, prosrc, probin
from pg_proc join pg_language as l on l.oid = prolang
where proname = 'fun';


Regards,
-Chap

On 06/08/2018 03:56 PM, Miguel Angel Sanchez Sandoval wrote:
> I see the querys active and encounter
> select fun ('./ 2yhdgrfrt63788') 

Would it be possible (observing appropriate precautions for
a compromised server) to report here the language and definition
of any function(s) named 'fun' in that database? Effectively:

select lanname, prosrc, probin
from pg_proc join pg_language as l on l.oid = prolang
where proname = 'fun';


Regards,
-Chap