Postgres Pro
Downloads
Home   >   mailing lists

Re: Concurrently run scipts - Mailing list pgsql-sql

From Shaozhong SHI
Subject Re: Concurrently run scipts
Date
Msg-id CA+i5Jwb7JYeY=33w-+y4UP1vvhZkJS1Lyqur3Uf3okAyMuaErQ@mail.gmail.com
Whole thread Raw
In response to Re: Concurrently run scipts  (hector vass <hector.vass@gmail.com>)
Responses Re: Concurrently run scipts
List pgsql-sql
Tree view
How many scripts can be run concurrently but independently?

Regards,

David

On Wed, 25 Oct 2023 at 21:43, hector vass <hector.vass@gmail.com> wrote:
Concurrently but independently 
psql -f script1 & psql -f script2 && fg
Similar in windows can be achieved using start iirc

On Wed, 25 Oct 2023, 21:15 Bruce Momjian, <bruce@momjian.us> wrote:
On Wed, Oct 25, 2023 at 08:57:03PM +0100, Shaozhong SHI wrote:
> In psql  we run scripts sequentially like the following:
>
> \ir script1
> \ir script2
>
>
> Is there something similar for concurrent running script?

Uh, yeah, see the use of \! and & starting on slide 59:

        https://momjian.us/main/writings/pgsql/locking.pdf

--
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Only you can decide what is important to you.


pgsql-sql by date:

Previous
From: hector vass
Date:
Subject: Re: Concurrently run scipts
Next
From: hector vass
Date:
Subject: Re: Concurrently run scipts