Managing Odoo databases
In the previous section, we learned how to create and initialize new Odoo databases from the command line. There are more commands worth knowing about to manage Odoo databases.
The Odoo server automatically creates the new PostgreSQL database for us. But we can also do that manually using the following command:
$ createdb MyDBName
This command can be used with the --template option to copy a database. The copied database can't have open connections for this to work. So, make sure that any Odoo instance using it has been stopped.
Tip
When running PostgreSQL in WSL, it may be the case that some operations display a message such as WARNING: could not flush dirty data: Function not implemented. A workaround for this is to modify the PostgreSQL configuration file. For version 12, it should be at /etc/postgresql/12/main/postgresql.conf. Edit it at add two lines, fsync = off and data_sync_retry = true. Then, restart the PostgreSQL server...
