Обсуждение: PostgreSQL Read-only mode usage

Поиск
Список
Период
Сортировка

PostgreSQL Read-only mode usage

От
Jason Long
Дата:
Hello,
What is the use of a database in read-only mode?

Thank you.

Sv: PostgreSQL Read-only mode usage

От
Andreas Joseph Krogh
Дата:
På onsdag 28. februar 2024 kl. 13:34:30, skrev Jason Long <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
 
Вложения

Re: PostgreSQL Read-only mode usage

От
Francisco Olarte
Дата:
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.

Re: PostgreSQL Read-only mode usage

От
Andreas Kretschmer
Дата:

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

От
Andreas Joseph Krogh
Дата:
På onsdag 28. februar 2024 kl. 13:55:34, skrev Andreas Kretschmer <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
 
Вложения

Re: PostgreSQL Read-only mode usage

От
Jason Long
Дата:
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.