Installation Issue
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
Re: Installation Issue
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 Postgresql installed? 5) Is the Postgresql server running? 6) What client are you connecting with and the connection parameters? 7) Is the client remote to the server? 8) The complete error message. Please resolve this issue and alternate ideas please let me know. Thanks & Regards Baskar Muthu -- Adrian Klaver adrian.kla...@aklaver.com
Re: Problem perhaps after upgrading to pgadmin4 7.4
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 for table "rel" LINE 8: ...ER JOIN pg_catalog.pg_constraint con ON con.conrelid=rel.oid PSQL tool (PGadmin on my Mac) However if I enter the same from the PSQL tool I get the correct output. But that output goes to my screen and I have found no way of directing it to a file on my Mac. Any suggestions? Either getting rid of the error message and getting the output to my screen within the Query tool where I can then dump the output to a file OR a way of running my query using the PSQL tool and redirecting the output to a file on my computer. Two other solutions: psql --dbname=foo -c "select * from table_1;" > table_1.txt psql foo --csv -c "select * from table_1;" > table_1.csv -- Born in Arizona, moved to Babylonia.
Re: Rocky Linux 9 and postgres10
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 postgres 10 and the infrastructure group wants to do an installation with rocky linux 9 I have not found anywhere if it is supported Thank you very much for your time According to https://yum.postgresql.org/rpmchart/, there are Pg 10 binaries for RHEL7. You'll just have to manually download the relevant RPM files yourself. -- Born in Arizona, moved to Babylonia.
Re: Reset Postgresql users password
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.
Postgrsql blocked for more than 120 s
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: [ 1331.292137] Not tainted 5.19.0-1028-aws #29~22.04.1-Ubuntu Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.295239] "echo 0 > /proc/sys/kernel/hung_task_timeout_secs" disables this message. Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299360] task:postgres state:D stack:0 pid: 1172 ppid: 1133 flags:0x0004 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299366] Call Trace: Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299369] Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299373] __schedule+0x254/0x5a0 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299381] schedule+0x5d/0x100 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299385] io_schedule+0x46/0x80 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299389] blk_mq_get_tag+0x117/0x300 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299394] ? destroy_sched_domains_rcu+0x40/0x40 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299399] __blk_mq_alloc_requests+0xc4/0x1e0 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299404] blk_mq_get_new_requests+0xcc/0x190 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299408] blk_mq_submit_bio+0x1eb/0x450 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299411] __submit_bio+0xf6/0x190 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299414] ? kmem_cache_alloc+0x1a6/0x2f0 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299419] __submit_bio_noacct+0x81/0x1f0 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299422] submit_bio_noacct_nocheck+0x104/0x1c0 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299425] ? ext4_inode_block_valid+0x1d/0x40 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299430] submit_bio_noacct+0x1b9/0x600 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299433] submit_bio+0x40/0xf0 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299437] ext4_mpage_readpages+0x254/0xc20 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299441] ? xas_load+0x1f/0x100 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299447] ? __filemap_add_folio+0x1ca/0x540 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299452] ext4_readahead+0x3f/0x50 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299455] read_pages+0x7b/0x2e0 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299459] page_cache_ra_unbounded+0x12d/0x180 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299462] force_page_cache_ra+0xc5/0x100 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299466] generic_fadvise+0x19d/0x280 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299469] ksys_fadvise64_64+0x9f/0xb0 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299471] ? syscall_trace_enter.constprop.0+0xb5/0x1a0 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299475] __x64_sys_fadvise64+0x1c/0x30 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299478] do_syscall_64+0x5c/0x90 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299482] ? exc_page_fault+0x92/0x190 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299485] entry_SYSCALL_64_after_hwframe+0x63/0xcd Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299489] RIP: 0033:0x7f7358c993c2 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299493] RSP: 002b:7ffd448a8a88 EFLAGS: 0206 ORIG_RAX: 00dd Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299498] RAX: ffda RBX: 0383 RCX: 7f7358c993c2 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299501] RDX: 2000 RSI: 099a RDI: 0389 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299503] RBP: 2000 R08: 0002 R09: Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299506] R10: 0003 R11: 0206 R12: 099a Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299508] R13: 0a10 R14: 01504cd0 R15: 7ffd448a8ad0 Jul 16 22:34:12 ec1-prd-postgresan-2 kernel: [ 1331.299514] Jul 16 22:36:13 ec1-prd-postgresan-2 kernel: [ 1452.119882] INFO: task postgres:1172 blocked for more than 241 seconds. Jul 16 22:36:13 ec1-prd-postgresan-2 kernel: [ 1452.122832] Not tainted 5.19.0-1028-aws #29~22.04.1-Ubuntu Jul 16 22:36:13 ec1-prd-postgresan-2 kernel: [ 1452.128443] "echo 0 > /proc/sys/kernel/hung_task_timeout_secs" disables this message. Jul 16 22:36:13 ec1-prd-postgresan-2 kernel: [ 1452.132098] task:postgres state:D stack:0 pid: 1172 ppid: 1133 flags:0x0004 Jul 16 22:36:13 ec1-prd-postgresan-2 kernel: [ 1452.132106] Call Trace: Jul 16 22:36:13 ec1-prd-postgresan-2 kernel: [ 1452.132109] Jul 16 22:36:13 ec1-prd-postgresan-2 kernel:
