Connect PgAdmin via SSH Google Cloud

0

Good, next folks. I have a server in the Google Cloud, and I installed the postgres and everything is ok, it's working beauty, there in my machine I installed pgAdmin III and I made the configuration to connect with the bank, initially it worked, then it stopped working, because my internet crashed and my IP has changed, and I had to make a rule in google's firewall releasing access to my IP, so I saw a problem here, because every time I change my IP, I'll have to change it in the firewall ..

I thought about making the connection via SSH, but I have no idea how to do this, I did not find tutorials or anything ..

Does anyone have any idea how to solve my problem?

Thank you

    
asked by anonymous 19.08.2017 / 04:27

1 answer

1

From what I've been reading in the google cloud documentation, you can do a release on the firewall by releasing a range of ips.

just for testing, release any ip on the postgresql port:

--network my-network \
--action allow \
--direction ingress \
--rules tcp:5432 \
--source-ranges 0.0.0.0/0 \
--priority 50 \

If you want to improve security, releasing only a known range, it would be better, for example, only the range that belongs to Brazil.

    
19.08.2017 / 04:46