I'd like to periodically copy the database from production to dev, so that I have accurate data to play around with.
How do you all do this?
It seems like you'd do a
pg_dump safe4all > safe4all.dmp
pg_restore -d safe4all-dev safe4all.dmp
Is that accurate? I'm pretty new to Postgres.