Forum OpenACS Q&A: backups for 4.5/PG?

Collapse
1: backups for 4.5/PG?
Posted by Rafael Calvo on 07/26/02 06:39 AM
Hi,

What is the best way to do backups of 4.5 for PG?
I am doing:
pg_dump -b -f xxx.July2502.pg_dump -F c staging

and then restoring with:
pg_restore -d itev  -v itev.July2502.pg_dump

but I get an error saying that so and so function is missing. If I
change the read order using the -N option so it is read using the
original order I get similar errors

Collapse
2: Response to backups for 4.5/PG? (response to 1)
Posted by Rafael Calvo on 07/26/02 06:56 AM
I just found this related thread, but it doesn't address BLOBs. https://openacs.org/bboard/q-and-a-fetch-msg.tcl?msg_id=0004NJ

How do you backup BLOB (eg file storage)

Collapse
3: Response to backups for 4.5/PG? (response to 1)
Posted by Jun Yamog on 07/26/02 08:04 AM
Hi Rafael,

Good point.  Normally we use the file system as our storage type in CR.  But I could have sworn that when I had to fix a performance problem in file-storage I just did a pg_dump -d db > dumpfile.  All the contents where are still there prior to changing the storage type to file storage.

Hmmm I better review this.  Does anybody have experiences with this?  I maybe backing up partial data.  We use 7.1.3 in production.

Collapse
4: Response to backups for 4.5/PG? (response to 1)
Posted by Don Baccus on 07/26/02 03:35 PM
You need to load up postgresql.sql from the acs-kernel module to get around the function ordering problems.

We don't use PostgreSQL large objects.  One reason we don't is that until 7.1 or so you couldn't dump them.  We use something I wrote that functions at the AOLserver driver level and sites using them, for instance storing files in the database rather than file system, dump and restore fine.

Collapse
5: Response to backups for 4.5/PG? (response to 1)
Posted by Gustavo Garcia on 07/28/02 02:22 AM
Do you plan to implement Postgresql large objects? If so, by when?