Need help to install Sqitch for Potsgresql on Windows

[amita gupta]

Hi All,

I am trying to install Sqitch for Postgres on windows using command  ( cpan install App::Sqitch DBD::Pg ) but i get this below error:

Can you please tell if it installed fine?

Also, once its installed how can i create project in sqitch to manage postgres files?

[David E. Wheeler]

On Jul 30, 2020, at 15:14, amita gupta <me.ami...@gmail.com> wrote:

> Hi All,
>
> I am trying to install Sqitch for Postgres on windows using command ( cpan install App::Sqitch DBD::Pg ) but i get this below error:

> <Auto Generated Inline Image 1.png>

>
> Can you please tell if it installed fine?

Doesn’t seem like it; that’s an unexpected error. I suggest trying `cpanm` instead of `cpan`.

> Also, once its installed how can i create project in sqitch to manage postgres files?

I suggest you follow the tutorial:

https://sqitch.org/docs/manual/sqitchtutorial/

HTH,

David

[amita gupta]

Thank you. 

I have a further question. Can i connect to postgres database installed on a different server or do i need to have it installed locally where sqitch is?

How can sqitch connect to postgres database installed on a different server if that's possible

[David E. Wheeler]

On Aug 3, 2020, at 15:39, amita gupta <me.ami...@gmail.com> wrote:

> I have a further question. Can i connect to postgres database installed on a different server or do i need to have it installed locally where sqitch is?
> How can sqitch connect to postgres database installed on a different server if that's possible

Absolutely. You need to specify a target with the host name, e.g.,

db:pg://different.server.name/your_database

You’ll find some helpful pointers on formatting target URLs in `sqitch help target`:

https://sqitch.org/docs/manual/sqitch-target/

HTH,

David

[amita gupta]

Thanks for you quick response David.

I tried using the target URI but its still looking for local database

i used db:pg://user:password@serverIP:port/databsename

I have masked the actual details but you can see the format. Please help what i am doing wrong.

On Thursday, July 30, 2020 at 2:14:44 PM UTC-5, amita gupta wrote:

[David E. Wheeler]

On Aug 4, 2020, at 11:36, amita gupta <me.ami...@gmail.com> wrote:

> Thanks for you quick response David.
> I tried using the target URI but its still looking for local database
> i used db:pg://user:password@serverIP:port/databsename
>
> I have masked the actual details but you can see the format. Please help what i am doing wrong.

Try quoting it, and be sure you have the latest versions of Sqitch and IPC::System::Simple. There were some fixes for quoting issues on Windows.

Best,

David