public inbox for [email protected]help / color / mirror / Atom feed
Concurrently run scipts 7+ messages / 3 participants [nested] [flat]
* Concurrently run scipts @ 2023-10-25 19:57 Shaozhong SHI <[email protected]> 2023-10-25 20:15 ` Re: Concurrently run scipts Bruce Momjian <[email protected]> 0 siblings, 1 reply; 7+ messages in thread From: Shaozhong SHI @ 2023-10-25 19:57 UTC (permalink / raw) To: pgsql-sql <[email protected]> In psql we run scripts sequentially like the following: \ir script1 \ir script2 Is there something similar for concurrent running script? Regards, David ^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Concurrently run scipts 2023-10-25 19:57 Concurrently run scipts Shaozhong SHI <[email protected]> @ 2023-10-25 20:15 ` Bruce Momjian <[email protected]> 2023-10-25 20:42 ` Re: Concurrently run scipts hector vass <[email protected]> 0 siblings, 1 reply; 7+ messages in thread From: Bruce Momjian @ 2023-10-25 20:15 UTC (permalink / raw) To: Shaozhong SHI <[email protected]>; +Cc: pgsql-sql <[email protected]> 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 <[email protected]> https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you. ^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Concurrently run scipts 2023-10-25 19:57 Concurrently run scipts Shaozhong SHI <[email protected]> 2023-10-25 20:15 ` Re: Concurrently run scipts Bruce Momjian <[email protected]> @ 2023-10-25 20:42 ` hector vass <[email protected]> 2023-10-26 08:01 ` Re: Concurrently run scipts Shaozhong SHI <[email protected]> 0 siblings, 1 reply; 7+ messages in thread From: hector vass @ 2023-10-25 20:42 UTC (permalink / raw) To: Bruce Momjian <[email protected]>; +Cc: Shaozhong SHI <[email protected]>; pgsql-sql <[email protected]> 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, <[email protected]> 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 <[email protected]> https://momjian.us > EDB https://enterprisedb.com > > Only you can decide what is important to you. > > > ^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Concurrently run scipts 2023-10-25 19:57 Concurrently run scipts Shaozhong SHI <[email protected]> 2023-10-25 20:15 ` Re: Concurrently run scipts Bruce Momjian <[email protected]> 2023-10-25 20:42 ` Re: Concurrently run scipts hector vass <[email protected]> @ 2023-10-26 08:01 ` Shaozhong SHI <[email protected]> 2023-10-26 09:21 ` Re: Concurrently run scipts hector vass <[email protected]> 0 siblings, 1 reply; 7+ messages in thread From: Shaozhong SHI @ 2023-10-26 08:01 UTC (permalink / raw) To: hector vass <[email protected]>; +Cc: Bruce Momjian <[email protected]>; pgsql-sql <[email protected]> How many scripts can be run concurrently but independently? Regards, David On Wed, 25 Oct 2023 at 21:43, hector vass <[email protected]> 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, <[email protected]> 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 <[email protected]> https://momjian.us >> EDB https://enterprisedb.com >> >> Only you can decide what is important to you. >> >> >> ^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Concurrently run scipts 2023-10-25 19:57 Concurrently run scipts Shaozhong SHI <[email protected]> 2023-10-25 20:15 ` Re: Concurrently run scipts Bruce Momjian <[email protected]> 2023-10-25 20:42 ` Re: Concurrently run scipts hector vass <[email protected]> 2023-10-26 08:01 ` Re: Concurrently run scipts Shaozhong SHI <[email protected]> @ 2023-10-26 09:21 ` hector vass <[email protected]> 2023-10-26 09:49 ` Re: Concurrently run scipts Shaozhong SHI <[email protected]> 0 siblings, 1 reply; 7+ messages in thread From: hector vass @ 2023-10-26 09:21 UTC (permalink / raw) To: Shaozhong SHI <[email protected]>; +Cc: Bruce Momjian <[email protected]>; pgsql-sql <[email protected]> max_connections ..which is set in postgresql.conf select * from pg_settings() where setting~'conn' On Thu, 26 Oct 2023, 09:01 Shaozhong SHI, <[email protected]> wrote: > How many scripts can be run concurrently but independently? > > Regards, > > David > > On Wed, 25 Oct 2023 at 21:43, hector vass <[email protected]> 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, <[email protected]> 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 <[email protected]> https://momjian.us >>> EDB https://enterprisedb.com >>> >>> Only you can decide what is important to you. >>> >>> >>> ^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Concurrently run scipts 2023-10-25 19:57 Concurrently run scipts Shaozhong SHI <[email protected]> 2023-10-25 20:15 ` Re: Concurrently run scipts Bruce Momjian <[email protected]> 2023-10-25 20:42 ` Re: Concurrently run scipts hector vass <[email protected]> 2023-10-26 08:01 ` Re: Concurrently run scipts Shaozhong SHI <[email protected]> 2023-10-26 09:21 ` Re: Concurrently run scipts hector vass <[email protected]> @ 2023-10-26 09:49 ` Shaozhong SHI <[email protected]> 2023-10-26 13:50 ` Re: Concurrently run scipts hector vass <[email protected]> 0 siblings, 1 reply; 7+ messages in thread From: Shaozhong SHI @ 2023-10-26 09:49 UTC (permalink / raw) To: hector vass <[email protected]>; +Cc: Bruce Momjian <[email protected]>; pgsql-sql <[email protected]> Thanks. I am aware of that concurrent running of scripts can be done in Linux. But, my users prefer to run these in PgAdmin. Can such concurrent run be automated in PgAmin? Regards, David On Thu, 26 Oct 2023 at 10:21, hector vass <[email protected]> wrote: > max_connections > > ..which is set in postgresql.conf > select * from pg_settings() where setting~'conn' > > > > > On Thu, 26 Oct 2023, 09:01 Shaozhong SHI, <[email protected]> wrote: > >> How many scripts can be run concurrently but independently? >> >> Regards, >> >> David >> >> On Wed, 25 Oct 2023 at 21:43, hector vass <[email protected]> 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, <[email protected]> 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 <[email protected]> https://momjian.us >>>> EDB https://enterprisedb.com >>>> >>>> Only you can decide what is important to you. >>>> >>>> >>>> ^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Concurrently run scipts 2023-10-25 19:57 Concurrently run scipts Shaozhong SHI <[email protected]> 2023-10-25 20:15 ` Re: Concurrently run scipts Bruce Momjian <[email protected]> 2023-10-25 20:42 ` Re: Concurrently run scipts hector vass <[email protected]> 2023-10-26 08:01 ` Re: Concurrently run scipts Shaozhong SHI <[email protected]> 2023-10-26 09:21 ` Re: Concurrently run scipts hector vass <[email protected]> 2023-10-26 09:49 ` Re: Concurrently run scipts Shaozhong SHI <[email protected]> @ 2023-10-26 13:50 ` hector vass <[email protected]> 0 siblings, 0 replies; 7+ messages in thread From: hector vass @ 2023-10-26 13:50 UTC (permalink / raw) To: Shaozhong SHI <[email protected]>; +Cc: Bruce Momjian <[email protected]>; pgsql-sql <[email protected]> Sorry no idea, pgadmin is a web app front end to postgresql so there may be a more appropriate mailing list to ask on than pgsql-sql On Thu, 26 Oct 2023, 10:49 Shaozhong SHI, <[email protected]> wrote: > Thanks. I am aware of that concurrent running of scripts can be done in > Linux. > > But, my users prefer to run these in PgAdmin. Can such concurrent run be > automated in PgAmin? > > Regards, David > > On Thu, 26 Oct 2023 at 10:21, hector vass <[email protected]> wrote: > >> max_connections >> >> ..which is set in postgresql.conf >> select * from pg_settings() where setting~'conn' >> >> >> >> >> On Thu, 26 Oct 2023, 09:01 Shaozhong SHI, <[email protected]> wrote: >> >>> How many scripts can be run concurrently but independently? >>> >>> Regards, >>> >>> David >>> >>> On Wed, 25 Oct 2023 at 21:43, hector vass <[email protected]> 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, <[email protected]> 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 <[email protected]> https://momjian.us >>>>> EDB https://enterprisedb.com >>>>> >>>>> Only you can decide what is important to you. >>>>> >>>>> >>>>> ^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2023-10-26 13:50 UTC | newest] Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2023-10-25 19:57 Concurrently run scipts Shaozhong SHI <[email protected]> 2023-10-25 20:15 ` Bruce Momjian <[email protected]> 2023-10-25 20:42 ` hector vass <[email protected]> 2023-10-26 08:01 ` Shaozhong SHI <[email protected]> 2023-10-26 09:21 ` hector vass <[email protected]> 2023-10-26 09:49 ` Shaozhong SHI <[email protected]> 2023-10-26 13:50 ` hector vass <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox