Closed 3 days ago.

I have little knowledge about this. I have installed PostgreSQL via Cpanel for my site. It looks like I can access the database using the pgAdmin provided by Cpanel. However, I would like to connect to the database (running on my site) remotely using pgAdmin running on my local PC. I investigated and found some info at https://www.netiq.com/documentation/identity-manager-47/setup_windows/data/connecting-to-a-remote-postgresql-database.html but I am not sure where I can find postgresql.conf in the panel.

While registering a new server, and after using the

While registering a new server, and after using the

While registering a new server, and after using the

While registering a new server, and after using the

I am experiencing an issue when trying to open pgAdmin 4. When I attempt to launch the application, I receive an error message stating that ‘The pgAdmin 4 server could not be contacted.’ The error details mention a problem with the pgAdmin Runtime Environment, including references to Python paths, runtime configuration files, and environment variables. I’m not sure what is causing this issue or how to resolve it. Could you help me understand what might be wrong and suggest possible solutions to fix this problem?

I have two tables t1, t2 with similar columns, when i insert into t1, postgresql pgadmin 4 inserts the same data into t2, how to avoid this interaction?
thanks in advance

When I am using range_agg() function, it works fine with original table value

I have to create a query in postgress where I have 2 tables , 1) Request(caseID, quantity, amount)
2) Activity ( caseId , bookingtime ) so I want to create a query which should give me the data from both the table…caseId should be matched…and results columns are date, bookedquantity , amount ..i will pass startdate and enddate from request and it should match that with bookingtime and give me result..since same caseID can be multiple in both table so need data based on date only and so for particular date if two distinct caseId is available..their quantity and amount should get added with other row quantity and amount for particular date but distinct caseid…..i tried many queries but couldn’t get expected result. Plz anyone can suggest how can I achieve this.TIA.