# \#postgres **URL:** https://community.grafana.com/tag/postgres/5.md [Latest](https://community.grafana.com/latest.md) · [Categories](https://community.grafana.com/categories.md) · [Tags](https://community.grafana.com/tags.md) --- ## [Query on variables to select all column](https://community.grafana.com/t/query-on-variables-to-select-all-column/59738)
**Author:** [@dtorobay](https://community.grafana.com/u/dtorobay)\ **Replies:** 3\ **Last updated:** [June 24, 2025, 2:22pm UTC](https://community.grafana.com/t/query-on-variables-to-select-all-column/59738 "2025-06-24T14:22:06Z")
I´m trying to create a query based on Postgresql creating a variable that should select all values from the chosen column (temperature, turbidity, dissolved O2, etc ). Is there somekind of example in that case? --- ## [Dial tcp 127.0.0.1:5432: connect: connection refused](https://community.grafana.com/t/dial-tcp-127-0-0-1-connect-connection-refused/13071)
**Author:** [@deeja](https://community.grafana.com/u/deeja)\ **Replies:** 19\ **Last updated:** [May 19, 2025, 12:28pm UTC](https://community.grafana.com/t/dial-tcp-127-0-0-1-connect-connection-refused/13071 "2025-05-19T12:28:27Z")
I am trying to connect Postrgre with following setting: localhost:5432 Database: database\_1 User: postgres pwd: SSL Mode: disable and getting following error: dial tcp 127.0.0.1:5432: connect: connection refused Ca… --- ## [Inner join transform in mixed data source pick only one joined row](https://community.grafana.com/t/inner-join-transform-in-mixed-data-source-pick-only-one-joined-row/86290)
**Author:** [@mir1198yusuf](https://community.grafana.com/u/mir1198yusuf)\ **Replies:** 11\ **Last updated:** [May 17, 2025, 11:40am UTC](https://community.grafana.com/t/inner-join-transform-in-mixed-data-source-pick-only-one-joined-row/86290 "2025-05-17T11:40:29Z")
I am using Mixed data sources I used two postgres databases Created two queries In transform section, used Join by field =\> Mode as Inner join but it is returning only one row instead of many-to-many join Query1 res… --- ## [How to autozoom graph to data?](https://community.grafana.com/t/how-to-autozoom-graph-to-data/60726)
**Author:** [@szlaurjakub](https://community.grafana.com/u/szlaurjakub)\ **Replies:** 14\ **Last updated:** [March 26, 2025, 2:03am UTC](https://community.grafana.com/t/how-to-autozoom-graph-to-data/60726 "2025-03-26T02:03:58Z")
Hello everyone, pretty new to Grafana with PostgresSQL and so far I love it! I will be presetting to our company the capabilities of Grafana next week and proposing to switching onto this platform - but I need help with … --- ## [How can I show a dynamic amount of graphs?](https://community.grafana.com/t/how-can-i-show-a-dynamic-amount-of-graphs/57220)
**Author:** [@sharkyenergy](https://community.grafana.com/u/sharkyenergy)\ **Replies:** 2\ **Last updated:** [December 5, 2024, 6:59pm UTC](https://community.grafana.com/t/how-can-i-show-a-dynamic-amount-of-graphs/57220 "2024-12-05T18:59:44Z")
Hi all! I am having difficulties in setting up a dashboard. I do have a generic query that returns a variable amount of rows. With the result of this query, with every row, I generate a new query that returns the data … --- ## [Can we add two data sources in the same panel](https://community.grafana.com/t/can-we-add-two-data-sources-in-the-same-panel/71577)
**Author:** [@chembakayalabharath](https://community.grafana.com/u/chembakayalabharath)\ **Replies:** 6\ **Last updated:** [November 7, 2024, 4:56pm UTC](https://community.grafana.com/t/can-we-add-two-data-sources-in-the-same-panel/71577 "2024-11-07T16:56:33Z")
Hello All, I have two data sources Prometheus and Postgres. I want to access these two data sources in a single dashboard. I added multiple data sources and displayed these two data sources in a table using the common c… --- ## [Connection failed: Query failed. Please inspect Grafana server log for details](https://community.grafana.com/t/connection-failed-query-failed-please-inspect-grafana-server-log-for-details/35436)
**Author:** [@assia](https://community.grafana.com/u/assia)\ **Replies:** 4\ **Last updated:** [August 26, 2024, 5:02pm UTC](https://community.grafana.com/t/connection-failed-query-failed-please-inspect-grafana-server-log-for-details/35436 "2024-08-26T17:02:06Z")
avez vous des solutions pour cette erreurs, svp! --- ## [Grafana MySQL -\> PostgreSQL migration](https://community.grafana.com/t/grafana-mysql-postgresql-migration/62180)
**Author:** [@znpy](https://community.grafana.com/u/znpy)\ **Replies:** 11\ **Last updated:** [August 19, 2024, 11:28pm UTC](https://community.grafana.com/t/grafana-mysql-postgresql-migration/62180 "2024-08-19T23:28:29Z")
Hello there! For operational reasons we would like to move our Grafana installation from a MySQL database to a PostgreSQL database. Does anybody know what’s the best way to approach this task? I was wondering if there… --- ## [Postgresql time-out issue](https://community.grafana.com/t/postgresql-time-out-issue/6644)
**Author:** [@gapvision](https://community.grafana.com/u/gapvision)\ **Replies:** 7\ **Last updated:** [August 8, 2024, 6:47pm UTC](https://community.grafana.com/t/postgresql-time-out-issue/6644 "2024-08-08T18:47:18Z")
Hello, I recently started to use a postgresql datasource in my Grafana dashboards. Unfortunately it seems to run into some timeout issue for more complex queries after approx. 1 minute (“request error” without further de… --- ## [How can I change graph X-axis to show days of the week(Monday, Tuesday, Wednesday etc)](https://community.grafana.com/t/how-can-i-change-graph-x-axis-to-show-days-of-the-week-monday-tuesday-wednesday-etc/60813)
**Author:** [@nivekc](https://community.grafana.com/u/nivekc)\ **Replies:** 17\ **Last updated:** [July 3, 2024, 7:23am UTC](https://community.grafana.com/t/how-can-i-change-graph-x-axis-to-show-days-of-the-week-monday-tuesday-wednesday-etc/60813 "2024-07-03T07:23:38Z")
I wanted to change how the x-axis is displayed. Change the way the dates are displayed in dd/mm/time to just the day of the week --- ## [Table Panel Columns to Rows](https://community.grafana.com/t/table-panel-columns-to-rows/30201)
**Author:** [@etherionchy](https://community.grafana.com/u/etherionchy)\ **Replies:** 8\ **Last updated:** [June 7, 2024, 10:23am UTC](https://community.grafana.com/t/table-panel-columns-to-rows/30201 "2024-06-07T10:23:05Z")
Hi All, Managed to queried this: With this query: SELECT patchsession, count(\*) as Baseline, COUNT (\*) filter(where exempted='SKIP\_L2\_APPROVAL') AS SKIP\_L2\_APPROVAL from patchtracking P, cycle C where C.cyclename=$… --- ## [How to group time with custom timezone other than UTC?](https://community.grafana.com/t/how-to-group-time-with-custom-timezone-other-than-utc/11445)
**Author:** [@leonvking0](https://community.grafana.com/u/leonvking0)\ **Replies:** 3\ **Last updated:** [May 17, 2024, 10:08am UTC](https://community.grafana.com/t/how-to-group-time-with-custom-timezone-other-than-utc/11445 "2024-05-17T10:08:24Z")
I am using postgresql as datasource and there are some metrics I need to compute over a 24h window. For example: SELECT $\_\_timeGroup(created\_on,24h), count(\_id) AS "number of reviews" FROM product\_reviews WHERE $… --- ## [Pq: syntax error with postgres - how to see the query?](https://community.grafana.com/t/pq-syntax-error-with-postgres-how-to-see-the-query/60734)
**Author:** [@danielt290947](https://community.grafana.com/u/danielt290947)\ **Replies:** 2\ **Last updated:** [January 23, 2024, 6:27pm UTC](https://community.grafana.com/t/pq-syntax-error-with-postgres-how-to-see-the-query/60734 "2024-01-23T18:27:44Z")
Inspect-query does not show query when causing syntax error, neither log level debug Using Grafana 7.3.1 with Postgresql. I really love the inspect - query function because I can right away post it in pgadmin. However t… --- ## [Db query error : pq: kerberos error: no GSSAPI provider registered (import github.com/lib/pq/auth/kerberos if you need Kerberos support)](https://community.grafana.com/t/db-query-error-pq-kerberos-error-no-gssapi-provider-registered-import-github-com-lib-pq-auth-kerberos-if-you-need-kerberos-support/58701)
**Author:** [@rakeshbshukla](https://community.grafana.com/u/rakeshbshukla)\ **Replies:** 2\ **Last updated:** [January 11, 2024, 12:02am UTC](https://community.grafana.com/t/db-query-error-pq-kerberos-error-no-gssapi-provider-registered-import-github-com-lib-pq-auth-kerberos-if-you-need-kerberos-support/58701 "2024-01-11T00:02:28Z")
Hi, While configuring postgres datasource i am getting error "kerberos error: no GSSAPI provider registered (import github.com/lib/pq/auth/kerberos if you need Kerberos support) ". Any solution to this problem if i can… --- ## [Grafana is adding time to my date column](https://community.grafana.com/t/grafana-is-adding-time-to-my-date-column/59873)
**Author:** [@grosjambon33000](https://community.grafana.com/u/grosjambon33000)\ **Replies:** 6\ **Last updated:** [January 5, 2024, 3:47pm UTC](https://community.grafana.com/t/grafana-is-adding-time-to-my-date-column/59873 "2024-01-05T15:47:20Z")
Hello everyone, What Grafana version and what operating system are you using? Grafana 8.3.4 Debian 11 What are you trying to achieve? Create a table with a postgresql query What happened? i’m using t… --- ## [Link to dashboards with different uids based on column value](https://community.grafana.com/t/link-to-dashboards-with-different-uids-based-on-column-value/22561)
**Author:** [@adrianmih](https://community.grafana.com/u/adrianmih)\ **Replies:** 1\ **Last updated:** [December 13, 2023, 2:04am UTC](https://community.grafana.com/t/link-to-dashboards-with-different-uids-based-on-column-value/22561 "2023-12-13T02:04:03Z")
Hi guys, I’m trying to create a dashboard link based on the value of the column, but the trick here is that ${\_\_cell} won’t work because, there’s a different dashboard for each value. There are 4 nodes: And each of… --- ## [How to use plotly panel in Grafana?](https://community.grafana.com/t/how-to-use-plotly-panel-in-grafana/87948)
**Author:** [@abhinavanandpnbe](https://community.grafana.com/u/abhinavanandpnbe)\ **Replies:** 3\ **Last updated:** [November 23, 2023, 9:17pm UTC](https://community.grafana.com/t/how-to-use-plotly-panel-in-grafana/87948 "2023-11-23T21:17:31Z")
My data source is Postgres and my query returns columns min,max,mean,std,q1,median and q3. Now how do I plot these data as Box Plot using plotly panel. --- ## [Navigating to another dashboard through external data links pointing to field name](https://community.grafana.com/t/navigating-to-another-dashboard-through-external-data-links-pointing-to-field-name/35258)
**Author:** [@anbu16aras](https://community.grafana.com/u/anbu16aras)\ **Replies:** 2\ **Last updated:** [October 9, 2023, 7:38am UTC](https://community.grafana.com/t/navigating-to-another-dashboard-through-external-data-links-pointing-to-field-name/35258 "2023-10-09T07:38:42Z")
Hi Guys, I have created stacked bar graph by configuring postgres as datasource. I’m trying to drill down from parent dashboard to child dashboard. In parent dashboard provided the external data links. In the data lin… --- ## [Convert UNIX date time to datetime](https://community.grafana.com/t/convert-unix-date-time-to-datetime/67617)
**Author:** [@km1729](https://community.grafana.com/u/km1729)\ **Replies:** 2\ **Last updated:** [September 22, 2023, 12:12am UTC](https://community.grafana.com/t/convert-unix-date-time-to-datetime/67617 "2023-09-22T00:12:27Z")
Hi, I am trying to create a date query variable from a table. The data column in the table is stored as the DateTime type, but when I run the query in the variable page it returns the Unix time stamp format. The same … --- ## [Not able to connect to postgreSQL database (Timescale Cloud) when using Grafana in Windows](https://community.grafana.com/t/not-able-to-connect-to-postgresql-database-timescale-cloud-when-using-grafana-in-windows/62690)
**Author:** [@benkku](https://community.grafana.com/u/benkku)\ **Replies:** 2\ **Last updated:** [August 30, 2023, 8:07am UTC](https://community.grafana.com/t/not-able-to-connect-to-postgresql-database-timescale-cloud-when-using-grafana-in-windows/62690 "2023-08-30T08:07:01Z")
I have installed Grafana 8.4.4. Enterprise in Windows 10 Pro and I am trying to connect to a Timescale database (postgreSQL). First I tried to connect to Timescale Cloud (Managed Service for TimescaleDB), which uses Tim… --- ## [Grafana prometheus "why my prometheus can't display postgresql data"](https://community.grafana.com/t/grafana-prometheus-why-my-prometheus-cant-display-postgresql-data/100089)
**Author:** [@akunfbcein519](https://community.grafana.com/u/akunfbcein519)\ **Replies:** 1\ **Last updated:** [August 7, 2023, 10:24am UTC](https://community.grafana.com/t/grafana-prometheus-why-my-prometheus-cant-display-postgresql-data/100089 "2023-08-07T10:24:13Z")
why my prometheus can’t display postgresql data. THANK YOU!! --- ## [Delay in Grafana dashboard with Zabbix data](https://community.grafana.com/t/delay-in-grafana-dashboard-with-zabbix-data/42345)
**Author:** [@eyalcohenm](https://community.grafana.com/u/eyalcohenm)\ **Replies:** 5\ **Last updated:** [July 13, 2023, 6:41am UTC](https://community.grafana.com/t/delay-in-grafana-dashboard-with-zabbix-data/42345 "2023-07-13T06:41:55Z")
Hello, I have Zabbix installed and working with postgras sql. I have the grafana working with the Zabbix API server queries and its working fine. My problem there is a 5 minutes delay between what Zabbix poll to what … --- ## [Can we set value of min max in gauge plugin by using query from grafana query tab?](https://community.grafana.com/t/can-we-set-value-of-min-max-in-gauge-plugin-by-using-query-from-grafana-query-tab/26488)
**Author:** [@nishasalawat](https://community.grafana.com/u/nishasalawat)\ **Replies:** 2\ **Last updated:** [June 13, 2023, 12:30pm UTC](https://community.grafana.com/t/can-we-set-value-of-min-max-in-gauge-plugin-by-using-query-from-grafana-query-tab/26488 "2023-06-13T12:30:59Z")
Can we change the value of Max and Min field of grafana gauge plugin editor by a Query which is written on the grafana query tab? In the below image see the min and max field in the editor of the gauge plugin. Image… --- ## [Newbie question - Base search query to use for multiple visualizations in a dashboard](https://community.grafana.com/t/newbie-question-base-search-query-to-use-for-multiple-visualizations-in-a-dashboard/88851)
**Author:** [@hakunamattata](https://community.grafana.com/u/hakunamattata)\ **Replies:** 1\ **Last updated:** [June 7, 2023, 8:38pm UTC](https://community.grafana.com/t/newbie-question-base-search-query-to-use-for-multiple-visualizations-in-a-dashboard/88851 "2023-06-07T20:38:34Z")
I am new to Grafana and any learning help will be truly appreciated. This might be a very basic question, I have some data in a Postgres database and need pointers on how to build a dashboard based on the criteria listed… --- ## [How to have duplicate values ( '\_\_value') in same variable?](https://community.grafana.com/t/how-to-have-duplicate-values-value-in-same-variable/58008)
**Author:** [@kon3dos](https://community.grafana.com/u/kon3dos)\ **Replies:** 1\ **Last updated:** [May 15, 2023, 8:30am UTC](https://community.grafana.com/t/how-to-have-duplicate-values-value-in-same-variable/58008 "2023-05-15T08:30:10Z")
What Grafana version and what operating system are you using? v8.0.1, Ubuntu What are you trying to achieve? Have a variable with duplicate values. Hi everyone, I have a variable with the following query: SEL… --- ## [Grafana HA -PostgreSQL HA implementation on Linux](https://community.grafana.com/t/grafana-ha-postgresql-ha-implementation-on-linux/58691)
**Author:** [@ravivishpln](https://community.grafana.com/u/ravivishpln)\ **Replies:** 3\ **Last updated:** [April 14, 2023, 9:31pm UTC](https://community.grafana.com/t/grafana-ha-postgresql-ha-implementation-on-linux/58691 "2023-04-14T21:31:25Z")
This is regarding the Grafana HA -PostgreSQL HA implementation. I am trying to use the repmgr (Replication Manager) for automatic failover in PostgreSQL HA for Grafana . repmgr is working as expected that once primary s… --- ## [How to display two tables in one panel](https://community.grafana.com/t/how-to-display-two-tables-in-one-panel/85027)
**Author:** [@zahrazare313](https://community.grafana.com/u/zahrazare313)\ **Replies:** 6\ **Last updated:** [April 10, 2023, 9:38am UTC](https://community.grafana.com/t/how-to-display-two-tables-in-one-panel/85027 "2023-04-10T09:38:47Z")
I want to make two completely different queries to Postgres in Grafana six, and the output of these two queries will be two completely different tables. But I want to finally display both of these tables in one panel! in… --- ## [State Timeline schema](https://community.grafana.com/t/state-timeline-schema/49652)
**Author:** [@rotario](https://community.grafana.com/u/rotario)\ **Replies:** 14\ **Last updated:** [March 28, 2023, 7:23am UTC](https://community.grafana.com/t/state-timeline-schema/49652 "2023-03-28T07:23:54Z")
What Grafana version and what operating system are you using? 8.0.3, ubuntu 20.04 What are you trying to achieve? Get the schema right to display the state timeline for different devices correctly How are you t… --- ## [Dynamic Display name for plot](https://community.grafana.com/t/dynamic-display-name-for-plot/83699)
**Author:** [@derwolferl](https://community.grafana.com/u/derwolferl)\ **Replies:** 0\ **Last updated:** [March 13, 2023, 3:50pm UTC](https://community.grafana.com/t/dynamic-display-name-for-plot/83699 "2023-03-13T15:50:10Z")
I have a Time Series Plot consiting of multiple line graphs. I want to give every line a different name which I am currently doing with the aliases in my SQL-Select statements. My problem is, that every graph should ha… --- ## [A complex graph](https://community.grafana.com/t/a-complex-graph/83082)
**Author:** [@pavlevidanovic](https://community.grafana.com/u/pavlevidanovic)\ **Replies:** 11\ **Last updated:** [March 8, 2023, 9:05am UTC](https://community.grafana.com/t/a-complex-graph/83082 "2023-03-08T09:05:56Z")
I’m using the latest version of Grafana. I’m working on a timeseries, and there is a variable(integer) that is supposed to do something like this (this is from matplotlib): The integer is a column in a database, if … [Next page](https://community.grafana.com/tag/postgres/5.md?match_all_tags=true&page=1&tags%5B%5D=postgres)