Re: Performance problem postgresql 9.5

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Performance problem postgresql 9.5
Date: 2018-06-09 13:27:56
Message-ID: b10a28a3-0a9f-589e-80b3-ac407954ad22@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Am 08.06.2018 um 22:09 schrieb Alvaro Herrera:
> 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.
>
https://www.imperva.com/blog/2018/03/deep-dive-database-attacks-scarlett-johanssons-picture-used-for-crypto-mining-on-postgre-database/

Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Debraj Manna 2018-06-09 15:51:15 Is BDR 3.0 opensourced ?
Previous Message Saeed Ahmed (DB) 2018-06-09 11:47:52 RE: pg_basebackup: could not get write-ahead log end position from server: ERROR

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-06-09 14:20:17 Re: (2^63 - 1)::bigint => out of range? (because of the double precision)
Previous Message Alexey Dokuchaev 2018-06-09 12:24:25 Re: (2^63 - 1)::bigint => out of range? (because of the double precision)