Postgres Pro
Downloads
Home   >   mailing lists

Re: Concurrently run scipts - Mailing list pgsql-sql

From hector vass
Subject Re: Concurrently run scipts
Date
Msg-id CAJJx+iVextjyh4XFaTVA5qdMnrpHJ=8EN0q58N=cSOeHkUHHvQ@mail.gmail.com
Whole thread Raw
In response to Re: Concurrently run scipts  (Shaozhong SHI <shishaozhong@gmail.com>)
Responses Re: Concurrently run scipts
List pgsql-sql
Tree view
max_connections

..which is set in postgresql.conf
select * from pg_settings() where setting~'conn'




On Thu, 26 Oct 2023, 09:01 Shaozhong SHI, <shishaozhong@gmail.com> wrote:
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: Shaozhong SHI
Date:
Subject: Re: Concurrently run scipts
Next
From: Shaozhong SHI
Date:
Subject: Re: Concurrently run scipts