I see quite a few connections asking this, and answers range from using a Putty SSH tunnel to they plan on implementing this. However, I can not find any documents on if the connection string supports ssh port forwarding. Its because function test_ssh_connection does takes into account ssh options, and remote_command - doesnt. I do have PGAdmin successfully connecting to it because PGAdmin has a section to fill in the information to SSH tunnel. get_node_record(): SELECT id, type, upstream_node_id, name, conninfo, slot_name, priority, active FROM "repmgr_sortmaster".repl_nodes WHERE cluster = 'sortmaster' AND id = 2 remote node name is "test-docker2" test_ssh_connection(): executing ssh -o Batchmode=yes -o "StrictHostKe圜hecking no" -p 9022 test-docker2 /bin/true 2>/dev/null get_pg_setting(): SELECT name, setting FROM pg_settings WHERE name = 'data_directory' get_pg_setting(): returned value is "/var/lib/pgsql/9.5/data" master's data directory is: /var/lib/pgsql/9.5/data remote_command(): ssh -o Batchmode=yes test-docker2 ls /var/lib/pgsql/9.5/data/PG_VERSION >/dev/null 2>&1 & echo 1 || echo 0 remote_command(): output returned was: 0 /var/lib/pgsql/9.5/data is not a PostgreSQL data directory or is not accessible to user With -C, you will get a CREATE DATABASE command in the. In this case, you need to do the following: If you can only connect to your database from the host itself, you have to add the SSH logic from your MySQL example. Connects to a database under a specific user. The below table provides with the frequently used Psql commands: Command.
I'd especially like to point out the great documentation, and the well written C code. If the DB server takes database connections from your host (usually on port 5432), then you dont need to use SSH. In this article, we will look into some of the most frequently used Psql commands. I use custom port in ssh options (-p 9022), so i need them.ĭuring test of standby switchover i got this It implements an SSH client, and allows PG Commander to connect using SSH tunnels.
0 kommentar(er)
