search

MicrosoftDocs / azure-docs

Open source documentation of Microsoft Azure
https://docs.microsoft.com/azure
Creative Commons Attribution 4.0 International
10.24k stars 21.41k forks source link

postgres_fdw #52084

Closed screig closed 4 years ago

screig commented 4 years ago

"Currently, outbound connections from Azure Database for PostgreSQL aren't supported, except for connections to other Azure Database for PostgreSQL servers."

This is a bit vague, can I connect to postgresql db running on an azure VM, can I only connect to managed postgresql databases?

A demonstration of the networking steps that would be needed to enable to this would be helpful. For example what network settings need to be enabled on the target database to allow access from Citus?

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

NavtejSaini-MSFT commented 4 years ago

@screig Thanks for the feedback and we will get back to you as soon as possible.

NavtejSaini-MSFT commented 4 years ago

@screig For postgress_fdw you need to open up the source ranges (to internet). The port basesd opening up of NSG doesn't work. Ip address based whitlisting will be available once VNET feature is released, which is going to be in the coming months. (~3 months). Private preview will be kicked off in a couple of weeks.

NavtejSaini-MSFT commented 4 years ago

@screig Let us know if you need any help regarding this issue.

screig commented 4 years ago

Do you think you should amend the documentation to include this? It would be good if the documentation is complete, without the information above one cannot get the fdw plugin to work.

NavtejSaini-MSFT commented 4 years ago

@rachel-msft Please check this information can be added to the document.

NavtejSaini-MSFT commented 4 years ago

@jonels-msft Please check this document and see if this can be enhanced.

jonels-msft commented 4 years ago

Sorry, didn't get to it this week. I'll review this next week.

jonels-msft commented 4 years ago

Sorry for the delay. We're still investigating this to provide you with accurate information.

/cc @niklarin

jonels-msft commented 4 years ago

@screig we updated the dblink and postgres_fdw section. Do these changes make it clearer?

screig commented 4 years ago

I was expecting a bit more, eg some images click here, to do this, do that etc

But it's your docs

On Mon, 13 Jul 2020 at 20:53, Joe Nelson notifications@github.com wrote:

@screig https://github.com/screig we updated the dblink and postgres_fdw https://docs.microsoft.com/azure/postgresql/concepts-hyperscale-extensions#dblink-and-postgres_fdw section. Do these changes make it clearer?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/MicrosoftDocs/azure-docs/issues/52084#issuecomment-657758445, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABAX32RPG5ICFMZPN3OCSMLR3NQ3BANCNFSM4MEZG5BQ .

JasonWHowell commented 4 years ago

@screig thanks for posing the question, and for the followup discussion.

Images are expensive to maintain and don't localize well for all our global languages, so we'll stop here for now.

Thanks for the testing and confirmation @jonels-msft ~Jason

please-close