RailwayAlgeu Junior

Postgres crashes after config

I ran the following command: ALTER SYSTEM SET shared_preload_libraries = 'timescaledb,pg_stat_statements'; and my deploy is crashing:

PostgreSQL Database directory appears to contain a database; Skipping initialization

2024-04-29 12:31:11.626 UTC [8] FATAL:  could not access file "pg_stat_statements,timescaledb": No such file or directory

2024-04-29 12:31:11.626 UTC [8] LOG:  database system is shut down

how can i fix?

Solution:

database is back up

Percy•18d ago

Project ID: 6f1d26dd-c104-43d6-8f3d-2f6bc6f9042c

Algeu Junior•18d ago

6f1d26dd-c104-43d6-8f3d-2f6bc6f9042c i cant set the previous value: shared_preload_libraries = 'timescaledb';

Brody•18d ago

did you have a backup?

Algeu Junior•18d ago

@Brody, actually i don't have a backup

Brody•18d ago

is there important data on the database?

Algeu Junior•18d ago

@Brody yes, its company's production database i found this user with same error: https://discord.com/channels/713503345364697088/1119792911819751566 it's seems your engineers change the config file

Brody•18d ago

yeah but the only difference is that they are on the Pro plan

Algeu Junior•18d ago

oh no 😦

Brody•18d ago

I'll do my best to help you remove that config yourself, but I make no promises going forward please upgrade to Pro as well, you should not be running a company's production database on a Hobby plan

Algeu Junior•18d ago

i'll appreciate that if i migrate for pro right now, helps?

Brody•18d ago

while I could get the team involved if you upgraded to pro right now, there's no guarantee that they would be able to fix it faster than we could what is the source image for your database?

Algeu Junior•18d ago

i understand, then i'll wait and migrate for pro after this it's railway's postgres base template

Brody•18d ago

railway has a few, please tell me your database's source im trying to work out a plan of action, so id need to know that

Algeu Junior•18d ago

i found this on project: https://github.com/railwayapp-templates/timescale-postgis-ssl/pkgs/container/timescale-postgis-ssl

GitHub

Build software better, together

GitHub is where people build software. More than 100 million people use GitHub to discover, fork, and contribute to over 420 million projects.

Brody•18d ago

what version

Algeu Junior•18d ago

pg 15

Algeu Junior•18d ago

thats right?

Brody•18d ago

i take it this is a migrated database?

Algeu Junior•18d ago

yes! from mandatory migration that occurred at jan/2024, right?

Brody•18d ago

how much of the volume is used?

Algeu Junior•18d ago

are you referring to disk space and memory?

Brody•18d ago

just disk space

Algeu Junior•18d ago

less than 2 GB

Brody•18d ago

if im able to work out a plan of action would you be down to let me do it?

Algeu Junior•18d ago

yes, of course

Brody•18d ago

know that i dont take any responsibility for data loss

Brody•18d ago

Algeu Junior•18d ago

ok, no problems!

Brody•18d ago

i was able to recover a database with the same error you are facing, if you want to add me to the project i will get started

Algeu Junior•18d ago

yes, i will

Brody•18d ago

brodyover@gmail.com

Algeu Junior•18d ago

Brody•18d ago

you have a backup service?

Algeu Junior•18d ago

yes, from railways s3 backup template but only bakcups once a day from last backup to now, there was new data added

Brody•18d ago

gotcha btw your backup service is using the database's public url, meaning you are paying extra egress when a database backup runs

Algeu Junior•18d ago

oh, that's interesting. an alternative would a private url?

Brody•18d ago

i can change that if you'd like?

Algeu Junior•18d ago

ill appreciate it!

Solution

Brody•18d ago

database is back up

Algeu Junior•18d ago

omg, worked. and was no data loss!!

Brody•18d ago

backup service updated too

Algeu Junior•18d ago

thanks a lot, Brody!!!

Brody•18d ago

no problem!

Brody•18d ago

non admins (me) cant delete stuff, so you can delete these two things

Algeu Junior•18d ago

i'll migrate to pro now. i'll need to redeploy some service or additional configs??

Brody•18d ago

after youve upgraded you will be asked what projects you want to move over to the pro workspace

Algeu Junior•18d ago

ok, i'll do it thank you one more time and have a nice day!

Brody•18d ago

no prob, and you as well!

Railway Join

Hang out with other likeminded developers & talk about all things https://railway.app on the Railway Community Server.

24KMembers

View on Discord

Want results from more Discord servers?

Add your server

backup postgres R2What's the problem with this error? wrong credential? ``` Error while running backup: Error: getadd I cant deploy.Hello! i for some reason cant deploy my self hosted version of the zeppelin discord bot. Please help How do I create a template from the following Docker files?`Dockerfile` ```yml FROM postgres:16-alpine3.19 RUN apk -U add --no-cache \ alpine-sdk \ curl-Is it possible to use Redis?After all that has happened to Redis, is it still possible to create a Docker image and update it to Is it possible to use Redis?After all that has happened to Redis, is it still possible to create a Docker image and receive upda Watch paths to ignore on PR deployment (preview)I have watch paths set on the `preview` environment, but am still seeing instances spin up for new P Payment fails on portal but is success on Visa appWhen I try to subscribe to hobby plan, my payment fails on the railway site with "card declined" whe Cannot change nixpkgsArchive hash from railway.tomlHello, seems like I can't change the nixpkgs archive version from railway.toml ``` [build] builder =can i use railway postgres db with @vercel/postgres ?I am try trying to use railway postgress db with @vercel/postgres. Is it compatible? How do I map ra Issue Deploying Django App with Gunicorn on RailwayIt's been a few days of trying to get this up for some production tests but I'm having issues gettin Prisma Nickpacks with Bun errorWhen trying to build nixpacks with bun and prisma using this config: ```toml # nixpacks.toml [phases How to retrieve env vars from railway?I need to use them in github action and I don't want to have them as a secret in github as well as i Django app, slow server responseI am having django app, regular django templates. Database is on google cloud. This is railway re MongoDB prismaWhen ever i try to connect my mongodb with prisma i does not work :( when i genarate the schema it g Accessing an image within a railway. app PGS databaseHi all, Absolutely love Railway.app but just wondering if anyone can assist with accessing an imag incorrect cron time trigger@Brody I'm using your template (https://railway.app/template/fwH-l3) and it seems to trigger at inco How do I connect Webste <-> Server <-> Database❓Github code for Main website in public and server.js https://github.com/Lanonymus/todowebsite/tree/m Devika DeployProject ID: ec66fb06-96a7-4f3e-8481-72f97991dc35 Hello, I am trying to deploy Github project Devika Laravel Image upload returns 413 (file too large)Hi, I have endpoint in my laravel app that uploads images but it returns with the status code of 413 RAILWAY_TCP_PROXY_DOMAIN and RAILWAY_TCP_PROXY_PORT are emptyI noticed this morning, in my Postgres database PGPORT is set ${{RAILWAY_TCP_PROXY_PORT}} but it's e

Gaming

Programming

Postgres crashes after config