I can't connect to instance of cloud sql via pgAdmin. It says connection timed out. I know this could be due to the port 5432 not opened on the firewall, but in the Cloud SQL instance there's no firewall tab…
I am trying to restore a .tar file in pgadmin 4. I created a new empty database exercises. Then clicked on exercises > create restore > select file path with data options as pre-data, data, post-data selected. While restoring it,…
I'm an SQL novice, I have a big data table with attributes exceeding 10000 columns which is hosted by CSV, and those columns come from multiple sites, I tried to import them into a database to manage them due to…
I am creating a function in postgres which is created but does not have the permissions to be accessed by the application. It is giving me WARNING: no privileges were granted for "public" I restarted with "open as administrator" option,…
Question seems identical to Can not connect to Postgres Container from pgAdmin but none of those solutions seem to be working, and I'm using slightly different tools... so maybe different problem? In my Docker Desktop (running Windows with a Linux…
I'm trying to add a postgres server to pgadmin4, through bash commands in a docker compose file. Here's my docker compose file: version: '3.9' services: podcast_db: image: postgres:15.3-alpine container_name: podcast_db ports: - 5432:5432 volumes: - podcast_db_data:/usr/share/podcast_db/data env_file: - ./database/.env.local.db #…
I have a table with year, area codes and each area code has 5 categories of age groups with people count as below. year areacode agegroup persons 2021 code 1 20-29 5 2021 code 2 30-39 11 2022 code 1…
I have a table like SR No Name Amount 1 Amount 2 Year 1 Crop1 1000 3000 2023 2 Crop2 2000 1000 2023 3 Crop3 5000 2500 2022 4 Crop4 1500 3500 2022 5 Crop5 3500 4500 2021 6 Crop6…
I need to get Financial Year Month(April to March) based on Year in Postgres Query... Like if passing 2022 then I need to get(12 month list) April-2022 to March-2023 month list. I have tried using EXTRACT() Function date to year…
I have PostgreSQL 9.6.23 on windows server 2019 i want to install PgAgent for scheduling backup and deletion of data PostgreSQL Stack Builder's doesn't have PgAgent like newer version How can i manually install it or if there is any…