Re: [INTERNET] Re: auto vacuum question

2023-08-29 Thread Jerry Sievers
Alan Stange writes: > On 8/28/23 18:35, Jerry Sievers wrote: > >> Adrian Klaver writes: >> >>> On 8/28/23 13:06, Alan Stange wrote: >>> All, We recently changed the name of the superuser role in our database, >> My take on this, is that the *postmaster* user is perhaps the one that >>

Re: [INTERNET] Re: auto vacuum question

2023-08-29 Thread Alan Stange
On 8/28/23 18:35, Jerry Sievers wrote: > Adrian Klaver writes: > >> On 8/28/23 13:06, Alan Stange wrote: >> >>> All, >>> We recently changed the name of the superuser role in our database, > My take on this, is that the *postmaster* user is perhaps the one that > the OP cut privileges on, and thus

Re: [INTERNET] Re: auto vacuum question

2023-08-28 Thread Adrian Klaver
On 8/28/23 13:19, Alan Stange wrote: On 8/28/23 16:11, Adrian Klaver wrote: On 8/28/23 13:06, Alan Stange wrote: All, Are you sure that is coming from autovacuum? What are the log lines preceding the WARNING? What is the complete warning line? Thank you for your quick response. The pref

Re: [INTERNET] Re: auto vacuum question

2023-08-28 Thread Alan Stange
On 8/28/23 16:11, Adrian Klaver wrote: > On 8/28/23 13:06, Alan Stange wrote: >> All, >> >> We recently changed the name of the superuser role in our database, and >> then noticed some issues with the autovacuum processes.  We are running >> 15.3, and had a login role, lets call it 'red', which had