Home > mailing lists

ssh to DB server and su normal users very slow : - Mailing list pgsql-general

From	KK CHN
Subject	ssh to DB server and su normal users very slow :
Date	September 9 17:20:37
Msg-id	CAKgGyB-9sKr+J8QjDY-5FyZC3Ov7HB1T7=efm7dF6YejCQ4hdA@mail.gmail.com Whole thread Raw
Responses	Re: ssh to DB server and su normal users very slow :
List	pgsql-general

Tree view

List,

I have configured pgbackrest for the DB server and Repo Server(created the stanza info check all fine. in these machines.

/var/spool/pgbackrest shows the .Ok for each WAL and the Repo server receiving the archiving of WAL in the archive directory .

I didn't schedule a pgbackrest back as of now due to an issue I am facing as follows.

PROBLEM Statement:

I am facing a delay in ssh root@dbserver_IP from my Desktop PC. More than a minute to login to the root console from any remote terminal, but this issue was not there all these days.

I have done two changes in the DB server :-

pg_hba.conf entry

ie; changed the entry #local all all trust

#local all all md5

It already having replication entry as

local replication all peer

Added a .pgpass entry in the DB user's ~/dir/ with the following

[root@db1 ~]# cat /var/lib/edb/.pgpass
*:*:*:enterprisedb:password

Is this causing login delays ? Local connection asking password(pg_hba.conf entry ) and .pgpass contain the user and password for connecting ?

3. Even if I able to login to the DB server from the Remote Repo server after a minute or two, in side the DB server doing a # su enterprisedb taking around 90 to 120 seconds to change the user as enterprisedb user ??

Any hints much appreciated ..

Thanks in advance,

Krishane

For more details I am pasting the top output ( vCPU 16 nos , RAM 16 GB)

top - 10:11:43 up 5 days, 17:21, 5 users, load average: 0.97, 1.38, 1.26
Tasks: 710 total, 1 running, 708 sleeping, 1 stopped, 0 zombie
%Cpu(s): 1.3 us, 0.6 sy, 0.0 ni, 97.1 id, 0.6 wa, 0.1 hi, 0.3 si, 0.0 st
MiB Mem : 15733.6 total, 664.0 free, 6371.1 used, 13237.6 buff/cache
MiB Swap: 8060.0 total, 7985.1 free, 74.9 used. 9362.4 avail Mem

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
3547252 enterpr+ 20 0 4656880 262304 252032 S 8.3 1.6 0:01.97 edb-postgres
2588 enterpr+ 20 0 4622104 12704 10888 S 2.0 0.1 106:10.00 edb-postgres
3554955 enterpr+ 20 0 4661692 632052 621364 S 2.0 3.9 0:00.99 edb-postgres
3555894 enterpr+ 20 0 4633432 628388 621056 S 1.3 3.9 0:00.26 edb-postgres
3525520 enterpr+ 20 0 4658888 555596 543872 S 1.0 3.4 0:10.82 edb-postgres
3546456 enterpr+ 20 0 4627288 40852 38016 S 1.0 0.3 0:00.30 edb-postgres
3554919 enterpr+ 20 0 4655376 564024 557020 S 1.0 3.5 0:00.30 edb-postgres
3555796 enterpr+ 20 0 4635024 565716 556840 S 1.0 3.5 0:00.22 edb-postgres
3556084 enterpr+ 20 0 4653424 59156 51968 S 1.0 0.4 0:00.06 edb-postgres
3525597 enterpr+ 20 0 4627444 44052 41088 S 0.7 0.3 0:00.47 edb-postgres
377 root 0 -20 0 0 0 I 0.3 0.0 2:43.11 kworker/5:1H-kblockd
2923344 enterpr+ 20 0 4625236 225176 223104 S 0.3 1.4 1:23.93 edb-postgres
3525722 enterpr+ 20 0 4627328 99220 96128 S 0.3 0.6 0:01.99 edb-postgres
3555151 root 20 0 226580 4864 3456 R 0.3 0.0 0:00.15 top
3555807 enterpr+ 20 0 4627444 350228 347136 S 0.3 2.2 0:00.03 edb-postgres
3556023 enterpr+ 20 0 4653636 60052 52608 S 0.3 0.4 0:00.15 edb-postgres
3556026 enterpr+ 20 0 4653424 59796 52608 S 0.3 0.4 0:00.22 edb-postgres
3556074 enterpr+ 20 0 4653448 59540 52224 S 0.3 0.4 0:00.11 edb-postgres
3556075 enterpr+ 20 0 4653372 59412 52224 S 0.3 0.4 0:00.18 edb-postgres

and # ps -ax shows

[root@db1 ~]# ps -ax |grep "idle"

3511515 ? I 0:00 [kworker/5:0-inet_frag_wq]
3512991 ? Ss 0:00 postgres: enterprisedb postgres 10.21.134.205(56754) idle
3513003 ? Ss 0:00 postgres: enterprisedb er_db 10.21.13.205(56770) idle
3513005 ? Ss 0:00 postgres: enterprisedb tp_db 10.21.13.205(56772) idle
3513267 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(39262) idle
3513476 ? Ss 0:00 postgres: enterprisedb er_db 10.21.13.205(56839) idle
3513704 ? Ss 0:00 postgres: enterprisedb mt_db 10.21.13.202(56608) idle
3513729 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(44926) idle
3514113 ? Ss 0:00 postgres: enterprisedb mt_db 10.21.13.202(53743) idle
3514374 ? Ss 0:00 postgres: enterprisedb mt_db 10.21.13.202(58623) idle
3514397 pts/1 T 0:00 top
3515012 ? Ss 0:00 postgres: enterprisedb mt_db 10.21.13.202(58686) idle
3515088 ? Ss 0:00 postgres: enterprisedb mgt_db 10.21.13.202(58586) idle
3515942 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(64844) idle
3515987 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(27190) idle
3516230 ? Ss 0:00 postgres: enterprisedb postgres 10.21.13.202(60354) idle
3516655 ? Ss 0:00 postgres: enterprisedb er_db 10.21.13.205(57348) idle
3519209 ? Ss 0:00 postgres: enterprisedb g_db 10.21.13.202(59611) idle
3519948 ? Ss 0:00 postgres: enterprisedb postgres 10.21.13.204(58224) idle
3520004 ? Ss 0:00 postgres: enterprisedb er_db 10.21.13.204(58239) idle
3521990 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(39000) idle
3525800 ? Ss 0:00 postgres: enterprisedb er_db 10.21.13.204(58606) idle
3525914 ? Ss 0:00 postgres: enterprisedb er_db 10.21.13.204(59004) idle
3528403 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(44250) idle
3532345 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(64230) idle
3533852 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(34514) idle
3533969 ? Ss 0:00 postgres: enterprisedb g_db 10.21.13.202(58464) idle

3354541 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(62640) idle
3356744 ? I 0:00 [kworker/3:2]
3365496 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(47376) idle
3367163 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(48814) idle
3368555 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(56520) idle
3370980 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(19930) idle
3371824 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(36006) idle
3372285 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(37632) idle
3373166 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(36862) idle
3379317 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(17632) idle
3385442 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(21096) idle
3385790 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(47792) idle
3389859 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(56094) idle
3397876 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(32436) idle
3404172 ? Ss 0:00 postgres: enterprisedb ad_db 10.23.0.206(37122) idle
3404779 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(62946) idle
3405628 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(37568) idle
3406414 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(50994) idle
3408051 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(14956) idle
3410935 ? I 0:00 [kworker/7:2-events]
3432820 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(31348) idle
3434126 ? Ss 0:01 postgres: enterprisedb ad_db 10.23.0.206(48372) idle
3436428 ? Ss 0:00 postgres: enterprisedb mt_db 10.23.0.207(36930) idle
3443063 ? Ss 0:00 postgres: enterprisedb er_db 10.23.0.203(57624) idle

pgsql-general by date:

From: Achilleas Mantzios - cloud
Date: 09 September, 16:24:41
Subject: Re: postgresql FDW vs dblink for DDL

From: Philip Hazelden
Date: 09 September, 19:02:50
Subject: Clarify this MERGE warning? "Only columns from the target table that attempt to match data_source rows should appear in join_condition."

ssh to DB server and su normal users very slow : - Mailing list pgsql-general

Previous

Next