Hi, Can you do some tests in both (Mac and Windows ) ?
* telnet {IP_Server} {5432}
* ping {IP_Server}
* tracert {IP_Server}
Regards
__
Saludos
Ing. Ricardo Martín Gomez
DBA - SysAdmin
De: Adrian Klaver
Enviado: martes, 5 de febrero
You are right. So it is not suitable for your case. Sorry
Le mar. 5 févr. 2019 à 19:27, Ravi Krishna a écrit :
> >
> >
> https://www.cybertec-postgresql.com/en/idle_in_transaction_session_timeout-terminating-idle-transactions-in-postgresql/
> >
> > And use alter role in database set idle_in_tran
Or you could use
Parameter idle_in_transaction_session_timeout
https://www.cybertec-postgresql.com/en/idle_in_transaction_session_timeout-terminating-idle-transactions-in-postgresql/
And use alter role in database set idle_in_transaction_session_timeout to...
https://www.postgresql.org/docs/10/s
Hi,
Maybe pgterminator could help you
https://github.com/trustly/pgterminator
Regards
Thomas
Le mar. 5 févr. 2019 à 18:52, Pavel Stehule a
écrit :
> Hi
>
>
> út 5. 2. 2019 v 18:47 odesílatel Emi napsal:
>
>> Hello,
>>
>> In psql, may I know is there a way/config that idle connections could be
>
Hi
út 5. 2. 2019 v 18:47 odesílatel Emi napsal:
> Hello,
>
> In psql, may I know is there a way/config that idle connections could be
> auto closed (but not by pg_cancel_backend command) for specific user(s)
> please?
>
> For example,
> select usename, waiting, query_start from pg_stat_activi
Hello,
In psql, may I know is there a way/config that idle connections could be
auto closed (but not by pg_cancel_backend command) for specific user(s)
please?
For example,
select usename, waiting, query_start from pg_stat_activity
where usename like 'connUser1' and
current_query
On 2/5/19 7:18 AM, Maximilian Tyrtania wrote:
Hi,
On 5. Feb 2019, at 15:57, Adrian Klaver wrote:
On 2/5/19 1:48 AM, Maximilian Tyrtania wrote:
For some reason I can't connect to my PG 10.6.1 Server (running on Ubuntu) from
my Windows installation (run via Parallels on my Mac), no matter wha
Hi,
> On 5. Feb 2019, at 15:57, Adrian Klaver wrote:
>
> On 2/5/19 1:48 AM, Maximilian Tyrtania wrote:
>> For some reason I can't connect to my PG 10.6.1 Server (running on Ubuntu)
>> from my Windows installation (run via Parallels on my Mac), no matter what
>> app I use (tried psql, PGAdmin a
On 2/5/19 1:48 AM, Maximilian Tyrtania wrote:
For some reason I can't connect to my PG 10.6.1 Server (running on Ubuntu) from
my Windows installation (run via Parallels on my Mac), no matter what app I use
(tried psql, PGAdmin and my own app).
Has it ever connected?
Have you recently update
For some reason I can't connect to my PG 10.6.1 Server (running on Ubuntu) from
my Windows installation (run via Parallels on my Mac), no matter what app I use
(tried psql, PGAdmin and my own app).
When trying to connect from PGAdmin 4 the server logs say:
2019-02-05 10:34:30.558 CET [31051]
On 31/01/2019 18:53, Bruce Momjian wrote:
> On Thu, Jan 31, 2019 at 05:37:00PM +0100, Piotr Włodarczyk wrote:
>> Our administrator have some doubt about this extension. He asked us, are we
>> sure that this extension safe enough and didn't make any kernel panic
>> sytuation
>> beacuse as all anoth
11 matches
Mail list logo
