soft raptor
I'm having trouble installing and configuring the Medusa server on an AWS Lightsail instance with a Lightsail-managed PostgreSQL database. Although I can manually connect to the database using psql without issues, the Medusa server fails to connect during installation.
I've attached error messages for review and would appreciate any help in resolving this.
hard talon
For troubleshooting purposes, will it connect to a local postgres DB?
soft raptor
Sorry, i forgot to mention
Medusa working fine when using local postgres db and also working good wit neon db
hard talon
Ok, I believe Lightsail offers public and private URLs for DBs. Could you verify that you're using the public version of your DB? I used to have the same problem happen to me on Railway until I realized I was using the incorrect URL.
soft raptor
Aws db working fine when I try to connect using psql
hard talon
Could it be that the port is missing from the db url when creating medusa?
soft raptor
I tried with port first but it's not working
hard talon
Ok, put the port and change from "postgres..." to "postgresql"
They're interchangeable
hard talon
Hmmm... I mean, the issue is definitely on Lightsails side rather than Medusa's because I just did a launch using Railway and I got it working without a problem. Let's see if somebody else has been able to create with Lightsail.
soft raptor
can you try with my aws db?
just want to confirm that it did not have any issue with lightsail instance
hard talon
DM it
pine dirge