On 2/26/22 13:34, Techsupport wrote:
Thanks for your reply.
Is it a good practice to upgrade / update database on production on every
year ?
No, it is not a good practice. Database upgrade must be treated as a
project which will result in non-negligible downtime. You should upgrade
to the new
On 2/26/22 10:17, Laurenz Albe wrote:
*If you talking about a Windows CIFS (Network Share), you may be out
of luck. That is known to be an unreliable file system that cannot be
used with a database.*
A crash has likely corrupted your database.
(But we cannot tell for certain, because you didn't
On Sun, Feb 27, 2022 at 12:04:19AM +0530, Techsupport wrote:
> Hi,
>
> Thanks for your reply.
> Is it a good practice to upgrade / update database on production on every
> year ?
It's a good practice to update all the software you rely on each time a minor
version is released, especially if those
On Sat, Feb 26, 2022 at 11:34 AM Techsupport
wrote:
>
> Is it a good practice to upgrade / update database on production on every
> year ?
>
>
Patches (updates) are released roughly every three months. You should
apply them as soon after they are released as feasible.
We (I) tend to reserve the
nks,
-Original Message-
From: Julien Rouhaud [mailto:rjuju...@gmail.com]
Sent: Saturday, February 26, 2022 8:27 PM
To: Techsupport
Cc: pgsql-general@lists.postgresql.org
Subject: Re: 20220226-Clarification regarding delay time of PostgeSQL
starting up
Hi,
On Sat, Feb 26, 2022 at 07:51:45PM +0
On Sat, 2022-02-26 at 19:51 +0530, Techsupport wrote:
> Database data directory is configured in the network shared path.
> Unexpectedly it was disconnected and up again.
If you talking about a Windows CIFS (Network Share), you may be out of luck.
That is known to be an unreliable file system tha
Hi,
On Sat, Feb 26, 2022 at 07:51:45PM +0530, Techsupport wrote:
> Hi to all,
>
> We are using PostgreSQL 12.3, it is running on the Windows Server.
So, you're using a version released almost 2 years ago, missing 8 minor
releases worth of bug fixes. In general, if you have a problem you should j
Hi to all,
We are using PostgreSQL 12.3, it is running on the Windows Server.
Database data directory is configured in the network shared path.
Unexpectedly it was disconnected and up again.
PgAgent is not connected, when I check the Log, it showing
FATAL: the database system is star
Hi,
I'm trying to figure out what information retrieval model[1]
the PostgreSQL Full-Text Search is based on.
Based on my reading on the PostgreSQL documentation I would have guessed
extended boolean model but I came across an web article by Compose[2]
which claims that FTS is based on vector spa
