MIME-Version: 1.0
References: 
 <CAJSrDUojpnXU7gTN51nQ0JO+KzdLJieusMAqm7NYo68UGfv_Ow@mail.gmail.com>
In-Reply-To: 
 <CAJSrDUojpnXU7gTN51nQ0JO+KzdLJieusMAqm7NYo68UGfv_Ow@mail.gmail.com>
From: Erik Brandsberg <erik@heimdalldata.com>
Date: Sun, 10 Sep 2023 13:55:50 -0400
Message-ID: 
 <CAFcck8G2VY682z4uv8+JhK1j1zZ8H7qUx-ccgtjXNXuDvVM7LQ@mail.gmail.com>
Subject: Re: How to handle application connectivity change when moving from
 Oracle to Postgres in GCP
To: kunwar singh <krishsingh.111@gmail.com>
Cc: pgsql-sql@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000003bfa20060504ec61"
Archived-At: 
 <https://www.postgresql.org/message-id/CAFcck8G2VY682z4uv8%2BJhK1j1zZ8H7qUx-ccgtjXNXuDvVM7LQ%40mail.gmail.com>
Precedence: bulk

--0000000000003bfa20060504ec61
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Keep in mind that it is likely that a significant portion of the data
access code may need to be rewritten unless you are using an ORM that does
the conversion for you.  Most apps can't be migrated directly from Oracle
to Postgres.  Based on the questions you are asking, I seriously suggest
you contact a company that assists with migrations in order to answer your
questions and highlight the issues you may be facing.

On Sun, Sep 10, 2023 at 1:43=E2=80=AFPM kunwar singh <krishsingh.111@gmail.=
com>
wrote:

> 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
>

--0000000000003bfa20060504ec61
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Keep in mind that it is likely that a significant portion =
of the data access code may need to be rewritten unless you are using an OR=
M that does the conversion for you.=C2=A0 Most apps can&#39;t be migrated d=
irectly from Oracle to Postgres.=C2=A0 Based on the questions you are askin=
g, I seriously suggest you contact a company that assists with migrations i=
n order to answer your questions and highlight the issues you may be facing=
.=C2=A0=C2=A0</div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D=
"gmail_attr">On Sun, Sep 10, 2023 at 1:43=E2=80=AFPM kunwar singh &lt;<a hr=
ef=3D"mailto:krishsingh.111@gmail.com">krishsingh.111@gmail.com</a>&gt; wro=
te:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px =
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"=
ltr"><div dir=3D"auto">Hi Listers,</div><div dir=3D"auto"><br></div><div>Sa=
y we have this=C2=A0App-&gt;DB connectivity Model.</div><div><br></div><div=
>APP1</div><div>Contains synonyms which point=C2=A0to objects under APP1.</=
div><div><br></div><div>APPOWN</div><div>Contains the tables, indexes</div>=
<div><br></div><div>And it is a Java application that connects to APP1.</di=
v><div><br></div><div>Now when the database is switched from Oracle 19c onp=
rem to CloudSQL Postgres say v15.</div><div>Questions that I have:</div><di=
v><br></div><div>1. What needs to be done at the database end in terms of s=
chema setup in order to ensure the application is able to connect to the re=
levant tables without any concerns?=C2=A0</div><div>2. Do I need to create =
users APP1 and APPOWN=C2=A0in postgres? If so, what privileges are required=
 to be assigned to these?</div><div>3. How to tie them with service account=
s?</div><div>4. With which username/service account does the application ma=
ke=C2=A0 connection to the database?</div><div><br></div><div>I still don&#=
39;t understand user/schema=C2=A0concepts in postgres tbh as I&#39;m still=
=C2=A0a=C2=A0noob :)=C2=A0<div></div><div><br></div></div><div><br></div><d=
iv><br></div><span class=3D"gmail_signature_prefix">-- </span><br><div dir=
=3D"ltr" class=3D"gmail_signature">Cheers,<br>Kunwar</div></div>
</blockquote></div>

--0000000000003bfa20060504ec61--