It looks like there's already a PostgreSQL instance that everyone has 'jailed' access to. Does this mean I don't have to worry about backups and setting AUTOVACUUM? How much housekeeping does the database need?
Postgresql 8.0 Setup?
- Wsargent
- Posts: 15
- Starts: 8
- Wiki Edits: 3
- Location: San Francisco, CA
Hi there,
It looks like there's already a PostgreSQL instance that everyone has 'jailed' access to. Does this mean I don't have to worry about backups and setting AUTOVACUUM? How much housekeeping does the database need?
It looks like there's already a PostgreSQL instance that everyone has 'jailed' access to. Does this mean I don't have to worry about backups and setting AUTOVACUUM? How much housekeeping does the database need?
- Varun
- Posts: 410
- Starts: 0
- Wiki Edits: 0
Wsargent- AUTOVACUUM is not enabled on the server. You'll be able to mane your PostgreSQL databases using your cPanel control panel > PostgreSQL Databases > phpPgAdmin .
2007-10-24 08:24 PM
- Wsargent
- Posts: 15
- Starts: 8
- Wiki Edits: 3
- Location: San Francisco, CA
Okay -- I assume I can still set up a cron job by hand.
What about database backups? Are they taken care of automatically?
What about database backups? Are they taken care of automatically?
2007-10-24 08:48 PM
- Varun
-
- Posts: 410
- Starts: 0
- Wiki Edits: 0
We cannot gaurantee proper backups of your databases although we have backups running daily. You may want to ensure that you're backing up your databases occasionally to avoid risk of data loss.
2007-10-24 09:32 PM
- Wsargent
- Posts: 15
- Starts: 8
- Wiki Edits: 3
- Location: San Francisco, CA
Okay, here's the documentation for Postgresql 8.1:
http://www.postgresql.org/docs/8.1/static/maintenance.html
and I'm going to set it up to VACUUM every day at 1 am:
0 1 * * * /usr/bin/vacuumdb tersesy_tsprod
http://www.postgresql.org/docs/8.1/static/maintenance.html
and I'm going to set it up to VACUUM every day at 1 am:
0 1 * * * /usr/bin/vacuumdb tersesy_tsprod
2007-10-26 01:28 PM
- Wsargent
- Posts: 15
- Starts: 8
- Wiki Edits: 3
- Location: San Francisco, CA
And here's what I do for the database backup:
0 0 7 * * /usr/bin/pg_dump tersesy_tsprod | /usr/bin/gzip > /home/tersesy/pgbackup/backup.gz
That doesn't really help me if there's a bad hard disk, but it's a start. Do you have backups to remote sites?
0 0 7 * * /usr/bin/pg_dump tersesy_tsprod | /usr/bin/gzip > /home/tersesy/pgbackup/backup.gz
That doesn't really help me if there's a bad hard disk, but it's a start. Do you have backups to remote sites?
2007-10-26 01:34 PM
- Sijin
- Posts: 122
- Starts: 0
- Wiki Edits: 4
Wsargent - Hostingrails has remote backup servers but it's strongly recommended that you keep your important backups offline, to be on the safer side.
2007-10-26 01:48 PM
- Wsargent
- Posts: 15
- Starts: 8
- Wiki Edits: 3
- Location: San Francisco, CA
Okay... I'm assuming that means I should have an rsync script running on another machine, or a remote backup service.
Backups are hard. :-(
Backups are hard. :-(