rathoud96
I am trying to connect to a gcloud postgres instance from my application
this the config
config :hello, Hello.Repo,
username: System.get_env("POSTGRES_USER", "postgres"),
password: System.get_env("POSTGRES_PASSWORD", "postgres"),
database: "hello_dev",
hostname: "/cloudsql/<project_name>:<region>:<instance_name>,
pool_size: 10
but getting error non-existing domain
I tried to use socket in place of hostname but it’s not working
Thanks for the help.
Where Next?
Trending in Questions
Other Trending Topics
Latest Phoenix Threads
Latest on Elixir Forum
Sponsor Spotlight
Supporting innovation across the BEAM ecosystem.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #elixirconf
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #blog-post
- #phoenix_html
- #iex
- #graphql
- #genstage
- #ai
- #elixirconf-us
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #metaprogramming
- #security
- #hex
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Practical resources that improve the lives of professional developers.
Develop your skills with books, videos, and courses.
Producing high quality Elixir screencasts since 2017.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
First 10 of 13 Posts
dimitarvp
Well, what you specified as a hostname does not indeed look like a valid one.
Try
ping '/cloudsql/<project_name>:<region>:<instance_name>'in your terminal.Also you have a syntax error – at least here in the forum post, maybe not inside your config file – where you are missing a closing
"after the supposed hostname.rathoud96
the ping didn’t work. I tried to use external_ip instead of the instance name string. But getting connection timeout.
When I run cloud SQL proxy in local, can connect using localhost but I am looking for a way to connect without proxy
And the error was in the forum only.
BradS2S
Is your app and you db on the same instance? You probably want to try to internal IP in that case assuming they are at different addresses.
rathoud96
My db is runing on google cloud and i am deploying my application to google cloud run.
Now I have only external IP enbaled that can be used with cloud sql proxy.
So the right question would be how to connect the app in cloud run to the db instance with external IP
BradS2S
There’s a whole library that they provide to make that connect in Python, go and Java. Honestly I think your best bet is to enable an internal IP, put them on the same box (localhost) or use the external IP and figure out how to use the Unix socket option.
rathoud96
I tried to use the private IP using VPC connector. But getting the same connection error
followed this article connect to cloud sql
dimitarvp
Upon reading this again I realized I forgot to tell you that you should try to replace
hostnamewithsocket_dir.…Though judging by that Postgrex PR – by @hauleth – it seems that
hostnameshould work as well. Or I am reading it wrong, maybe the hostname support is only through specifying thePGHOSTvariable, not necessarily thehostnameconfig key.dimitarvp
One reference to a past thread: mix ecto.create and passwordless postgres - #2 by thomas.fortes
dimitarvp
Another person on the forum also pasted a CloudSQL config here: Preparing the production environment for deployment in GCP with Cloud SQL database
dimitarvp
…and another one: Ecto high database time with Cloud SQL - #3 by zatae