Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [ssh]

44 questions
12
votes
3 answers

pgAdmin 4: How to establish a connection through an SSH tunnel/interface in Windows

I installed the latest pgAdmin 4 (v2.1) but I found out that (related thread), for the moment, the only way to establish a connection through an SSH tunneling is using another outside process, an example in the pgAdmin's forum says: I setup a…
CPHPython
  • 339
  • 1
  • 3
  • 11
10
votes
1 answer

DBeaver: connecting to a PostgreSQL database server through SSH: can't initialize tunnel, auth fail

I am trying to use DBeaver to connect to a PostgreSQL database server through SSH: can't initialize tunnel cannot establish tunnel com.jcraft.jsch.JSchException: auth fail I am sure the SSH server is working fine. I manage to connect to the same…
Franck Dernoncourt
  • 2,083
  • 13
  • 34
  • 52
7
votes
2 answers

Will a mysql db import be interrupted if my ssh session times out?

I have a large-ish (several GB) mysql DB that I'm planning to import via mysql -u root -p mydb < mydb.sql in a SSH session. What would happen if my SSH connection drops? Is it safer to run something like nohup mysql -u root -p mydb < mydb.sql Or…
Mike B
  • 617
  • 4
  • 10
  • 17
6
votes
1 answer

pg_ctl hangs over ssh

I am designing a process to test my postgresql 10.8 backups by restoring them to a random point in time in a throwaway virtual machine. I have been unable to fully automate the process though. I am blocked at step 8 (section 25.3.4) of the official…
Peter Vandivier
  • 5,485
  • 1
  • 25
  • 49
5
votes
2 answers

MongoDB replica set over ssh tunnels

I'm trying to archive something like this The MongoDB instance on dc1.com is currently a standalone, and On-Site periodically pulls a backup via mongodump over a ssh tunnel. I now want to create two instances, one On-Site and one in a second…
Daniel F
  • 313
  • 3
  • 15
3
votes
1 answer

Connect to PostgreSQL via a ssh tunnel using Cygwin

I would like to connect to a Postgres server installed on a remote server using an ssh tunnel. I have Windows so I use cygwin for SSH. I do the following on cygwin: # Create the tunnel ssh -f user@remote_server -p ssh_port -L 5433:127.0.0.1:5432…
Michael
  • 163
  • 1
  • 7
3
votes
1 answer

PostgreSQL 10 - secure remote logical replication (SSH?)

I am exploring Postgresql for a new project, and the upcoming logical replication feature in version 10 interests me. I would like to use it to have a remote server automatically hold an up-to-date copy of some tables from a different server, across…
piaste
  • 131
  • 2
2
votes
0 answers

DBeaver connection via SSH tunnel

Using DBeaver, I'm trying to connect to my AWS ec2 instance where I've installed a MariaDB database. I've created a new connection as: Connection: AWS / Maria DB Server Host: localhost (because I'm using ssh to connect) Database, Username and…
Tommy
  • 121
  • 1
  • 2
2
votes
1 answer

Can't Connect to MySQL database through PuTTY

I have a database that runs on pythonanywhere.com, and am trying to connect Tableau to it, and need to set up an SSH Tunnel in order to do so. The directions on pythonanywhere's website mention PuTTY, and many people on Tableau forums also use it,…
Jonathan Bechtel
  • 29
  • 1
  • 4
2
votes
0 answers

Mariadb connection fails through tunnel when bind address = localhost

I have a MariaDB 10.1.26 virtual server running on Debian 9. It is connected to via ssh tunnel and the bind address = localhost. It has been working without fail untill recently. Now when I connect via ssh tunnel I get the error ERROR 2013 (HY000):…
Èl Sea
  • 21
  • 1
  • 3
2
votes
1 answer

how to 'flush hosts' via ssh

I have a MySQL db hosted on a commercial server as a shared account. Recently I have been getting an error: 'DBI connect('xxxxxx',...) failed: Host 'xxx.xxx.xxx.xxx' is blocked because of many connection errors; unblock with 'mysqladmin…
Amer Neely
  • 21
  • 1
2
votes
1 answer

Connection reset to SQL Server when using SSH Tunnel

I am trying to connect to an MS SQL Server database through DBeaver via an SSH tunnel but am getting the following error message when I "Test Connection...": I/O Error: Connection reset java.net.SocketException : Connection reset If I set…
yunque
  • 21
  • 1
  • 4
1
vote
0 answers

executing mariadb-dump with password over ssh

I need to make backups of the remote machine mariadb database. My plan is to run ssh user@remoteip 'mariadb-dump -uuser -ppass --all-databases' > backup.sql from my local machine. I found that remote machines history is not being populated with the…
sanjihan
  • 285
  • 1
  • 3
  • 10
1
vote
1 answer

How to backup clickhouse over SSH?

In postgreSQL, I usually run this command to backup and compress (since my country have really low bandwidth) from server to local: mkdir -p tmp/backup ssh sshuser@dbserver -p 22 "cd /tmp; pg_dump -U dbuser -Fc -C dbname | xz - -c" \ | pv -r -b >…
Kokizzu
  • 1,403
  • 6
  • 18
  • 35
1
vote
1 answer

How to transfer postgres databases from one server to other

VPS server has old Debian 6 Squeeze with Postgres 9.1 It has 24 databases. Every night backup copies are created using pg_dump to /root/backups directory for every database. This directory has 24 .backup files with total size 37 GB. I installed new…
Andrus
  • 123
  • 1
  • 4
1
2 3