> You might try using online backups. By following the steps in this
> document:
>
> http://www.postgresql.org/docs/8.1/static/backup-online.html
>
> you can back up the data at the speed of your filesystem. There's no way
> to make it faster than that.
PITR config is complicated. A lot of manual steps are required.
Requires postgresql.conf file changing, server re-start, creating PITR
directory and adding postgres user privilege to it, file copying.
PITR recovery is also complicated.
My goal is to create ERP system which creates backups without any
attendance.
I don'nt know how to automate this 100% and havent found any such sample.
So I'm waiting when this is automated like 8.2 automates user privilege
dropping and use pg_dump in current installations.
Andrus.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
