Add maintenance of databases from H2N



  • I do not know how to work "build stats", but it is perhaps interesting to add things to the program as:

    reindex
    vacuum
    analyze
    cluster
    rebuild data base

    It could be placed here:
    http://prnt.sc/d3lp0w


  • Global Moderator

    1. First of all, Hand2Note now has its own PostgreSQL server which starts with the application and stops on its shutdown. Therefore, you do not need to use the connection to custom server. Please, uncheck this option and create new database in Configurator-->Database:
      alt text
      I think, it will solve most of the problems you have described in other topics.

    2. Maintenance can be done via pgAdmin, which comes with Hand2Note. You can find it in the following folder:
      Hand2note / pgsql / bin / pgAdmin3.exe
      Database maintenance is performed automatically in modern versions of PostgreSQL. In most cases, you do not need to do it manually. It may be necessary in exceptional situations only.


Log in to reply
 

Looks like your connection to Hand2Note was lost, please wait while we try to reconnect.