Persistant Data in Heroku Postgres - Ephemeral Filesystem

Question

This might be a simple question, but I would like some clarification.

Based off the docs, Heroku has an ephemeral file system. How I interpret it is that anytime you upload a file to Heroku and there is a change in the configuration or the app is restarted, the files are gone.

However, I was wondering if this is the case if you upload data to Heroku Postgres through a dumps file.

For development, I am using a local Postgres server. From there, I would create a dumps file and then upload that file using commands found here:

https://stackoverflow.com/a/71206831/3100570

Now suppose my application makes a POST request to Heroku Postgres, would that data be persisted along with the initial data from the dumps file in the event that the application is restarted or crashed?

Chris · Accepted Answer · 2022-03-22 14:17:14Z

1

Ingesting data into your PostgreSQL database this way doesn't touch your dyno's filesystem. You are simply connecting to PostgreSQL and running the SQL commands contained in that file:

-f, --file=file
    SQL file to run

The data will be stored in PostgreSQL in exactly the same way it would if you did a bunch of INSERTs yourself. You should have no problem ingesting data this way and then continuing to interact with your application as normal.

answered Mar 22, 2022 at 14:17

Chris

139k139 gold badges317 silver badges293 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Persistant Data in Heroku Postgres - Ephemeral Filesystem

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related