= 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.