Postgrsql blocked for more than 120 s

2023-07-16 Thread Bogdan Siara
Hi, I have a problem with my slave postgresql instance. During normal operations databaseis locked and in syslog I see stacktrace: Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.289110] INFO: task postgres:1172 blocked for more than 120 seconds. Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [

Re: Reset Postgresql users password

2023-07-16 Thread Ron
On 7/12/23 14:28, Johnathan Tiamoh wrote: Hello, I wish to find out if there is a way to reset all users in Postgresql password to the same password at once. To the same value?? -- Born in Arizona, moved to Babylonia.

Re: Rocky Linux 9 and postgres10

2023-07-16 Thread Ron
On 7/15/23 11:37, Daniel Gallo wrote: Good afternoon! I am writing to ask you the following question. Can postgres10 be installed on rocky linux 9? Although I know that it is a version that has already finished its life cycle, we are in migration processes We have a system with centos 7.5 and

Re: Problem perhaps after upgrading to pgadmin4 7.4

2023-07-16 Thread Ron
On 7/13/23 06:20, Carl Erik Eriksson wrote: Query tool PGadmin on my mac If I enter a query like select count(*) from table_1I get a correct response from the server If I enter select * from table_1 I get an error message that I do not understand: Error Message:missing FROM-clause entry

Re: Installation Issue

2023-07-16 Thread Adrian Klaver
On 7/15/23 07:30, Baskar Muthu wrote: Hi sir/mam I installed postre - sql but it is not connected with the server. I tried many times but it's not working and it shows a 'connecting server error'. This needs more information: 1) OS and version. 2) Postgresql version. 3) How was

Installation Issue

2023-07-16 Thread Baskar Muthu
Hi sir/mam I installed postre - sql but it is not connected with the server. I tried many times but it's not working and it shows a 'connecting server error'. Please resolve this issue and alternate ideas please let me know. Thanks & Regards Baskar Muthu