Re: PostgreSQL Read-only mode usage

Hi,1- What does it mean, not the whole database? 2- Can this be considered a kind of guard? 3- Can you tell me a read-only scenario? For example, if we have three servers, then one of the servers can be the main server and the other two servers can be read only. On Wed, Feb 28, 2024 at

Re: PostgreSQL Read-only mode usage

På onsdag 28. februar 2024 kl. 13:55:34, skrev Andreas Kretschmer < andr...@a-kretschmer.de >: Am 28.02.24 um 13:34 schrieb Jason Long: > Hello, > What is the use of a database in read-only mode? a standby-database will also be in read-only mode. Right, we have

Re: PostgreSQL Read-only mode usage

Am 28.02.24 um 13:34 schrieb Jason Long: Hello, What is the use of a database in read-only mode? a standby-database will also be in read-only mode. Regards, Andreas -- Andreas Kretschmer CYBERTEC PostgreSQL Services and Support

Re: PostgreSQL Read-only mode usage

On Wed, 28 Feb 2024 at 13:34, Jason Long wrote: > What is the use of a database in read-only mode? Normally it is a connection/session to the database what is in read-only mode, not the whole database. As it has been pointed out, you connect in read only mode to read, so you are protected from

Sv: PostgreSQL Read-only mode usage

På onsdag 28. februar 2024 kl. 13:34:30, skrev Jason Long mailto:hack3r...@yahoo.com>>: Hello, What is the use of a database in read-only mode? Thank you. To be able to read, not modify, the data. Reporting-tools like Microsoft PowerBI can connect to PG and generate nice reports. --

PostgreSQL Read-only mode usage

Hello, What is the use of a database in read-only mode? Thank you.