Andrew Perrin wrote:
- Do a formal backup more often
For what it's worth, the FreeBSD "port"
(http://cvsweb.freebsd.org/ports/databases/postgresql7/) for PostgreSQL
contains a most excellent daily maintenance script (as written it's a
FreeBSD "periodic" script, but it's more or less suitab
I just got done upgrading 2 databases from 7.1.x to 7.2.3. In both cases
the procedure outlined in pg_upgrade.1 failed. In one case, the failure
was catastrophic. In neither case was any data lost (because I backed up
with pg_dumpall first), but in both cases it appears the failure was
similar:
Hi. I have been a happy user of PostgreSQL for some time now. I am
begining a project that, much to my very slight annoyance, will involve
either CLOBs or BLOBs. My understanding is that neither is backed-up by
pg_dumpall (my backup strategy is that I do a pg_dumpall and mark the
actuall databa
