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

2023-01-02 Thread Antonis Christodoulou
hias Apitz wrote: > > El día lunes, enero 02, 2023 a las 08:53:32a. m. +0200, Antonis Christodoulou > escribió: > >> And for the record, Ahmet, here’s a weird cron job: >> >> christan@vultr:~$ sudo crontab -l -u postgres >> 13 *

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

2023-01-01 Thread Antonis Christodoulou
2023, at 8:34 AM, Antonis Christodoulou > wrote: > > Hmm wow, never thought this could be the case. Yes I am using > postgres/postgres for my db, and I am indeed allowing full remote access in > my pg_hba.conf (I would definitely change this, just wanted to start testing > it…)

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

2023-01-01 Thread Antonis Christodoulou
Jan 2023, at 8:29 AM, Ahmet Demir wrote: > > And I can suggest checking cron jobs both on root and postgres, killing those > processes and changing root postgres passwords. > > Ahmet > > On Mon, 2 Jan 2023 at 09:19, Tom Lane <mailto:t...@sss.pgh.pa.us>&g

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

2023-01-01 Thread Antonis Christodoulou
into a dedicated AWS instance, just to see if I’m getting the same behavior there... > On 1 Jan 2023, at 11:50 PM, Rob Sargent wrote: > > On 1/1/23 14:48, Adrian Klaver wrote: >> On 1/1/23 13:11, Antonis Christodoulou wrote: >>> Hello Adrian, >>> >>

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

2023-01-01 Thread Antonis Christodoulou
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? > On 1 Jan 2023, at 11:00 PM, Adrian Klaver wrote: > > On 1/1/23 12:51, Antonis Christodoulou wrote: >> Hi, >> I h

PostgreSQL 12 service failing in Ubuntu 20.04 after a few hours

2023-01-01 Thread Antonis Christodoulou
Hi, I have set up PostgreSQL according to this link: https://www.cherryservers.com/blog/how-to-install-and-setup-postgresql-server-on-ubuntu-20-04 The issue is that after a few hours of operation, e