R
Railway•7mo ago
rom

Not able to connect to PostgresDB after migration

Hello, we have 5 different apps with Postgres DB running on railway. We've started the migration of one of our app but we encounter an issue with the new DB. with this error : could not receive data from client: Connection reset by peer We currently connect our app to the Postgres Legacy so our services are not down, but it's important to be able to migrate everything safely. Thanks ProjectId: ca07cd9d-fb81-4dce-ad1b-161d8d544c3e
2 Replies
Percy
Percy•7mo ago
Project ID: ca07cd9d-fb81-4dce-ad1b-161d8d544c3e
rom
rom•7mo ago
Here is the full logs 2023-11-29 08:40:09.244 UTC [7] LOG: PostgreSQL Database directory appears to contain a database; Skipping initialization 2023-11-29 08:40:09.244 UTC [7] LOG: starting PostgreSQL 15.4 (Ubuntu 15.4-2.pgdg22.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit 2023-11-29 08:40:09.244 UTC [7] LOG: listening on IPv4 address "0.0.0.0", port 5432 2023-11-29 08:40:09.244 UTC [7] LOG: listening on IPv6 address "::", port 5432 2023-11-29 08:40:09.248 UTC [7] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2023-11-29 08:40:09.255 UTC [34] LOG: database system was interrupted; last known up at 2023-11-29 08:31:29 UTC 2023-11-29 08:40:09.295 UTC [34] LOG: database system was not properly shut down; automatic recovery in progress 2023-11-29 08:40:09.299 UTC [34] LOG: redo starts at 0/283F538 2023-11-29 08:40:09.299 UTC [34] LOG: invalid record length at 0/283F570: wanted 24, got 0 2023-11-29 08:40:09.299 UTC [34] LOG: redo done at 0/283F538 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s 2023-11-29 08:40:09.304 UTC [32] LOG: checkpoint starting: end-of-recovery immediate wait 2023-11-29 08:40:09.315 UTC [32] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.004 s, sync=0.002 s, total=0.013 s; sync files=2, longest=0.002 s, average=0.001 s; distance=0 kB, estimate=0 kB 2023-11-29 08:40:09.323 UTC [7] LOG: database system is ready to accept connections 2023-11-29 08:40:09.328 UTC [37] LOG: TimescaleDB background worker launcher connected to shared catalogs 2023-11-29 08:44:27.082 UTC [47] LOG: could not receive data from client: Connection reset by peer Hello here, I saw the issue was marked in an other thread but quick question I got a Pro Plan and I can't see my role after verifying my account. What's the best way to get support on this issue?
Want results from more Discord servers?
Add your server
More Posts
Is there a storage limit on my fastapi server?I'm saving some temp docs locally to /tmp and wonder if there is a storage limit? I know that every Persistent storageI have Directus installed (postgres) and when I redeployed my files were wiped out(mostly images). IHow can i install Java runtime environment (JRE)Hi, I have a node app which requires Java runtime environment (JRE). How can i set JRE? thanksGetting Repo name not availableI tried to deploy vue project but it's showing Repo name not available , not sure why i'm getting thError in Installing Dependencies from my requirements.txtFile "main.py", line 1, in <module> from ultralytics import YOLO File "/opt/venv/lib/python3.8/site-Cancel payment 🙏🏻Hi, I was thinking that monthly payment starts from 1st of the month, but it isn’t. Can I cancel my Getting [ioredis] Unhandled error event: ReplyError: ERR max number of clients reachedAny ideas why?No Query Tab for Postgres?Hi everyone, I'm new to Railway and was hoping to add my tables to postgres using the query tab likSetting up PgBouncerhey everyone! I'm currently in the process of setting up PgBouncer for my postgres. I cloned https:How good of security does railway have in terms of ddos attacks and other stuff?I'm just wondering as if it happens I don't want to get charged thousands of dollars for uses.