By checking like below:
Sudo su - postgres
psql
\l (it shows all the databases and its corresponding owner)
And I realize that all my databases owner is Postgres user, not odoo.
So that when I am trying to backup, restore, create database its shows an error message.
Database backup error: Postgres subprocess('/usr/bin/pg_dump, --no-owner, -file=/tmp/tmprem/dump.sql, my_database_name), error 1.
How can solve the issue?
Server 1: odoo 9.0 & Postgresql:9.3 (all the Postgres, pg_dump are the same versions)
Server 2: odoo 11 & Postgresql:9.6 (all the Postgres, pg_dump are the same versions)
Please help me.