Related questions

Issues connecting from the Pgadmin4 QueryTool over a VPN connection

2018-10-11 19:13 gk64 imported from Stackoverflow

I upgraded from pgadmin III to pgadmin4. I have installed it on a Windows 10 environment and I use a chrome browser.

Sometimes I work remotely (over OpenVPN), previously with pgadmin III without problems.

Now I have a problem. Pgadmin4 is connecting (locally and remotely over VPN) OK to servers and databases, but, the QueryTool is not connecting (the problem happens only when trying to access over VPN, locally it connects). After starting the QueryToll, the connection symbol (upper left) is not marking a successful connection.

I guess this could be related to the route the QueryTool is taking in order to access the DB server or perhaps a timeout (my connection can be slow)? The Pgadmin4 interface in the browser connects without issues, only the QueryTool fails to do so. Any hints or ideas to solve or overcome this?

Thanks!

See also questions close to this topic

  • How to config csf with openvpn

    I'm using following iptables command in /etc/csf/csfpre.sh to allow openvpn. users can connect but csf rules not applied for them. for example all ports seems to be allowed! 

    #!/bin/bash
iptables -A FORWARD -m state --state RELATED,ESTABLISHED -j ACCEPT
iptables -A FORWARD -s 10.10.0.0/24 -j ACCEPT
iptables -A FORWARD -j REJECT
iptables -t nat -A POSTROUTING -s 10.10.0.0/24 -o eth1 -j MASQUERADE
iptables -t nat -A POSTROUTING -j SNAT --to-source 123.456.789.101
  • how to start and request via vpn on nodejs

    I am accessing different sites to fetch data using nodejs. But unfortunately some sites are blocked due to country restriction. Can I use vpn to solve this issue.

    How I can programmatically start a vpn and tell this particular request should go though that vpn on nodejs. Will openvpn or any other kind help me here.

  • How to configure VPN gateway in Digital Ocean?

    I need to create and configure VPN gateway on my Digital Ocean server, I have found an article 'How To Set Up an OpenVPN Server on Ubuntu 18.04'. Is it possible to create VPN gateway via Open VPN?

  • How to export table data from PostgreSQL (pgAdmin) to CSV file?

    I am using pgAdmin version 4.3 and i want to export one table data to CSV file. I used this query

    COPY (select * from product_template) TO 'D:\Product_template_Output.csv' DELIMITER ',' CSV HEADER;

    but it shows error

    a relative path is not allowed to use COPY to a file

    How can I resolve this problem any help please ?

  • Having issues in getting pgAdmin4 working on Amazon EC2

    I am trying to install pgadmin 4 on an RHEL 7.5 EC2 instance and get it working. I refered to following link for installation step -

    https://askubuntu.com/a/831263

    in config.py I have changed the DEFAULT_SERVER= my-instance-ip

    After executing the pgAdmin4.py script, it shows a message that tells me to navigate to http://my-instance-ip:5050

    However when I try to open the page it says 'This site can’t be reached' I have checked the security group, checked if the port 5050 is opened in the instance. Still it doesn't work.

    Am I doing something wrong?

    Thanks in advance.

  • Why does lag() function not giving correct output in pgAdmin4 and postgresql10.5

    Although this blog is 3 1/2 years old, I’d appreciate a clarification. This blog post EXACTLY explains a problem I am facing (and also provides an elegant answer).

    https://blog.jooq.org/2015/05/12/use-this-neat-window-function-trick-to-calculate-time-differences-in-a-time-series/

    So I copied the SQL syntax with my table name in pgAdmin 4, and added a new column also named ‘delta’ to my table and ran the query. However, the answer I got was nowhere near, Values in ‘delta’ is all zeros (00:00:00) and my equivalent column to ‘ts’ (I have a column called ‘utc_timestamp’ – formatted as ‘timestamp with time zone’ ) also shows different values – ‘2018-10-02′ 17:00:00-07’ instead of original value –> ‘2018-10-03 01:47:30-07’. My PostgreSQL version is 10.5 and did query in pgAdmin 4.

    The only difference I found was that the example column ‘ts’ has data type of ‘timestamp’ whereas my ‘utc_timestamp’ column has data type of ‘timestamp with timezone’

    This is the SQL I adapted from the blog and used pgAdmin 4 to run it:

    SELECT
utc_timestamp,
utc_timestamp 
    – lag(utc_timestamp, 1) OVER (ORDER BY utc_timestamp) delta
FROM newtable1
ORDER BY utc_timestamp;

    What am I doing wrong?