| From: | hector vass <hector(dot)vass(at)gmail(dot)com> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | Shaozhong SHI <shishaozhong(at)gmail(dot)com>, pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Concurrently run scipts |
| Date: | 2023-10-25 20:42:50 |
| Message-ID: | CAJJx+iVhpkKtm=MGNOMSedEsOOHpqeZ+=Vvjj_5n5-sCdH5U6Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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(at)momjian(dot)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(at)momjian(dot)us> https://momjian.us
> EDB https://enterprisedb.com
>
> Only you can decide what is important to you.
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shaozhong SHI | 2023-10-26 08:01:14 | Re: Concurrently run scipts |
| Previous Message | Bruce Momjian | 2023-10-25 20:15:45 | Re: Concurrently run scipts |