Re: alter system command

2020-12-27 Thread Ahmet Demir
Hi, Please check postgresql.auto.conf file. https://www.postgresql.org/docs/13/sql-altersystem.html Ahmet On Sun, 27 Dec 2020 at 10:53, Atul Kumar wrote: > hi, > > I have set archive_command like below: > > alter system set archive_command ='pgbackrest --stanza=main archive-push > %'; > > then

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

2023-01-01 Thread Ahmet Demir
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 wrote: > Antonis Christodoulou < > vi1p193mb051005c8be974502a0d4a315e1...@vi1p193mb0510.eurp193.prod.outlook.com> > writes:

Re: TRUNCATE memory leak with temporary tables?

2021-05-28 Thread Ahmet Demir
Hi Ravi, I am not sure about that "It creates a new empty table , followed by rename of the existing table to the new empty table and finally dropping of the old table." You mean table is re-created with new oid? thanks Ahmet On Fri, 28 May 2021 at 15:10, Ravi Krishna wrote: > Truncate is not