No announcements
-
0 VotesPostgreSQL with PostgREST
Does anyone know if you can run PostgREST in an Azure PostgreSQL instance?Proposed | 2 Replies | 218 Views | Created by James Studdart - Saturday, December 21, 2019 9:07 PM | Last reply by NavtejSaini-MSFT - Thursday, December 26, 2019 4:18 PM
-
0 Votes
could not connect to server "postgres_someDB"
Working on Azure PostGresSQL, trying to import a table present in another database of postgres from a diferrent database. bBoth the databases are on same ...Unanswered | 5 Replies | 316 Views | Created by Aravindmandapaka - Thursday, December 5, 2019 11:57 PM | Last reply by Kalyan Chanumolu-MSFT - Friday, December 20, 2019 2:38 AM -
0 Votes
Scaling out Hypercale Citus Postgresql vCores Issues
According to the documentation ( https://docs.microsoft.com/en-us/azure/postgresql/howto-hyperscale-scaling ) We can increase vCores or storage space (after server deployment) by ...Answered | 1 Replies | 124 Views | Created by Solidhadriel - Monday, December 16, 2019 6:44 PM | Last reply by NavtejSaini-MSFT - Monday, December 16, 2019 8:37 PM -
0 Votes
PG::ConnectionBad: could not connect to server: No such file or directory precompilation failed Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?
I am trying to deploy Ruby on Rails app on Azure app service on Linux through Local git deployment method. But the deployment fails with the following ...Proposed | 1 Replies | 216 Views | Created by Viren Dhanwani - Wednesday, December 4, 2019 6:57 AM | Last reply by Mike Ubezzi (Azure) - Thursday, December 5, 2019 6:49 PM -
0 Votes
How to replicate postgresql table view to another postgresql ?
I am using Azure database for PostgreSQL and also have PostgresQL on a separate docker container. My goal is to replicate table view from ...Proposed | 3 Replies | 245 Views | Created by Yu Watanabe-CL - Monday, November 25, 2019 5:46 AM | Last reply by Mike Ubezzi (Azure) - Tuesday, November 26, 2019 5:45 PM -
0 Votes
High login latency
Using my application (with micro-services approach with Kubernetes) I realise it has a problem with long responses. We have 7 micro-services at the moment. On one page we have list of products with ...Proposed | 8 Replies | 941 Views | Created by Piotr Sobieszczański - Thursday, July 25, 2019 9:45 AM | Last reply by Mike Ubezzi (Azure) - Tuesday, November 26, 2019 12:00 AM -
0 Votes
Query Performance Insight - don't see my queries?
Hi, I'm testing the service - Azure Database for PostgreSQL servers - - and have a question about Query Performance Insight. I'm ...Proposed | 10 Replies | 487 Views | Created by Gustaw_ - Wednesday, November 13, 2019 2:12 PM | Last reply by Mike Ubezzi (Azure) - Thursday, November 21, 2019 8:19 PM -
0 Votes
azure database postgresql sync on premises advice
Hi, Any advices/solution to synchronize read only on premises (express route) postgresql servers from an azure managed database ...Proposed | 1 Replies | 297 Views | Created by Erichof - Saturday, November 9, 2019 10:11 AM | Last reply by Kalyan Chanumolu-MSFT - Monday, November 11, 2019 12:18 PM -
0 Votes
Cant connect to existing database with LC_COLLATE = 'Czech_Czech Republic.1250'
After this nigh 23.10.2020 Cant connect to existing database with LC_COLLATE = 'Czech_Czech Republic.1250'. FATAL: database locale is incompatible with operating ...Proposed | 3 Replies | 318 Views | Created by RadekPod - Thursday, October 24, 2019 8:01 AM | Last reply by Kalyan Chanumolu-MSFT - Tuesday, November 5, 2019 9:46 AM -
0 Votes
100% CPU utility without query load
Hi, Looking at the Azure Database for PostgreSQL server I noticed that in the Overview the CPU usage always appears to be 100% even though there is no query load. Is this a ...Proposed | 3 Replies | 340 Views | Created by Dirk03 - Monday, October 21, 2019 11:34 AM | Last reply by Mike Ubezzi (Azure) - Wednesday, October 23, 2019 5:29 PM -
1 Votes
Very High Latency With Azure Database For Postgres
Hi, I am expreincing very very high latency with postgres. I have a VM running on Azure West Europe and the DB set up in West Europe as ...Proposed | 7 Replies | 2862 Views | Created by Tom.f - Thursday, July 13, 2017 8:53 AM | Last reply by Mike Ubezzi (Azure) - Friday, October 18, 2019 12:29 AM -
0 Votes
Calling plv8 procedures with jsonb containing arrays of objects loses all but the last object of the array.
Calling the below plv8 function CREATE FUNCTION plv8_test(inp jsonb) RETURNS jsonb AS $$ return inp.Arr.length; $$ LANGUAGE plv8 IMMUTABLE ...Answered | 6 Replies | 513 Views | Created by Chris Jansson - Thursday, September 26, 2019 1:08 PM | Last reply by Mike Ubezzi (Azure) - Monday, October 14, 2019 7:28 PM -
0 Votes
Query Azure PostgresSQL though REST API
Hi, Do we have any method to query the Azure PostgreSql though REST API. We have created an PostgreSql in azure cloud and we do not want to ...Proposed | 2 Replies | 310 Views | Created by Nagesh Bandaru - Thursday, October 10, 2019 11:16 AM | Last reply by Kalyan Chanumolu-MSFT - Monday, October 14, 2019 5:43 AM -
0 Votes
Will the timescale extension be upgraded to the latest version?
Hi, I wonder if and when the timescale extension will be upgraded to a newer version. The latest timescale version have a lot of new functionality which is ...Proposed | 2 Replies | 388 Views | Created by Frank F H - Thursday, October 3, 2019 7:05 PM | Last reply by NavtejSaini-MSFT - Saturday, October 5, 2019 2:38 AM -
1 Votes
Increasing space allocated for log files
Hi, I am trying to find the place to be able to increase the amount of log file space allocated for "Server Log storage limit". It is currently 1GiB. ...Answered | 5 Replies | 501 Views | Created by N_J_Harris - Thursday, September 26, 2019 1:12 PM | Last reply by NavtejSaini-MSFT - Wednesday, October 2, 2019 3:16 PM -
0 Votes
Allow access without vnet-rule after restore
\q $ az postgres server vnet-rule create --name my_vnet_rule --resource-group testg--server-name adpg4 --subnet default --vnet-name "testg-vnet" { ...Proposed | 3 Replies | 457 Views | Created by harukat - Thursday, September 19, 2019 1:28 AM | Last reply by Mike Ubezzi (Azure) - Tuesday, September 24, 2019 1:29 AM -
0 Votes
Long Term Retention for Azure Database for PostgreSQL
Hi Guys, What is LTR plan for azure postgresql DB. We have 10 years of LTR for Azure SQL Database. I dont see a similar option for azure postgresql DB. I have 1 ...Proposed | 2 Replies | 479 Views | Created by udhayan - Thursday, August 29, 2019 7:29 PM | Last reply by udhayan - Thursday, September 5, 2019 7:03 PM -
0 Votes
Azure DB for Postgres connection string returns null when connection string type set to PostgreSQL
(This seems to be more of an App Service issue, but @AzureSupport sent me here. Please move to the appropriate forum if needed.) I have an App Service that connects to an Azure ...Proposed | 4 Replies | 656 Views | Created by Jon Sagara - Monday, August 19, 2019 5:14 PM | Last reply by Mike Ubezzi (Azure) - Wednesday, August 28, 2019 6:02 PM -
0 Votes
How do I import some records from my Azure MSSQL db to my Azure Postgres DB?
I need to run some cross db queries from my Azure Postgres to my Azure MSSQL DB. How do I do that? I noticed there is a tds_fdw extension available on github but ...Answered | 2 Replies | 491 Views | Created by Nazneen - Monday, August 19, 2019 9:15 PM | Last reply by Nazneen - Monday, August 19, 2019 11:29 PM -
0 Votes
Error With Postgres Function in DevOps Pipline
I'm getting the following error when trying to process a Postgres function in a DevOps Pipeline. The function compiles and works correctly when I run it PgAdmin4. It fails at this ...Answered | 1 Replies | 432 Views | Created by Jamesp99 - Tuesday, August 13, 2019 1:25 PM | Last reply by Jamesp99 - Tuesday, August 13, 2019 3:24 PM - Items 1 to 20 of 132 Next ›
No announcements
