Обсуждение: Could not startup new database - Oracle to Postgres Migration error.

The information contained in this message is proprietary and/or confidential. If you are not the intended recipient, please: (i) delete the message and all copies; (ii) do not disclose, distribute or use the message in any manner; and (iii) notify the sender immediately. In addition, please be aware that any message addressed to our domain is subject to archiving and review by persons other than the intended recipient. Thank you.

On Mon, Aug 16, 2021 at 4:46 PM Pansara, Jiten
<Jiten.Pansara@fisglobal.com> wrote:
>
> I was following Ora2Pg : Migrates Oracle to PostgreSQL (darold.net) to migrate the db and am stuck when trying to
executebelow command.
 
>
> perl -MCPAN -e 'install DBD::Pg'

It would be better to send the error in plain text rather than a
picture.  It looks like the DBD::Pg install script tries to start a
postgres instance, which failed in your case.

However, I think that strawberry perl already ships DBD::Pg, or at
least the version shipped by chocolatey
(https://community.chocolatey.org/packages/StrawberryPerl).  Can you
check if that's your case?

perl -e "use DBD::Pg"

if no error is shown then the module is already installed.

Hello,

Thanks a lot for quick response. I can see below after executing the Perl command given by you.

PS C:\ora2pg-22.1> perl -e "use DBD::Pg"
PS C:\ora2pg-22.1>


Jiten Pansara
Senior Database Analyst
T:  +91 9158149600




-----Original Message-----
From: Julien Rouhaud <rjuju123@gmail.com>
Sent: Monday, August 16, 2021 2:41 PM
To: Pansara, Jiten <Jiten.Pansara@fisglobal.com>
Cc: pgsql-general@lists.postgresql.org
Subject: EXTERNAL: Re: Could not startup new database - Oracle to Postgres Migration error.

CAUTION: This email originated from outside of the company. Do not click links or open attachments unless you recognize
thesender and know the content is safe. 



On Mon, Aug 16, 2021 at 4:46 PM Pansara, Jiten <Jiten.Pansara@fisglobal.com> wrote:
>
> I was following Ora2Pg : Migrates Oracle to PostgreSQL (darold.net) to migrate the db and am stuck when trying to
executebelow command. 
>
> perl -MCPAN -e 'install DBD::Pg'

It would be better to send the error in plain text rather than a picture.  It looks like the DBD::Pg install script
triesto start a postgres instance, which failed in your case. 

However, I think that strawberry perl already ships DBD::Pg, or at least the version shipped by chocolatey
(https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcommunity.chocolatey.org%2Fpackages%2FStrawberryPerl&data=04%7C01%7Cjiten.pansara%40fisglobal.com%7C61426af9b9cf4f9226ed08d96095c993%7Ce3ff91d834c84b15a0b418910a6ac575%7C0%7C0%7C637647018713742305%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=TO%2FaVAA6qkX3iOhxLKKXq%2FpwJyHvTFTHBLxtc94WS1Q%3D&reserved=0).
Can you check if that's your case? 

perl -e "use DBD::Pg"

if no error is shown then the module is already installed.
The information contained in this message is proprietary and/or confidential. If you are not the intended recipient,
please:(i) delete the message and all copies; (ii) do not disclose, distribute or use the message in any manner; and
(iii)notify the sender immediately. In addition, please be aware that any message addressed to our domain is subject to
archivingand review by persons other than the intended recipient. Thank you. 

On Mon, Aug 16, 2021 at 5:16 PM Pansara, Jiten
<Jiten.Pansara@fisglobal.com> wrote:
>
> Thanks a lot for quick response. I can see below after executing the Perl command given by you.
>
> PS C:\ora2pg-22.1> perl -e "use DBD::Pg"
> PS C:\ora2pg-22.1>

It means that you already have DBD::Pg installed.