.. _postgresql_commands:


Commands
========

Describes some commands to control PostgreSQL for different operating systems.

|

Global
------

Deletion of the database "odoo":


.. code-block:: shell

   psql
   psql -U postgres -c "drop database odoo"
   psql -l
   \q

|

Location of the productive PostgreSQL database:

.. code-block:: shell

   which psql

Result:

- /usr/local/bin/psql

|

Location of the PostgreSQL program files:

- /usr/local/Cellar

|

Location of the data dictionary:

.. code-block:: shell

   SHOW data_directory;

Result:

- /usr/local/var/postgres

|

Google Engine
-------------

1. Delete Database


.. code-block:: shell

   sudo su - odoo -s /bin/bash
   psql -l
   dropdb Logistics_DB

2. Create Database

.. code-block:: shell

   createdb -p 5432 -O odoo -e Logistics_DB

3. Verification of Database

.. code-block:: shell

   acuumdb --full --dbname Logistics_DB --analyze --verbose

|

Backup and Restore
------------------

1. Basics of the Backup Scripts

1.a) Templates

- `Simple Backup Script <https://drive.google.com/open?id=1Wp29nS4e5HDlU3dhucioCrYZiZCQDGA5&usp=drive_fs>`_

- `Simple Restore Script <https://drive.google.com/open?id=1od9KgCzUhoIhfFIZqHHbgVcprjd1gj4i&usp=drive_fs>`_

- `Advanced Backup Script <https://drive.google.com/open?id=1O45d4JJy0mBwAdNHlkMIQKsRgOuTjAD2&usp=drive_fs>`_: script is based on `Automate Odoo backups with this script <https://janikvonrotz.ch/2020/04/02/automate-odoo-backups-with-this-script/>`_.

- `Advanced Restore Script <https://drive.google.com/open?id=1KMy_Y6dVQ7Z6ufteLW0wuThXxsDy1Buy&usp=drive_fs>`_: script is based on `Restore Odoo database with this script <https://janikvonrotz.ch/2020/05/19/restore-odoo-database-with-this-script/>`_.
   
|

2. Google Cloud Engine

2.a) The apple script `Script Odoo Backup Google <https://drive.google.com/open?id=14IeKTobQJ0CemkyadawADLnsFjPGMkwK&usp=drive_fss>`_ executes a backup based on the ``Advanced Backup Script``.

2.b) The apple script `Script Odoo Restore Google <https://drive.google.com/open?id=11lcxX32VE5sk53Vpa0Ez4eK-E7uj4VSh&usp=drive_fs>`_ executes a restore based on the ``Advanced Restore Script``.

|

3. macOS

3.a) The apple script `Script Odoo Backup Automate <https://drive.google.com/open?id=1fj_shq_GDZU4zOjHPMDZGwGqyrWdfUEw&usp=drive_fs>`_ executes a backup based on the ``Advanced Backup Script``.

3.b) The apple script `Script Odoo Restore Automate <https://drive.google.com/open?id=1bZB4bdXL6NBkUFNUWj1C3gdum5qPOnAN&usp=drive_fs>`_ executes a restore based on the ``Advanced Restore Script``.

|

4. Raspberry Pi

Path to the scripts:

- /home/pi/Documents/Script

Path to the backup directory (has to be entered in both scripts):

- /home/pi/Documents/Backup

User with which the script has to be executed:

- odoo

4.a) Backup

.. code-block:: shell

   sudo su - odoo -s /bin/bash
   cd /home/pi/Documents/Script
   bash ./backup-dump.sh
   exit

4.b) Restore

.. code-block:: shell

   sudo su - odoo -s /bin/bash
   cd /home/pi/Documents/Script
   bash ./restore-dump.sh
   exit