Re: Autovacuum on Partitioned Tables

On Mon, 2022-10-31 at 17:26 -0500, Ryan Ruenroeng wrote: > There is a statement in the Postgres Docs: "Partitioned tables are not > processed by autovacuum." > > What does the above statement mean? > Does autovacuum not process both the parent and the child tables in a > partition relationship? 

Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all"

On Mon, 2022-10-31 at 22:03 -0700, Bryn Llewellyn wrote: > I followed Peter's recommendation NOT to put my "clstr_mgr" O/S user in the > "postgres" > group—having earlier had it there. But doing so brought this content-free > error message > on an attempt to authorize using the intended method: >

Re: empty pg_stat_progress_vacuum

On Fri, Oct 21, 2022 at 10:21:23PM +, senor wrote: > I'm mainly wanting to understand why I'm not seeing processes in > pg_stat_progress_vacuum. If I rapidly refresh I occasionally see an > entry for a very small table. A manually started vacuum didn't show > up either. It may be possible that

Re: Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all"

On Mon, Oct 31, 2022 at 10:03 PM Bryn Llewellyn wrote: > It would seem proper to put any user who you want to set up for "local", > "peer" authentication into the "postgres" group > Did you really mean to write that? The postgres o/s user should be able to login using peer. It is a one-way ide

Putting the O/S user for "local" "peer" authentication in the "postgres" group vs chmod'ing the "pg*.conf" files to be readable by "all"

I followed Peter's recommendation NOT to put my "clstr_mgr" O/S user in the "postgres" group—having earlier had it there. But doing so brought this content-free error message on an attempt to authorize using the intended method: Error: Invalid data directory for cluster 11 main A bit of Googlin

Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

> david.g.johns...@gmail.com wrote: > >> b...@yugabyte.com wrote: >> >> This is what I see. I have Ubuntu 20.04 LTS VM using Parallels Desktop >> Version 18. >> >> # adduser 'dog$house' >> adduser: To avoid problems, the username should consist only of >> letters, digits, underscores, periods,

Re: Autovacuum on Partitioned Tables

Ron writes: > On 10/31/22 17:26, Ryan Ruenroeng wrote: >> I have a table with 50+ million rows that gets data added to/wiped from it >> every 90 days. We are planning to break this table into a few thousand >> partitions. > 1. That's a lot of partitions.  Older (like v12) query optimizers don't

Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

On Mon, Oct 31, 2022 at 8:19 PM Bryn Llewellyn wrote: > > This is what I see. I have Ubuntu 20.04 LTS VM using Parallels Desktop > Version 18. > > # adduser 'dog$house' > adduser: To avoid problems, the username should consist only of > letters, digits, underscores, periods, at signs and dashes,

Re: Autovacuum on Partitioned Tables

On 10/31/22 17:26, Ryan Ruenroeng wrote: Hello there! There is a statement in the Postgres Docs: "Partitioned tables are not processed by autovacuum." What does the above statement mean? Does autovacuum not process both the parent and the child tables in a partition relationship? Partition

Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

hjp-pg...@hjp.at wrote: > >> b...@yugabyte.com wrote: >> >> However, Linux (at least) simply disallows O/S users that have a dollar sign >> in the name. > > This is getting quite off-topic, but that isn't true: > > trintignant:~ 22:46 :-) 1015# useradd -m -s /bin/bash 'mac$crooge' > trintignan

Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

> adrian.kla...@aklaver.com wrote: > >> b...@yugabyte.com wrote: >> >>> adrian.kla...@aklaver.com wrote: >>> b...@yugabyte.com wrote: This, on the other hand: psql -d postgres -U 'clstr$mgr' calls for "local", "peer" authen

Autovacuum on Partitioned Tables

Hello there! There is a statement in the Postgres Docs: "Partitioned tables are not processed by autovacuum." What does the above statement mean? Does autovacuum not process both the parent and the child tables in a partition relationship? What is the definition of a partitioned table? I have a

Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

On 2022-10-30 21:01:25 -0700, Bryn Llewellyn wrote: > However, Linux (at least) simply disallows O/S users that have a > dollar sign in the name. This is getting quite off-topic, but that isn't true: trintignant:~ 22:46 :-) 1015# useradd -m -s /bin/bash 'mac$crooge' trintignant:~ 22:46 :-) 1016#

Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

On 10/31/22 10:31 AM, Bryn Llewellyn wrote: adrian.kla...@aklaver.com wrote: b...@yugabyte.com wrote: This, on the other hand: psql -d postgres -U 'clstr$mgr' calls for "local", "peer" authentication as so it does NOT require a p

Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

> adrian.kla...@aklaver.com wrote: > >> b...@yugabyte.com wrote: >> >> This, on the other hand: >> >> psql -d postgres -U 'clstr$mgr' >> >> calls for "local", "peer" authentication as so it does NOT require a >> password. That would be enough for me. But, naturally, and now that it's >> worki

Re: CASE CLOSED... Re: "peer" authentication: cannot make "pg_ident.conf" work as I believe that the doc says that it should

On 10/30/22 21:01, Bryn Llewellyn wrote: See comments inline. *INTRODUCTION *Thanks to all who've helped me on this topic. Forgive me if I left out anybody on the "To" list. I suppose that I should have explained my use case more carefully. I did sketch it earlier on. But, not surprisingly

PGSQL Phriday #002: PostgreSQL Backup and Restore

Hello, The topic for the second #PGSQLPhriday is: PostgreSQL Backup and Restore Your task: *Describe how you do backups for your PostgreSQL databases.* Which tool(s) are you using, where do you store backups, how often do you do backups? Are there any recommendations you can give the reader

Alfresco and postgres schemas

Hi all, Does anyone have experience on setting up Alfresco on several postgresql schemas? I'm not familiar with Alfresco, but I have been requested to create 4 schemas, owned by 4 users, like "user_1" owns "user_schema_1". "user_2" owns "user_schema_2" and so on, all under one database. Applicati

Re: Off-topic? How to extract database statements from JPA?

Hi Gus: JPA (Jakarta Persistence API; previously known as Java Persistence API) is "just" the specification. There are several implementations of this. The reference implementation is EclipseLink, but there are others widely used such as Hibernate or OpenJPA. You should ask which one is being

Re: Off-topic? How to extract database statements from JPA?

> On 31/10/2022 11:50 CET Gus Spier wrote: > > I apologize if this is off-topic, but I've become exceedingly frustrated and > need help. > > The assignment is to evaluate SQL code for an application that has been built > with Java Springer Persistence API and, if appropriate, offer suggestions to

Off-topic? How to extract database statements from JPA?

I apologize if this is off-topic, but I've become exceedingly frustrated and need help. The assignment is to evaluate SQL code for an application that has been built with Java Springer Persistence API and, if appropriate, offer suggestions to improve database performance. The problem is that I am