[GENERAL] Backup setup

I need to back up our database off-site for disaster recovery. If I just back up the entire database data directory (i.e. /var/lib/pgsql/data) will I be able to restore from there? Or should I instead just dump the data, using pg_dump, and back up the dump? The advantage of the first method would b

[GENERAL] Best backup setup

I need to back up our database off-site for disaster recovery. If I just back up the entire database data directory (i.e. /var/lib/pgsql/data) will I be able to restore from there? Or should I instead just dump the data, using pg_dump, and back up the dump? The advantage of the first method would

[GENERAL] Out of memory error during updating huge table

I'm trying to update a table in transaction mode with 300 million records in it, and I'm getting an out of memory error. ERROR: out of memory DETAIL: Failed on request of size 32. In transaction mode, I first delete all the records in the table and then try to use COPY to populate it again with t

[GENERAL] Does DROP TABLE free up disk space immediately?

Does DROP TABLE free up disk space immediately?   Thanks,   -Gabor NOTE: The contents of this e-mail including any attachments may contain confidential or privileged information and are to be read solely by the intended recipient(s).  If you are not an intended recipient of this e-ma