photosupreme database maintenance question

Post Reply
angelanthony
Posts: 16
Joined: 02 Jun 17 7:15

photosupreme database maintenance question

Post by angelanthony » 13 Oct 17 4:02

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: 20321
Joined: 13 Sep 03 7:24

Re: photosupreme database maintenance question

Post by Hert » 13 Oct 17 21:33

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 which means that users post questions here for other users.
Feature requests, change suggestions, or bugs can be logged in the ticketing system

Post Reply