Re: Concurrently run scipts

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(at)gmail(dot)com> wrote:

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