NyalomaSzemed
NyalomaSzemed
RRailway
Created by NyalomaSzemed on 2/22/2024 in #✋|help
Postgress DB connection issue
The db was always operational, the main issue with the connection. In the logs we can see all of the rejected connections, also, if we are trying to attempt any connection from a fake account. I have to say, we still have the priginal user and password, so that's could cause the issue. Now we are able to attach the volume to a volume file browser container and access the db data via file manager. Is there any way to modify the db with a new connection credentials?
19 replies
RRailway
Created by NyalomaSzemed on 2/22/2024 in #✋|help
Postgress DB connection issue
The db is operational. Is there any way to open pg_hba.conf?
19 replies
RRailway
Created by NyalomaSzemed on 2/22/2024 in #✋|help
Postgress DB connection issue
The main reason why we want to connect to the db with pgadmin, to create a backup and download it
19 replies
RRailway
Created by NyalomaSzemed on 2/22/2024 in #✋|help
Postgress DB connection issue
Is there any option to start using the pg container locally?
19 replies
RRailway
Created by NyalomaSzemed on 2/22/2024 in #✋|help
Postgress DB connection issue
Yes, it would be nice if we don't lose any data
19 replies
RRailway
Created by NyalomaSzemed on 2/22/2024 in #✋|help
Postgress DB connection issue
When the issue started, the db password unchanged. Once I tried to change it, but right now the db password is the same as the original.
19 replies
RRailway
Created by NyalomaSzemed on 2/22/2024 in #✋|help
Postgress DB connection issue
I don't think so, before the connection lost I did not modified the environmental settings. Also, on the same project I added a brand new postgress db with the same settings, and I can connect it to pgadmin without any issue. I think the main problem is related to the private networking... Is there any option or troubleshoot step to check if the db user/password are match?!
19 replies
RRailway
Created by NyalomaSzemed on 2/22/2024 in #✋|help
Postgress DB connection issue
Recreated a similar environment on my colleges user, and double check the settings. While I tried to reconnect umami to the db I also tried different environment settings. The thing what I’m trying to say whit this, the the env settings are fine, the issue is not related to this. It seems that the db cannot be reached with the correct credentials.
19 replies
RRailway
Created by NyalomaSzemed on 1/1/2024 in #✋|help
umami stoped working
Yes, confirmation, sorry. I started this service while in trial, after I upgraded to hobby it doesn't changed. I think because of the service interruption. It would be nice if Railway send any notification about volume size increases.
16 replies
RRailway
Created by NyalomaSzemed on 1/1/2024 in #✋|help
umami stoped working
Ohh god, that was it. You're awwsome @Brody ! 🙏 For the record: Postgres service, Settings, Go to Volume. Normally, the default size of a volume is limited at 500 MB, which can be resized to 5 GB with a ridiculously long command, which is quite funny. 😂 After doing these I just need to restart all of the services and everything is up and running again! Again, thanks for the quick help, great community! salute
16 replies
RRailway
Created by NyalomaSzemed on 1/1/2024 in #✋|help
umami stoped working
Yes, I tried to restart both services a bunch of times.
16 replies
RRailway
Created by NyalomaSzemed on 1/1/2024 in #✋|help
umami stoped working
Yes, there is a lot of message, but i'm not sure that these are errors. Regarding some research these messages could be normal: "2024-01-01 21:17:23.143 UTC [7] LOG: checkpointer process (PID 20614) was terminated by signal 6: Aborted 2024-01-01 21:17:23.143 UTC [7] LOG: terminating any other active server processes 2024-01-01 21:17:23.146 UTC [7] LOG: all server processes terminated; reinitializing 2024-01-01 21:17:23.161 UTC [20616] LOG: database system shutdown was interrupted; last known up at 2024-01-01 21:17:23 UTC 2024-01-01 21:17:23.213 UTC [20616] LOG: database system was not properly shut down; automatic recovery in progress 2024-01-01 21:17:23.215 UTC [20616] LOG: redo starts at 1/728C74F8 2024-01-01 21:17:23.215 UTC [20616] LOG: invalid record length at 1/728C79F0: wanted 24, got 0 2024-01-01 21:17:23.215 UTC [20616] LOG: redo done at 1/728C79C8 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s 2024-01-01 21:17:23.218 UTC [20617] LOG: checkpoint starting: end-of-recovery immediate wait 2024-01-01 21:17:23.218 UTC [20617] PANIC: could not write to file "pg_logical/replorigin_checkpoint.tmp": No space left on device"
16 replies
RRailway
Created by NyalomaSzemed on 1/1/2024 in #✋|help
umami stoped working
Github repo
16 replies