Forum Widgets
Latest Discussions
Connect to PostgreSQL in VS Code
G'day Developers! Are you looking for a way to streamline your workflow when working with PostgreSQL databases in VS Code, check out this blog on Connect to PostgreSQL in VS Code. With features like syntax highlighting, IntelliSense, and code snippets, as well as support for popular PostgreSQL commands, this extension makes it easy to write and manage queries directly within VS Code. Perfect for making the most of 𝗩𝗦 𝗖𝗼𝗱𝗲 𝗗𝗮𝘆 𝟮𝟬𝟮𝟯!
Any performance impact after enable Query Store feature in Azure PostgreSQL DB Server
Hi Team, We want to enable Query store in Azure PostgreSQL DB server for Intelligent Performance (Query Performance Insight and Performance Recommendations) feature. Before enable the feature, want to understand any performance impact on the PostgreSQL DB server if enable the feature. Can you please share if you have any insight on the performance impact. Thanks in advance. Thanks Shaban Khanazure data studio "postgres unhandled exception while executing query: 'list' object has no attribut
I am using azure data studio and getting below error when executing the query " select * from pg_catalog.pg_proc" error : "azure data studio "postgres unhandled exception while executing query: 'list' object has no attribute 'encode'" I dont see this error in pgadmin or any psql clientANNOUNCEMENT - Retiring Azure PostgreSQL Single Server in March 2025 and introducing Flexible Server
Microsoft Azure has announced that it will be retiring Azure Database for PostgreSQL - Single Server on March 28, 2025. Since the general availability of Azure Database for PostgreSQL - Single Server in Spring 2018, Microsoft has invested time and resources to develop it into an intelligent, scalable, and reliable database service that is best suited for running open-source PostgreSQL workloads at a lower cost than running them on-premises or on a virtual machine. In November 2021, Microsoft released the next generation deployment option in Azure Database for PostgreSQL - Flexible Server, which offers better price-performance, a simplified developer experience, and support for the latest PostgreSQL versions. HOW TO MIGRATE To help customers with the migration, Microsoft has released the general availability of the Single Server to Flexible Server migration tool. This tool ensures a simple and easy migration experience from Single Server to Flexible Server. When you migrate to Azure Database for PostgreSQL - Flexible Server, you will have access to several improvements. These include support for Postgres version 11,12,13,14 and newer, plus built-in security enhancements. There will also be better price-performance with support for burstable tier compute options. You can also expect improved uptime with the ability to configure a hot standby on the same or a different zone and user-controlled maintenance windows. Furthermore, there is a simplified developer experience for high-performance data workloads. Additional improvements include Linux-based VMs, premium managed disks, connection pooling with PgBouncer, and more. NEXT STEPS If you are currently using Azure Database for PostgreSQL - Single Server, it is recommended that you start planning your migration to Azure Database for PostgreSQL - Flexible Server. You can use the migration tool to make the process easier. We understand you may have a lot of questions about this announcement, so we have prepared a detailed Frequently Asked Questions, to help you plan migration.
Is Encoding SQL_ASCII and Collation en_US.1252 supported in Azure Flexible Server PostgreSQL?
Is encoding SQL_ASCII with Collation en_US.1252 supported in Azure FlexibleServer PostgreSQL? CREATE DATABASE databaseforme WITH ENCODING = 'SQL_ASCII' LC_COLLATE = 'en_US.1252' LC_CTYPE = 'en_US.1252' IS_TEMPLATE = False; I am trying to create the database but I am getting the error: ERROR: invalid locale name: "en_US.1252" SQL state: 42809
