Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pC6ER-0004wM-2H for pgsql-general@arkaria.postgresql.org; Sun, 01 Jan 2023 21:51:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pC6EP-000074-UV for pgsql-general@arkaria.postgresql.org; Sun, 01 Jan 2023 21:51:01 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pC6EP-00006q-GU for pgsql-general@lists.postgresql.org; Sun, 01 Jan 2023 21:51:01 +0000 Received: from mail-pj1-x1035.google.com ([2607:f8b0:4864:20::1035]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pC6EN-0007Px-AT for pgsql-general@lists.postgresql.org; Sun, 01 Jan 2023 21:51:01 +0000 Received: by mail-pj1-x1035.google.com with SMTP id m7-20020a17090a730700b00225ebb9cd01so19283206pjk.3 for ; Sun, 01 Jan 2023 13:50:58 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=KoCBT3vfAETYKZMCnq+mgHoaeEHCIxEIz+LcYtqYYvc=; b=C5Zvw1MoKOorExGbCkRT+xEpvhrIWSJLWvBG9h9nO2TfgvqO4hoZzMlmou0eHGk1f5 mRx+vw3CitLHgpJhFYrXtMHupKKTcLMtFXKRI21KygTkx0qATz5lj03KqQjxHpAcIw4m dFOPVxcox2orORJhZU8BSyfrKh+HgqiS537v3qixmBbfz4c+vV/kUnWGlm4FnF5YJb/i rRmTjnp3uvi9BPK6mIcQF5s63ae1CPcVymkMknlyhMYu62G7HEt/THsWLq8gTlAcb0Na dZSJfsuS2cs+eZ4JsPUw0MweWxJ5tBdcJwgGwK2c8RjkgQi6vqm0XvUm6jXwfhJun4Ap 6Zhw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=KoCBT3vfAETYKZMCnq+mgHoaeEHCIxEIz+LcYtqYYvc=; b=igibOXdzZCJv4Y8+Fno0OX9m1ioB8f1bWzpBh8/YQ/0r818ifceSg5owfDGoHv67g7 7nbjGTQzSYIxTyzgkqejiMmJoRUSdrTRGvY3JHzAV4LWu2WDcP16cwHlNjLNKQy6eKfv 7eAdc+MuBUnILTfsy/QY/Ld4iMbHwaP81hGuiug8Mu4ZwzcM5faWL2qt1933d6eAj/nG A73CWhe+PYXWzbFZwpF+JwORsfWGKum+qCXBP+0Wtz0qNCJWRvhxaUbCRUHY3HWzvcHZ m847CeHvOK7ZcNs9HOs7eNof5HA3YuyqkqxOZpGvivgGcGDag+4bd7PW+NPYvrv/pvmg aQyQ== X-Gm-Message-State: AFqh2kriDCRgAXWZu5qal65EUP97SvejvdgEo0hte8on49UfhetaPlnh pjR8Me1L8K1R6QYmbve12w7MR4LeigA= X-Google-Smtp-Source: AMrXdXv4hSRmAzb41XvPM2sfH2qr+0JA1hjIeckb0pl0ajoHoLKvsSoJ9ELt/my/KVusCo7SDcsRrQ== X-Received: by 2002:a17:903:2481:b0:189:d0b4:52d0 with SMTP id p1-20020a170903248100b00189d0b452d0mr41867146plw.46.1672609855925; Sun, 01 Jan 2023 13:50:55 -0800 (PST) Received: from ?IPV6:2601:681:5a00:f790:afd3:4baf:793b:db8d? ([2601:681:5a00:f790:afd3:4baf:793b:db8d]) by smtp.gmail.com with ESMTPSA id a10-20020a1709027e4a00b0018913417ba2sm16094653pln.130.2023.01.01.13.50.55 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sun, 01 Jan 2023 13:50:55 -0800 (PST) Content-Type: multipart/alternative; boundary="------------hrJY9iii0Mz9ByXLlduTRtBj" Message-ID: <45f03cf0-b93f-f7e2-617c-6381c80ebe2f@gmail.com> Date: Sun, 1 Jan 2023 14:50:54 -0700 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.4.2 Subject: Re: PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours Content-Language: en-CA To: pgsql-general@lists.postgresql.org References: <25d1ff9d-62dd-3124-d6f6-55615ed90d85@aklaver.com> <5cff562f-abf7-b191-c4f6-24409715309e@aklaver.com> From: Rob Sargent In-Reply-To: <5cff562f-abf7-b191-c4f6-24409715309e@aklaver.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------hrJY9iii0Mz9ByXLlduTRtBj Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 1/1/23 14:48, Adrian Klaver wrote: > On 1/1/23 13:11, Antonis Christodoulou wrote: >> Hello Adrian, >> >> No it’s not open, but the database itself has very simple credentials >> (I am just starting with PostgreSQL). What’s weird about the logs? > > Not the logs the ps output. I would expect to see something like: > > ps -ef | grep postgres > postgres  395382       1  0  2022 ?        00:03:31 > /usr/lib/postgresql/14/bin/postgres -D /var/lib/postgresql/14/main -c > config_file=/etc/postgresql/14/main/postgresql.conf > postgres  395384  395382  0  2022 ?        00:00:01 postgres: 14/main: > checkpointer > postgres  395385  395382  0  2022 ?        00:00:26 postgres: 14/main: > background writer > postgres  395386  395382  0  2022 ?        00:00:26 postgres: 14/main: > walwriter > postgres  395387  395382  0  2022 ?        00:01:45 postgres: 14/main: > autovacuum launcher > postgres  395388  395382  0  2022 ?        00:00:05 postgres: 14/main: > archiver last was 0000000100000003000000B9.00000028.backup > postgres  395389  395382  0  2022 ?        00:01:37 postgres: 14/main: > stats collector > postgres  395390  395382  0  2022 ?        00:02:24 postgres: 14/main: > pg_cron launcher > postgres  395391  395382  0  2022 ?        00:00:01 postgres: 14/main: > logical replication launcher > > This: > > postgres 3342383       1  0  2022 ?        00:00:00 FzXlkULu > postgres 3344758       1 99  2022 ?        3-14:39:11 OElid7Dp > postgres 3419125       1 18 13:57 ?        01:17:03 tracepath > > just does not look right. > > At the very least disconnect that machine from the internet.  Completely. --------------hrJY9iii0Mz9ByXLlduTRtBj Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit
On 1/1/23 14:48, Adrian Klaver wrote:
On 1/1/23 13:11, Antonis Christodoulou wrote:
Hello Adrian,

No it’s not open, but the database itself has very simple credentials (I am just starting with PostgreSQL). What’s weird about the logs?

Not the logs the ps output. I would expect to see something like:

ps -ef | grep postgres
postgres  395382       1  0  2022 ?        00:03:31 /usr/lib/postgresql/14/bin/postgres -D /var/lib/postgresql/14/main -c config_file=/etc/postgresql/14/main/postgresql.conf
postgres  395384  395382  0  2022 ?        00:00:01 postgres: 14/main: checkpointer
postgres  395385  395382  0  2022 ?        00:00:26 postgres: 14/main: background writer
postgres  395386  395382  0  2022 ?        00:00:26 postgres: 14/main: walwriter
postgres  395387  395382  0  2022 ?        00:01:45 postgres: 14/main: autovacuum launcher
postgres  395388  395382  0  2022 ?        00:00:05 postgres: 14/main: archiver last was 0000000100000003000000B9.00000028.backup
postgres  395389  395382  0  2022 ?        00:01:37 postgres: 14/main: stats collector
postgres  395390  395382  0  2022 ?        00:02:24 postgres: 14/main: pg_cron launcher
postgres  395391  395382  0  2022 ?        00:00:01 postgres: 14/main: logical replication launcher

This:

postgres 3342383       1  0  2022 ?        00:00:00 FzXlkULu
postgres 3344758       1 99  2022 ?        3-14:39:11 OElid7Dp
postgres 3419125       1 18 13:57 ?        01:17:03 tracepath

just does not look right.


At the very least disconnect that machine from the internet.  Completely. 

--------------hrJY9iii0Mz9ByXLlduTRtBj--