Hey Rama,
The hosts in the AMO - Database - User device service are responsible to hold the AMO customer data in postgres database.
'Is it possible to request that only data is stored in local DB (Oracle or Postgres)?' - Not sure about this one.
Regards,
Shivani