Question about PostgreSQL upgrade from version 12 to version 15

Hello everyone, I'm planning to upgrade my PostgreSQL database from version 12 to version 15 using pg_upgrade. After completing the upgrade process, I'm curious to know whether it's necessary to reindex the database. Could anyone please clarify whether reindexing is required after completing the

Re: PostgreSQL 12 reindex

It’s good idea do that like this: REINDEX TABLE CONCURRENTLY partitioned_table_1 REINDEX TABLE CONCURRENTLY partitioned_tab_2 REINDEX TABLE CONCURRENTLY partitioned_table_3 Regards, JK > Wiadomość napisana przez Joseph Kennedy w dniu > 28.08.2023, o godz. 15:51: > > How to sa

PostgreSQL 12 reindex

How to safely perform a reindex partitioned tables (postgresql 12) Regards, Jk

Re: PostgreSQL

> Wiadomość napisana przez Laurenz Albe w dniu > 09.02.2023, o godz. 16:42: > > On Thu, 2023-02-09 at 09:54 +0100, Joseph Kennedy wrote: >> As I wtote, I would like restrict access to sensitive or restricted >> information >> for some users (eg. hide data o

Re: PostgreSQL

RLS is the beat solution for me. Thank you for your suggestions. > Wiadomość napisana przez Stephen Frost w dniu > 08.02.2023, o godz. 01:36: > > Greetings, > > * Joseph Kennedy (joseph.kennedy@gmail.com) wrote: >> Thank you Laurenz, I just wanted to make sure.

Re: PostgreSQL

Thank you Laurenz, I just wanted to make sure. Do you know any alternative solution to RLS ? > Wiadomość napisana przez Laurenz Albe w dniu > 07.02.2023, o godz. 15:34: > > On Tue, 2023-02-07 at 12:36 +0100, Joseph Kennedy wrote: >> RLS policy it only affects to command

Re: PostgreSQL

use RLS you must enable it on the table you want to use in.best regards, GiovanniIl giorno mar 7 feb 2023 alle ore 12:02 Joseph Kennedy <joseph.kennedy@gmail.com> ha scritto:I would like restrict access to sensitive or restricted information for some users (eg. hide data of one or more clien

PostgreSQL

I would like restrict access to sensitive or restricted information for some users (eg. hide data of one or more clients for some database users). PostgreSQL allows to create security policy as Row-Level Security, policies based on the querying user. Are there any other alternatives to RLS, ar

copy databases from two differend backups to one cluster

I would like to copy databases from two different pg_basebackup backups to one lab environment database cluster on another server. Is it possible ? It's a good idea to do it in that way. Databases has your oid in pg_basebackup we can find it id in base directory for example: base/ 1 125859 1

synchronous streaming replication

Hi, I have a question. Its stays at the intersection of software engineering and PostgreSQL. I have configured streaming synchronous replication and whit setting "synchronous_commit=remote_apply" to make sure that the slave will always respond the same as the MASTER (this is a developers' requir