Thread

1. PostgreSQL Read-only mode usage

   Jason Long <hack3rcon@yahoo.com> — 2024-02-28T12:34:30Z

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

2. Sv: PostgreSQL Read-only mode usage

   Andreas Joseph Krogh <andreas@visena.com> — 2024-02-28T12:37:22Z

   
   På onsdag 28. februar 2024 kl. 13:34:30, skrev Jason Long <hack3rcon@yahoo.com 
   <mailto:hack3rcon@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.
   
   
   
   
   
   
   --
   Andreas Joseph Krogh
   CTO / Partner - Visena AS
   Mobile: +47 909 56 963
   andreas@visena.com <mailto:andreas@visena.com>
   www.visena.com <https://www.visena.com>
    <https://www.visena.com>
   

3. Re: PostgreSQL Read-only mode usage

   Francisco Olarte <folarte@peoplecall.com> — 2024-02-28T12:53:31Z

   On Wed, 28 Feb 2024 at 13:34, Jason Long <hack3rcon@yahoo.com> 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 accidental modifications. Also, knowing your
   transactions are not going to write make life easier for optimizers
   and other things.
   
   Francisco Olarte.
   
   
   
   

4. Re: PostgreSQL Read-only mode usage

   Andreas Kretschmer <andreas@a-kretschmer.de> — 2024-02-28T12:55:34Z

   
   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
   
   
   
   
   

5. Re: PostgreSQL Read-only mode usage

   Andreas Joseph Krogh <andreas@visena.com> — 2024-02-28T14:50:30Z

   
   På onsdag 28. februar 2024 kl. 13:55:34, skrev Andreas Kretschmer <
   andreas@a-kretschmer.de <mailto:andreas@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 PowerBI connected to a standby-DB, streaming-replication.
   
   
   
   
   
   
   --
   Andreas Joseph Krogh
   CTO / Partner - Visena AS
   Mobile: +47 909 56 963
   andreas@visena.com <mailto:andreas@visena.com>
   www.visena.com <https://www.visena.com>
    <https://www.visena.com>
   

6. Re: PostgreSQL Read-only mode usage

   Jason Long <hack3rcon@yahoo.com> — 2024-02-28T15:43:32Z

   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 4:24 PM, Francisco Olarte<folarte@peoplecall.com> wrote:   On Wed, 28 Feb 2024 at 13:34, Jason Long <hack3rcon@yahoo.com> 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 accidental modifications. Also, knowing your
   transactions are not going to write make life easier for optimizers
   and other things.
   
   Francisco Olarte.