Cockroach: improve dump feature

Wouter0100 commented 4 years ago

System information:

Operating system (distribution) and version: Ubuntu 20.04.1
DBeaver version: 7.2.0 EA (installed using deb file)
Additional extensions: N/A

Connection specification:

Database name and version: CockroachDB v19.2.2
Driver name: CockroachDB
Do you use tunnels or proxies (SSH, SOCKS, etc)?: Yes, SSH with SSL-based authentication.

Describe the problem you're observing:

I can't use Tools => Backup (and likely Tools => Restore, although not tested).

It results in pg_dump binary not found or when I install the pg_dump binary, it connects indefinitely. Also, pg_dump is officially not supported.

Steps to reproduce, if exist:

Have a CockroachDB server up-and-running and correctly configured within DBeaver over SSH. Then attempt to backup the database to a local sql file using Tools => Backup.

kseniiaguzeeva commented 4 years ago

Thank youfor the report.

vy-ton commented 4 years ago

@kseniiaguzeeva Hi, product manager for CockroachDB here. Just wanted to share that our backup statement will be available as part of Cockroach Core with the 20.2 release. You can check out example docs

backup should be used over cockroach dump

kseniiaguzeeva commented 4 years ago

@vy-ton thank you!

dbeaver / dbeaver