9 months ago
Hey i did a backup restore of my databse. backup was created 4 days ago but now log shows me this warning please help me how i can solve this or i can ignore this these messages are all over my logs.
Attachments
4 Replies
9 months ago
Hey there! We've found the following might help you get unblocked faster:
- 🧵 Problem with postgress passoword after increasing volume
- 🧵 Mismatch Nixpacks version
- 🧵 PostgresQL version
- 🧵 Error on Postgres N8N
If you find the answer from one of these, please let us know by solving the thread!
9 months ago
This thread has been marked as public for community involvement, as it does not contain any sensitive or personal information. Any further activity in this thread will be visible to everyone.
Status changed to Open brody • 9 months ago
9 months ago
Hey, according to the Postgres documentation, you should reindex and refresh the collation version. For example by running REINDEX DATABASE railway; and ALTER DATABASE railway REFRESH COLLATION VERSION;. Please ensure the database is backed up (again) before running any potentially dangerous queries.
uxuz
Hey, according to the [Postgres documentation](https://www.postgresql.org/docs/current/sql-altercollation.html), you should reindex and refresh the collation version. For example by running `REINDEX DATABASE railway;` and `ALTER DATABASE railway REFRESH COLLATION VERSION;`. Please ensure the database is backed up (again) before running any potentially dangerous queries.
9 months ago
Thanks, i am bit new can u tell me where i shuold run these commands.
abdulrehmanjr
Thanks, i am bit new can u tell me where i shuold run these commands.
9 months ago
Hey, sorry for the late reply, but you will have to connect to your Postgres database programmatically via code, use a Postgres compatible database client or use something like psql (CLI) to execute the said queries.
Status changed to Solved uxuz • 9 months ago