| From: | Shaozhong SHI <shishaozhong(at)gmail(dot)com> |
|---|---|
| To: | hector vass <hector(dot)vass(at)gmail(dot)com> |
| Cc: | Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Concurrently run scipts |
| Date: | 2023-10-26 08:01:14 |
| Message-ID: | CA+i5Jwb7JYeY=33w-+y4UP1vvhZkJS1Lyqur3Uf3okAyMuaErQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
How many scripts can be run concurrently but independently?
Regards,
David
On Wed, 25 Oct 2023 at 21:43, hector vass <hector(dot)vass(at)gmail(dot)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(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 | hector vass | 2023-10-26 09:21:26 | Re: Concurrently run scipts |
| Previous Message | hector vass | 2023-10-25 20:42:50 | Re: Concurrently run scipts |