MIME-Version: 1.0
References: 
 <CA+i5JwbNtevizuSK5L_pBotXSDary=mxjjO=SpFn3ktciGbOBg@mail.gmail.com>
 <ZTl3cYVrLibngxAS@momjian.us>
In-Reply-To: <ZTl3cYVrLibngxAS@momjian.us>
From: hector vass <hector.vass@gmail.com>
Date: Wed, 25 Oct 2023 21:42:50 +0100
Message-ID: 
 <CAJJx+iVhpkKtm=MGNOMSedEsOOHpqeZ+=Vvjj_5n5-sCdH5U6Q@mail.gmail.com>
Subject: Re: Concurrently run scipts
To: Bruce Momjian <bruce@momjian.us>
Cc: Shaozhong SHI <shishaozhong@gmail.com>,
 pgsql-sql <pgsql-sql@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000045edaa06089080e7"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJJx%2BiVhpkKtm%3DMGNOMSedEsOOHpqeZ%2B%3DVvjj_5n5-sCdH5U6Q%40mail.gmail.com>
Precedence: bulk

--00000000000045edaa06089080e7
Content-Type: text/plain; charset="UTF-8"

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

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

<div dir=3D"auto"><div>Concurrently but independently=C2=A0</div><div dir=
=3D"auto">psql -f script1 &amp; psql -f script2 &amp;&amp; fg</div><div dir=
=3D"auto">Similar in windows can be achieved using start iirc<br><br><div c=
lass=3D"gmail_quote" dir=3D"auto"><div dir=3D"ltr" class=3D"gmail_attr">On =
Wed, 25 Oct 2023, 21:15 Bruce Momjian, &lt;<a href=3D"mailto:bruce@momjian.=
us">bruce@momjian.us</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quo=
te" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"=
>On Wed, Oct 25, 2023 at 08:57:03PM +0100, Shaozhong SHI wrote:<br>
&gt; In psql=C2=A0 we run scripts sequentially like the following:<br>
&gt; <br>
&gt; \ir script1<br>
&gt; \ir script2<br>
&gt; <br>
&gt; <br>
&gt; Is there something similar for concurrent running script?<br>
<br>
Uh, yeah, see the use of \! and &amp; starting on slide 59:<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 <a href=3D"https://momjian.us/main/writings/pgs=
ql/locking.pdf" rel=3D"noreferrer noreferrer" target=3D"_blank">https://mom=
jian.us/main/writings/pgsql/locking.pdf</a><br>
<br>
-- <br>
=C2=A0 Bruce Momjian=C2=A0 &lt;<a href=3D"mailto:bruce@momjian.us" target=
=3D"_blank" rel=3D"noreferrer">bruce@momjian.us</a>&gt;=C2=A0 =C2=A0 =C2=A0=
 =C2=A0 <a href=3D"https://momjian.us" rel=3D"noreferrer noreferrer" target=
=3D"_blank">https://momjian.us</a><br>
=C2=A0 EDB=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 <a hr=
ef=3D"https://enterprisedb.com" rel=3D"noreferrer noreferrer" target=3D"_bl=
ank">https://enterprisedb.com</a><br>
<br>
=C2=A0 Only you can decide what is important to you.<br>
<br>
<br>
</blockquote></div></div></div>

--00000000000045edaa06089080e7--