Error reloading postgresql db from backup when name includes dots like a domain name [#69394]

Submitted by rizzopablo on Wed, 07/01/2020 - 20:53

I have a postgres database named the same than the owner domain (this is how Odoo ERP manages multiple domain instances) Then backup is made ok:

 Dumping MySQL database travellers_db ..
.. done

Dumping PostgresSQL database travellers_db ..
.. done

Dumping PostgresSQL database travellers.com.ar ..
.. done

Copying Procmail and SpamAssassin configuration files ..
.. done

Backing up Webmin ACL files ..
.. done

Backing up AWstats configuration file ..
.. done

Creating TAR file of home directory ..
.. done

but restore fails this way:

 Re-loading MySQL database travellers_db ..

.. done

Re-loading PostgreSQL database travellers.com.ar ..

    Creating PostgreSQL database travellers.com.ar ..
    Restore failed : SQL create database "travellers"."com"."ar" with owner="travellers" failed : syntax error at or near "."

Status:

Active