Kurdiez
Kurdiez
RRailway
Created by Kurdiez on 10/26/2024 in #✋|help
Where can I see the pricing of volume sizes for Postgres DB?
Ok thank you
9 replies
RRailway
Created by Kurdiez on 10/26/2024 in #✋|help
Where can I see the pricing of volume sizes for Postgres DB?
So the only harm in increasing the volume is if you had a sudden unexpected large amount of data dumped to your DB?
9 replies
RRailway
Created by Kurdiez on 10/2/2024 in #✋|help
Is it possible to do Postgres config settings change
Oh ok, so all config values can be done via SQL and you just want us to simply refresh the configs in SQL?
7 replies
RRailway
Created by Kurdiez on 10/2/2024 in #✋|help
Is it possible to do Postgres config settings change
3747f720-8c9c-4d81-9b13-1e420ceabd6c
7 replies
RRailway
Created by Kurdiez on 9/27/2024 in #✋|help
Does Postgres use multiple cores out of the box?
3747f720-8c9c-4d81-9b13-1e420ceabd6c
4 replies
RRailway
Created by Kurdiez on 8/17/2024 in #✋|help
Urgent! Production DB is showing "could not resize shared memory segment" error
Ok, so we have no choice. Thanks.
34 replies
RRailway
Created by Kurdiez on 8/17/2024 in #✋|help
Urgent! Production DB is showing "could not resize shared memory segment" error
What is the new V2 way of specifying how much shared memory can be allocated? Should I be using that instead ?
34 replies
RRailway
Created by Kurdiez on 8/17/2024 in #✋|help
Urgent! Production DB is showing "could not resize shared memory segment" error
Sorry, had no idea that settings even existed... we never really use Railway because we set it up long time ago and nothing broke until now.
34 replies
RRailway
Created by Kurdiez on 8/17/2024 in #✋|help
Urgent! Production DB is showing "could not resize shared memory segment" error
@Brody Ok that fixed the issue. Thank you. Everything is working now.
34 replies
RRailway
Created by Kurdiez on 8/17/2024 in #✋|help
Urgent! Production DB is showing "could not resize shared memory segment" error
My bad. I will change that to Legacy now and redeploy.
34 replies
RRailway
Created by Kurdiez on 8/17/2024 in #✋|help
Urgent! Production DB is showing "could not resize shared memory segment" error
I had no idea when you said Runtime I was supposed to go to the Settings to change that. You never mentioned that that is a settings in Railway... I just understood as some runtime you have that automatically goes into Legacy mode.
34 replies
RRailway
Created by Kurdiez on 8/17/2024 in #✋|help
Urgent! Production DB is showing "could not resize shared memory segment" error
I am really confused now. Do you understand what I've done so far? Because that's exactly what I have already done for genie-new-db and I tested that that didn't solve the problem.
34 replies
RRailway
Created by Kurdiez on 8/17/2024 in #✋|help
Urgent! Production DB is showing "could not resize shared memory segment" error
You just said that in order for the RAILWAY_SHM_SIZE_BYTES="536870912" to take an effect in genie-new-db service, I need to also set the same variable RAILWAY_SHM_SIZE_BYTES="536870912" to the genie-db service. That's how I understood.
34 replies
RRailway
Created by Kurdiez on 8/17/2024 in #✋|help
Urgent! Production DB is showing "could not resize shared memory segment" error
Ah ok. My apologies. I never imagined that an environment variable from one service would affect the other. What an odd user experience that is...
34 replies
RRailway
Created by Kurdiez on 8/17/2024 in #✋|help
Urgent! Production DB is showing "could not resize shared memory segment" error
Yes and that's why I set the RAILWAY_SHM_SIZE_BYTES to the service genie-new-db and it's not working. Are you saying both genie-new-db and genie-db services need to have the same RAILWAY_SHM_SIZE_BYTES="536870912" for this to take an effect?
34 replies
RRailway
Created by Kurdiez on 8/17/2024 in #✋|help
Urgent! Production DB is showing "could not resize shared memory segment" error
What I am saying is we are preparing another new DB to stop using genie-db. I need to get the new DB called genie-new-db working. And this is the one that ran into exact same memory issue and I set that one to
RAILWAY_SHM_SIZE_BYTES="536870912"
RAILWAY_SHM_SIZE_BYTES="536870912"
as you instructed and it's not working. This is the 3rd time I am mentioning this to you.
34 replies
RRailway
Created by Kurdiez on 8/17/2024 in #✋|help
Urgent! Production DB is showing "could not resize shared memory segment" error
I don't think you are understanding what I am saying. I said that whether you say it's not something you support or not, I made that change many months ago and that particular DB genie-db is our current production DB and its memory issue got solved with the 30GB I set and it works. I'm not gonna bump that down to 500MB when it's serving up live users right now in production.
34 replies
RRailway
Created by Kurdiez on 8/17/2024 in #✋|help
Urgent! Production DB is showing "could not resize shared memory segment" error
genie-new-db is the one that needs to work and that's the one that already has
RAILWAY_SHM_SIZE_BYTES="536870912"
RAILWAY_SHM_SIZE_BYTES="536870912"
as you instructed and as I mentioned here (https://discord.com/channels/713503345364697088/1274291514268188811/1274423235470954586) It's not working still
34 replies
RRailway
Created by Kurdiez on 8/17/2024 in #✋|help
Urgent! Production DB is showing "could not resize shared memory segment" error
On second thought I dont' want to do that to genie-db (the current PROD) because it's working well and serving live traffic right now. I dont' want to disturb the production.
34 replies
RRailway
Created by Kurdiez on 8/17/2024 in #✋|help
Urgent! Production DB is showing "could not resize shared memory segment" error
Ok, I can also set RAILWAY_SHM_SIZE_BYTES="536870912" for the current DB genie-db service. But I really need the genie-new-db working. It is a blocker for us move forward in production.
34 replies