Private Networking
I'm trying to deploy Plausible Analytics via a Docker image, and have both that and Postgres installed in an environment. I tried to deploy a Clickhouse DB via Docker Image, but to no avail. I did find this template, https://railway.app/template/clickhouse, but I can't figure out how to get the URL from that and reference it in an ENV in the Plausible service.
Would this have something to do with private networking? I've tried opening PN on the Clickhouse DB and referencing it (clickhouse.railway.internal) as
CLICKHOUSE_DATABASE_URL
in Plausible, but its saying that it's an invalid URL. Do I have to put a port or protocol in front of it? (CH is running on port 8123)15 Replies
Project ID:
3c03fc13-00d0-40a1-a011-5a52903a095b
3c03fc13-00d0-40a1-a011-5a52903a095b
Apologies if this is confusing
yes internal domains need to be called with a port specified, they may have a pretty domain, but they are still internal after all
would I have to put the protocol?
http/https ?
for good measure why not, this is internal, and internally your app listens on http
alright
yeah because I put the port and its still complaining
your service also needs to be listening on [::], since the private networking is ipv6 only
alright, thanks
@Brody I'm being told to add a column to my Postgres with a TIMESTAMP datatype, but the only one I see is Data, and it rejects that
How can I do this, or is it not possible?
"Postgrex expected %Date{}, got ~U[2023-07-20 18:45:24.308146Z]. Please make sure the value you are passing matches the definition in your table or in your query or convert the value accordingly."
when I put it as date
what program are you using to add this column?
The normal Postgres data editor in railway
please dont rely on that, use something like pgadmin
How would I use pgadmin with railway
railway gives you a database, just connect to it with pgadmin
Ah okay