Changes between Initial Version and Version 1 of how-to/servers/backup-postgres

Timestamp:

Oct 8, 2013, 2:11:47 PM (12 years ago)

Author:

Jamie McClelland

Comment:

--

how-to/servers/backup-postgres

@@ +1 @@
+= How do I backup my postgres database? =
+
+Most members have MySQL databases, which are backed up for you and stored in the backups directory of your hosting order.
+
+If you are running a postgres database, your database is also included in our backup routine, however, you cannot directly access the database (you'll need to open a ticket to request that it be restored).
+
+You are strongly encouraged to run your own backups as well.
+
+To manually create a backup of your database, type:
+
+{{{
+pg_dump [dbname] > backup.sql
+}}}
+
+Replace [dbname] with the name of your database.
+
+Then, you can copy backup.sql to your local computer.
+
+You could also put this command into a [wiki:faq/cron-job cron job] so it runs once a day.
+
+
+