photosupreme database maintenance question

Post Reply
angelanthony
Posts: 26
Joined: 02 Jun 17 6:15

photosupreme database maintenance question

Post by angelanthony »

i have a questions as im using photosupreme server version running postgresql

i wanted to know best practices on using pgadmin3 for doing some database maintenance
i wanted to know should i stick to using photosupremes maintenance tools or can i use the pgadmin3 tools .

in the pgadmin3 dashboard i see thats theres a postgres folder , my photosupreme catalog folder , and my photosupreme catalog thumbs folder
if i right click on anyone of those folders there is an option for maintenance and the following options are given - -vacuum, analyze, reindex, cluster
vacuum options - full , freeze, analyze
then theres an option to check off verbose messages

i dont want to run these actions on photosupremes folders until i know its ok to do so and or what options and suggestions one can make when doing this or should i just stick to using photosupremes compact and backup tools.

any info is greatly appreciated.
Hert
Posts: 7870
Joined: 13 Sep 03 6:24

Re: photosupreme database maintenance question

Post by Hert »

In general the rule is: if you know what you're doing then certainly use it. You should be safe using vacuum, reindex or backup using pgadmin.
This is a user-to-user forum. If you have suggestions, requests or need support then please send a message
Post Reply