I'm really puzzled by the following query: explain analyze (with z as ( select 1 as attraction ,1 as nd_attraction , n.fc from (select pe_id,zo_id,co_id,value_num as dt from rtpezocoav x --use view?? where pe_id = 405 and ad_id = 4…
Background I have a PgPool-II cluster (ver 4.1.4) running on 3 centos 8 machines (virtual); SQL1, SQL2 and SQL3 (each on different hardware). On SQL1 and SQL2 PostgreSQL-12 are running (currently SQL1 is master and SQL2 in streaming replication standby).…
I have this sample data: ID Name 1 {'a':'content1'} 1 {'b':'content1'} 1 {'c':'content2'} 1 {'d':'content2'} 1 {'e':'content3'} 1 {'f':'content3'} 2 ['content4'] 2 ['content4'] 2 ['content5'] 2 ['content5'] with ID : INT Name : JSON I want to have this result…
I've been battling with this issue for the last 4 days of my life and it's driving me crazy. I'm trying to deploy a service that uses a postgres DB in RHEL 8. In order to do so, I'm deploying…
I'm doing the same steps as described in: https://medium.com/better-programming/connect-from-local-machine-to-postgresql-docker-container-f785f00461a7 but when I try to connect to my postgres (with password mysecretpassword) from Intellij I get the following error: The specified database user/password combination is rejected: [28P01] FATAL: password authentication failed…
As referenced here: https://postgreshelp.com/postgresql-checkpoint And in the pg docs https://www.postgresql.org/docs/9.5/contrib-prog.html => https://www.postgresql.org/docs/9.5/contrib-prog-client.html => https://www.postgresql.org/docs/9.5/oid2name.html it appears to be something to do with contrib. I am running server version 9.5.20 psql version 8.4.20 on centos 6.7 I have installed (I think)…
Good day I am trying to send a Ajax post request with jquery. For this purpose I use a bootstrap modal to grab data and send to PostgreSQL DB. Data is referred to rendered section using EJS. So in the…
I have a problem with a postgresql database which slow down when some requests are done on old rarely used data. This database contains data on appointments, messages, etc. Everything is dated, and requests are mostly for current and future…
I'm trying to create my own function (using C) in postgres for which I'm referring this doc: http://www.linuxgazette.cz/139/peterson.html For compiling - I'm referring: Section 33.9.6 . But, when I run below command: cc -fpic -c example.c I get this error:…
I know that it is a typical issue, however I need a community help to resolve it. When I run docker-compose I get Connection refused: Is the server running on host "db" (172.21.0.2) and accepting web_1 TCP/IP connections on port…