title: How to fix Plesk Onyx not showing PostgreSQL DB size
body: <p>Fresh install of ‪Ubuntu 18.04.2 LTS‬ running Plesk Onyx Version 17.8.11 Update #60 with just minor tweak so far; used the built in support and installed a PostgreSQL DB Server plus initial database that I then moved to another partition (changed the default so to speak)..</p>
  
  <p>As part of moving the one database that existed I did a :</p>
  
  <pre><code>sudo systemctl stop postgresql
  sudo rsync -av /var/lib/postgresql /home/plesk
  
  nano /etc/postgresql/10/main/postgresql.conf
  </code></pre>
  
  <p>Changed the default location to reflect my partion for it</p>
  
  <p>data_directory = '/home/plesk/postgresql/10/main'</p>
  
  <pre><code>sudo systemctl start postgresql
  </code></pre>
  
  <p>This initial change resulted in the DB in Plesk just showing a loading wheel for # of tables and size.</p>
  
  <p>I have tried to fix it by editing my /etc/psa/psa.conf and changing PGSQL_DATA_D to reflect the database move.</p>
  
  <pre><code>PGSQL_DATA_D /home/plesk/postgresql/10/main
  </code></pre>
  
  <p>The two last PGSQL related entries in that file remains:</p>
  
  <pre><code>PGSQL_CONF_D /etc/postgresql/10/main
  PGSQL_BIN_D /usr/lib/postgresql/10/bin
  </code></pre>
  
  <p>The fix I tried did change something; instead of showing a loading cog the Plesk UI now shows > Tables: null and Size: 0 B? So not a fix but at least it seems more correct than before... but I have no clue how to proceed to fix this.</p>