On 5/8/21 9:19 PM, sivapostg...@yahoo.com wrote:
1. First why switch the computer off for lunch?
It's a development machine and I'm a developer. We used to shut
down every computer for lunch. We shut down the windows and not just hit
the power switch. We advice and follow every use
Yesterday's log file. Till we shut down the windows the message
was:2021-05-08 19:03:32.151 IST [10376] FATAL: the database system is starting
up2021-05-08 19:03:42.210 IST [7568] FATAL: the database system is starting up
Today morning log file, I tried to start the service [ after setting
1. First why switch the computer off for lunch? It's a development
machine and I'm a developer. We used to shut down every computer for lunch.
We shut down the windows and not just hit the power switch. We advice and
follow every users and client to shut down the windows properly
Hello Laurenz,
The above metric works fine for my primary server. However, We have a
cascading setup in our production system. This particular query doesn't
work for my intermediate server which is standby to the primary server but
also a master to one more standby server. We get the following err
On 2021-05-08 15:58:27 +0530, Atul Kumar wrote:
> ok, But what is the workaround of this parameter in postgres 9.5, ,I
> need to increase the time of "idle in transaction" transactions.
What makes you think that there is an "idle in transaction" timeout in
9.5?
hp
--
_ | Peter J. Ho
Adrian Klaver writes:
> On 5/8/21 9:23 AM, Ron wrote:
>> Is Windows Postgresql a service? If so then Windows "should" shut it
>> down cleanly when you cleanly power off the machine.
> The log would indicate otherwise:
>
>>> 2021-05-08 10:26:20.783 IST [7360] LOG: database system was
>>> inter
On 5/8/21 9:23 AM, Ron wrote:
On 5/8/21 10:53 AM, Adrian Klaver wrote:
On 5/7/21 10:14 PM, sivapostg...@yahoo.com wrote:
Hello,
PG 11.8 in Windows 10 and currently PG 11.11
Yesterday [07th May] morning when we switched on the computer and
subsequently PGAdmin, we got the message following me
On 5/8/21 10:53 AM, Adrian Klaver wrote:
On 5/7/21 10:14 PM, sivapostg...@yahoo.com wrote:
Hello,
PG 11.8 in Windows 10 and currently PG 11.11
Yesterday [07th May] morning when we switched on the computer and
subsequently PGAdmin, we got the message following message
FATAL: the database syst
On 5/7/21 10:14 PM, sivapostg...@yahoo.com wrote:
Hello,
PG 11.8 in Windows 10 and currently PG 11.11
Yesterday [07th May] morning when we switched on the computer and
subsequently PGAdmin, we got the message following message
FATAL: the database system is starting up
I uninstalled PG and in
On Sat, May 8, 2021 at 7:55 AM Vijaykumar Jain <
vijaykumarjain.git...@gmail.com> wrote:
> Why do you want to increase that timeout ?
> I hope you are aware long idle in transactions connections would delay
> vacuuming and result in much larger bloats and slow down the db over period
> of time.
>
Or server’s log file is available elsewhere ?
On Saturday, 8 May, 2021, 01:24:50 pm IST, sivapostg...@yahoo.com
wrote:
The above is the contents of the log file from 'data' folder of PG.
Message in Windows Application Event2021-05-08 10:26:19.425 IST [5588] LOG:
listening on IPv
Why do you want to increase that timeout ?
I hope you are aware long idle in transactions connections would delay
vacuuming and result in much larger bloats and slow down the db over period
of time.
You need to upgrade and push using the reasons that these are not supported.
asking for workarounds
ok, But what is the workaround of this parameter in postgres 9.5, ,I
need to increase the time of "idle in transaction" transactions.
Regards,
Atul
On 5/7/21, luis.robe...@siscobra.com.br wrote:
>
> - Mensagem original -
>> De: "Atul Kumar"
>> Para: "pgsql-general"
>> Enviada
On Mon, May 03, 2021 at 11:10:44AM -0400, Jan Wieck wrote:
> Not yet, but I will enter it so that we can get it into 15 for sure.
I may be missing something but this is not listed:
https://commitfest.postgresql.org/33/
Could you add it to the CF app please? There are so many patches and
discussi
The above is the contents of the log file from 'data' folder of PG.
Message in Windows Application Event2021-05-08 10:26:19.425 IST [5588] LOG:
listening on IPv4 address "0.0.0.0", port 5433
On Saturday, 8 May, 2021, 11:02:06 am IST, David G. Johnston
wrote:
On Friday, May 7, 202
15 matches
Mail list logo
