Last week one of my sites server crashed. I was not able to access the ssh server and could only use the basic linux console on digitalocean.com. Because I could not get into my ssh server I was not able to perform a pg_dump to backup my database. I was however able to use rsync to pull those files out onto my hard drive. The problem is that I have no idea how to put those files back into my server. I don't believe I can use:
>psql -U username -f backupfile.sql
to restore those files because the rsync command only got me a main dir with tons of db files in it. I so not see any .sql files in there so I have no idea what to do to get that database back into my site. Does anyone have any advice or know if this is even possible? It might be better to launch my site clean and manually rebuild the database. Thank you for checking this out.