Database Management

PostgreSQL Database Backup Takes Too Long

While giving a training course on PostgreSQL, the problem arose that a pg_dump of their database would take too long. The database contains more or less nothing else than BLOBs (PDF files). Currently only 500MB, but there are 45GB of archived files (from the last 10 years or so) and new ones will be added on a daily basis. So at least 50GB (older files could be removed) will be stored in the database. Doing a test dump with pg_dump takes approximately 3 minutes for 500MB (on the given system) - which means 50GB will take somewhere around 5 hours. That is definitely too long, as the backup will need to run every night and additional file system backups (with IBM Tivoli) need to be performed as well.

Oracle and C-Compiling Error

For security reasons a server offering webservices should be installed new: It is used to run CGI-Webapplications manipulating data in an Oracle 8.1.8. database via webformulas. I first installed Solaris and then Oracle 8.1.8 and the webserver. Both are running without errors. In the next step I used the compiled Files from the backup copy: The webservices are running. To modify the applications a new compilation is necessary. I dir not panipulate *.c files. I just tried to compile it. CC or GCC did not work. I got the information, that make-files are used so I tried gmake with the following mistake. How can I make it run? servernumberone[62]% gmake unregister.c gcc -xO2 -Xa -xstrconst -xF -mr -xarch=v8 -xcache=16/32/1:1024/64/1 -xchip=ultra -D_REENTRANT -K PIC -DPRECOMP -I/oracle/u1/app/oracle/product/8.1.7/precomp/hdrs -I/oracle/u1/app/oracle/product/8.1.7/precomp/public -I/oracle/u1/app/oracle/product/8.1.7/precomp/include -I/oracle/u1/app/oracle/product/8.1.7/oracore/include -I/oracle/u1/app/oracle/product/8.1.7/oracore/public -I/oracle/u1/app/oracle/product/8.1.7/oracore/port/include -I/oracle/u1/app/oracle/product/8.1.7/nlsrtl/include -I/oracle/u1/app/oracle/product/8.1.7/slax/include -I. -DSLMXMX_ENABLE -DSLTS_ENABLE -D_SVID_GETTOD -c -o unregister.o unregister.c gcc: cannot specify -o with -c or -S and multiple compilations gmake: *** [anmeldung.o] Error 1 servernumberone[63]%
Subscribe to Database Management