I use Time Machine on my Mac to backup my system. I have just managed to clobber my Postgres database and would like to restore it using my Time Machine backups. The latest changes don't matter, so I just want to wind it back to its state yesterday.
So, my questions are:
a) are Time Machine backups useful for databases?
b) where are the actual database files stored? I've looked and can not find anything useful.
c) can I just rollback those files and everything will work?
d) do I need to shutdown Postgres first?
I have an old dump of the database using Postgres' backup but would like to know what the story is with Postgres first.