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
