Why is my Postgre server went in recovery mode all in sudden - Mailing list pgsql-admin
From | nikhil raj |
---|---|
Subject | Why is my Postgre server went in recovery mode all in sudden |
Date | |
Msg-id | CAG1ps1yFsBXZtsFi80Ei8VehHh29WSX-0-4DOdwekAeBoV+bwQ@mail.gmail.com Whole thread Raw |
Responses |
Re: Why is my Postgre server went in recovery mode all in sudden
|
List | pgsql-admin |
Hi Team,
I dont have any idea why did my Postgres server crash and it saystimestamp=2018-05-07 00:34:11.209 EDT,user=,db=,app=,client=,
timestamp=2018-05-07 00:34:11.209 EDT,user=,db=,app=,client=,
timestamp=2018-05-07 00:34:11.209 EDT,user=postgres,db=Ozalo,
FROM
t_e20so1_repository AS "repository" INNER JOIN t_e20so1_document_bigint AS "documentbigint" ON "repository"."c_repositoryid" = "documentbigint"."c_value"
WHERE "documentbigint"."c_
AND "documentbigint"."c_fieldid" = 'b035afc8-439f-4f2c-a9ae-
timestamp=2018-05-07 00:34:11.210 EDT,user=postgres,db= Ozalo,app=[unknown],
FROM
t_zs01_sys_dm AS "repository" INNER JOIN t_e20so1_document_bigint AS "documentbigint" ON "repository"."c_repositoryid" = "documentbigint"."c_value"
WHERE "documentbigint"."c_
AND "documentbigint"."c_fieldid" = 'b035afc8-439f-4f2c-a9ae-
timestamp=2018-05-07 00:34:11.218 EDT,user=postgres,db= Ozalo ,app=[unknown],transaction-ID=
timestamp=2018-05-07 00:34:11.218 EDT,user=postgres,db= Ozalo ,app=[unknown],transaction-ID=
timestamp=2018-05-07 00:34:11.218 EDT,user=postgres,db= Ozalo ,app=[unknown],transaction-ID=
timestamp=2018-05-07 00:34:11.357 EDT,user=,db=,app=,client=,
timestamp=2018-05-07 00:34:11.357 EDT,user=,db=,app=,client=,
timestamp=2018-05-07 00:34:11.379 EDT,user=postgres,db= Ozalo,app=[unknown],,
timestamp=2018-05-07 00:34:11.381 EDT,user=postgres,db= Ozalo,app=[unknown],transaction-
how much of share memory if its consume it will crash
Please can any one help me in this
or else what is the reason of crash of DB server Please can any one help me in this
Current using 10.3
Current Config
max_connections = 5000
shared_buffers = 7680MB
effective_cache_size = 23040MB
maintenance_work_mem = 1920MB
min_wal_size = 1GB
max_wal_size = 2GB
checkpoint_completion_target = 0.7
wal_buffers = 16MB
default_statistics_target = 100
random_page_cost = 1.1
effective_io_concurrency = 200
max_worker_processes = 16
max_parallel_workers_per_gather = 8
max_parallel_workers = 16
work_mem = 196kB
pgsql-admin by date: