Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

PG: foreign data wrappers configurator #6745

Closed
serge-rider opened this issue Sep 15, 2019 · 2 comments

Comments

@serge-rider
Copy link
Member

commented Sep 15, 2019

A wizard which will collect all virtual references to external databases and let user to configure FDW in PostgreSQL.
This wizard will generate SQL script which will:

  • Generate CREATE EXTENSION
  • Generate CREATE SERVER
  • Generate CREATE USER MAPPING
  • Generate CREATE FOREIGN TABLE(s)

It will allow to copy result script or to execute it.
It must take into consideration all available/installed extensions, available foreign wrappers.
It must support all (or as many as possible) known FDW plugins.

@serge-rider serge-rider added this to the 6.2.1 milestone Sep 15, 2019
@serge-rider serge-rider added this to Backlog in DBeaver project via automation Sep 15, 2019
serge-rider added a commit that referenced this issue Sep 15, 2019
@serge-rider serge-rider moved this from Backlog to In Progress in DBeaver project Sep 15, 2019
serge-rider added a commit that referenced this issue Sep 15, 2019
serge-rider added a commit that referenced this issue Sep 15, 2019
serge-rider added a commit that referenced this issue Sep 15, 2019
@serge-rider

This comment has been minimized.

Copy link
Member Author

commented Sep 15, 2019

Alpha version is ready.
Additions:

  • Check already mapped foreign tables
  • Add mapping script execution
  • Add "Copy script" button
  • Add extra foreign wrappers configs
  • Add table options (?)
@serge-rider serge-rider modified the milestones: 6.2.1, 6.2.2 Sep 24, 2019
@tati-kru tati-kru modified the milestones: 6.2.2, 6.2.3 Oct 7, 2019
serge-rider added a commit that referenced this issue Oct 8, 2019
serge-rider added a commit that referenced this issue Oct 8, 2019
…t handling). Show progress monitor in FDW wizard.
serge-rider added a commit that referenced this issue Oct 8, 2019
@serge-rider serge-rider moved this from In Progress to Ready for QA in DBeaver project Oct 8, 2019
@uslss uslss self-assigned this Oct 8, 2019
@uslss

This comment has been minimized.

Copy link
Collaborator

commented Oct 10, 2019

verified for clickouse - PostgreSQL

@uslss uslss closed this Oct 10, 2019
DBeaver project automation moved this from Ready for QA to Done Oct 10, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
3 participants
You can’t perform that action at this time.