How to handle application connectivity change when moving from Oracle to Postgres in GCP

Поиск
Список
Период
Сортировка
От kunwar singh
Тема How to handle application connectivity change when moving from Oracle to Postgres in GCP
Дата
Msg-id CAJSrDUojpnXU7gTN51nQ0JO+KzdLJieusMAqm7NYo68UGfv_Ow@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to handle application connectivity change when moving from Oracle to Postgres in GCP  (Erik Brandsberg <erik@heimdalldata.com>)
RE: How to handle application connectivity change when moving from Oracle to Postgres in GCP  ("Mike Sofen" <msofen@runbox.com>)
Список pgsql-sql
Hi Listers,

Say we have this App->DB connectivity Model.

APP1
Contains synonyms which point to objects under APP1.

APPOWN
Contains the tables, indexes

And it is a Java application that connects to APP1.

Now when the database is switched from Oracle 19c onprem to CloudSQL Postgres say v15.
Questions that I have:

1. What needs to be done at the database end in terms of schema setup in order to ensure the application is able to connect to the relevant tables without any concerns? 
2. Do I need to create users APP1 and APPOWN in postgres? If so, what privileges are required to be assigned to these?
3. How to tie them with service accounts?
4. With which username/service account does the application make  connection to the database?

I still don't understand user/schema concepts in postgres tbh as I'm still a noob :) 



--
Cheers,
Kunwar

В списке pgsql-sql по дате отправления:

Предыдущее
От: Erik Brandsberg
Дата:
Сообщение: Re: index not being used
Следующее
От: Erik Brandsberg
Дата:
Сообщение: Re: How to handle application connectivity change when moving from Oracle to Postgres in GCP