Justtechjobs.com Find a programming school near you






Online Campus Both


php3-list | 199908

Re: [PHP3] postGres Care and feeding From: Richard Lynch (rlynch <email protected>)
Date: 08/18/99

At 11:38 AM 8/18/99 -0300, you wrote:
>On Wed, 18 Aug 1999, Bruce Tong wrote:
>
>> > Do postGres databases need care and feeding like other DBs I have
>> > worked with?
>>
>> I not a DB pro, but I'm pretty certain the answer is "yes."
>>
>> > That is, after numerous deletions, etc. does one need to compact
>> > the file, rebuild indices, etc. or is that all done automatically
>> > in the background?
>>
>> I know many people use the pg_dump utility to save off the database, then
>> use psql to issue a "vacuum" command, and then use psql to restore the
>> database. There are some options involved and I believe this scenario is
>> discussed in the PostgreSQL documentation which you can find at...
>
>Woah...huh? dump, vacuum and then restore? Please let me know where we
>have that in the docs, as there is a drastic error in there :(
>
>You should just have to issue a 'vacuum' command using pg_exec()...not
>sure why you'd want to do a dump/restore around it through...

A dump beforehand is not a bad idea... vacuum does tend to lock up...

Following up with a restore is just plain wrong. 

-- 
"TANSTAAFL"  Websites I have built:
CHaTMusic.com      EmphasisEntertainment.com     L-I-E.com
JadeMaze.com       CatCatalani.com               MGMH.com
AstraKelly.com     OlivierLedoux.com

-- 
PHP 3 Mailing List <http://www.php.net/>
To unsubscribe, send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest, e-mail: php3-digest-subscribe <email protected>
To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
To contact the list administrators, e-mail: php-list-admin <email protected>