Hello, just setup a pg for my account, several issues:
1) Tried to connect from external gui tool using ssh and instructions from a page I found where i used my PA credential for SSH, but connection is refused. Did someone manage to connect to pg from external tool ?
2) Tried to restore from console a dump I had with: pg_restore -U super -d mydb -1 /Users/ME/Downloads/20170126_092350.backup; Got error: ERROR: syntax error at or near "pg_restore" What is wront with my command ?
3) PG from PA is version 9.4.X, the backup is from 9.6.X. Is a restore even possible at all ?
Thanks, Ben