search

microsoft / azuredatastudio-postgresql

azuredatastudio-postgresql is an extension for Azure Data Studio that enables you to work with PostgreSQL databases
Other
199 stars 37 forks source link

Can't see tables/columns #263

Open rrosendahlk opened 3 years ago

rrosendahlk commented 3 years ago

Issue Type: Bug

My company uses PostGres on AWS. Since we moved to AWS from Heroku, I can connect, run queries, and see some databases with tables and columns, but not our production DB. (When I click "Manage", a table list is shown.)

I was told the root cause is this: The problem is that the database that you have access to connect to is a semi random (d3m1d66l1kigms_analytics_pool) to prevent attackers from guessing the correct endpoint, but at the cluster level, the database name that contains data is named kajabi_products. Most clients handle this scenario without problem, but when Azure sees the kajabi_products database, it tries to establish a new connection to kajabi_products but we have it configured to not allow direct connections. So Azure throws the error Database not found: kajabi_products.

Azure Data Studio version: azuredatastudio 1.27.0 (765c7064d46253d88393e0e1ff78874b6fe8fa64, 2021-03-16T21:18:54.187Z) OS version: Darwin x64 20.3.0

System Info |Item|Value| |---|---| |CPUs|Intel(R) Core(TM) i7-9750H CPU @ 2.60GHz (12 x 2600)| |GPU Status|2d_canvas: enabled
flash_3d: enabled
flash_stage3d: enabled
flash_stage3d_baseline: enabled
gpu_compositing: enabled
metal: disabled_off
multiple_raster_threads: enabled_on
oop_rasterization: enabled
opengl: enabled_on
protected_video_decode: unavailable_off
rasterization: enabled
skia_renderer: disabled_off_ok
video_decode: enabled
webgl: enabled
webgl2: enabled| |Load (avg)|2, 2, 2| |Memory (System)|16.00GB (0.50GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|
Extensions (1) Extension|Author (truncated)|Version ---|---|--- azuredatastudio-postgresql|Mic|0.2.7
mksuni commented 3 years ago

@rrosendahlk I need more information here. Is the ask to allow to connect to Heroku database or is the ask to accept the GUID_DBName format here. Also which clients have you used where this has worked. Please provide more details to help us evaluate this scenario.

rrosendahlk commented 3 years ago

@mksuni We are off of Heroku now, so the ask is to be able to see the tables from AWS. I can run queries against AWS, but not see table info. As alternative, I have been using DBeaver which does show that information. (Sorry, I'm not a developer, so I can't speak to the GUID_DBName format here.) Happy to provide more details if needed.