pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jason Long <hack3rcon@yahoo.com>
To: folarte@peoplecall.com
Cc: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Subject: Re: PostgreSQL Read-only mode usage
Date: Wed, 28 Feb 2024 15:43:32 +0000 (UTC)
Message-ID: <846580225.1063051.1709135012618@mail.yahoo.com> (raw)
In-Reply-To: <CA+bJJbyV1LPs6ZSS04mFcHDBXTRYUBFDLxewsWhXymDZcgtKHQ@mail.gmail.com>
References: <1413835786.1017118.1709123670125.ref@mail.yahoo.com>
	<1413835786.1017118.1709123670125@mail.yahoo.com>
	<CA+bJJbyV1LPs6ZSS04mFcHDBXTRYUBFDLxewsWhXymDZcgtKHQ@mail.gmail.com>

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.
  

view thread (5+ messages)

Message-ID: <846580225.1063051.1709135012618@mail.yahoo.com>
Permalink:  ../846580225.1063051.1709135012618@mail.yahoo.com/
Also on:    postgresql.org/message-id/846580225.1063051.1709135012618@mail.yahoo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: hack3rcon@yahoo.com, folarte@peoplecall.com
  Subject: Re: PostgreSQL Read-only mode usage
  In-Reply-To: <846580225.1063051.1709135012618@mail.yahoo.com>
  References: <1413835786.1017118.1709123670125.ref@mail.yahoo.com> <1413835786.1017118.1709123670125@mail.yahoo.com> <CA+bJJbyV1LPs6ZSS04mFcHDBXTRYUBFDLxewsWhXymDZcgtKHQ@mail.gmail.com> <846580225.1063051.1709135012618@mail.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox