Unexpected PostgreSQL redeploy – project broken

abbnv
HOBBY

4 months ago

Hi Railway Support,

About 6 hours ago, my PostgreSQL service was unexpectedly redeployed without any action on my part. After that, my entire project stopped working — the database seems broken or inaccessible, and some data may have been lost.

This project is critical, and I need to understand what happened. Could you please:

  1. Clarify why the redeploy occurred (automated update, internal maintenance, etc.)?

  2. Help me restore the database to its previous state if possible?

  3. Let me know if there’s any backup I can roll back to?

Appreciate your help — this is urgent.

Solved

10 Replies

abbnv
HOBBY

4 months ago

Postgres logs

Attachments

%D0%A1%D0%B...

abbnv
HOBBY

4 months ago

Heeelp please!

brody
EMPLOYEE

4 months ago

Hello,

1. https://docs.railway.com/reference/deployments#railway-initiated-deployments

2. The database has data in it, about 1.5GB of data, can you let me know how you came to the conclusion that any data was lost?
3. Backups are only available on the Pro plan, but again, please let me know why a backup would be needed here.

Best,
Brody

Status changed to Awaiting User Response Railway • 4 months ago

abbnv
HOBBY

4 months ago

Hi Brody,

Thanks for your response.

As soon as I opened n8n after the redeploy, it prompted me to register a new user — as if it had never been set up before. I do it with same email. After logging in, all my previous workflows, credentials, and executions were gone.

That’s why I assumed the data was lost or that something broke during the redeploy. If the 1.5GB of data is still there, I’d really appreciate your help in understanding how to reconnect n8n to the existing database — or access what’s still stored.

Thanks again,

Status changed to Awaiting Railway Response Railway • 4 months ago

abbnv
HOBBY

4 months ago

I connected directly to the database using pgAdmin and checked the tables — unfortunately, I don’t see any of the old records there (no previous workflows, credentials, or users). It looks like the database has either been reset or a different schema/database is being used now.

Could you please help me confirm:

  1. Whether the original data is still present somewhere?

  2. If the redeploy might have switched the connection to a new or empty schema?

Thanks again — trying to restore access to my production setup ASAP.

brody
EMPLOYEE

4 months ago

I am seeing what you are seeing, looks like N8N has freshly initialised a database, yet the volume metrics show plenty of data.

We will be looking into this today, until further notice, please do not try anything yourself.

Status changed to Awaiting User Response Railway • 4 months ago

Railway
BOT

4 months ago

Hello!

We've escalated your issue to our engineering team.

We aim to provide an update within 1 business day.

Please reply to this thread if you have any questions!

brody
EMPLOYEE

4 months ago

Hello,

We have restored the data pre-migration, and fixed the root cause, can you please confirm if you are seeing the correct data?

Best,
Brody

abbnv
HOBBY

4 months ago

Yeees, thank you so much!

Status changed to Awaiting Railway Response Railway • 4 months ago

Status changed to Solved jake • 4 months ago

Railway
BOT

4 months ago

✅ The internal ticket Postgres seemingly freshly initialized after migration has been marked as completed.