Re: oracle_fwd - is it safe or not?

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

Connection issue

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]

Re: Connection issue

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

Re: Connection issue

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

Re: Connection issue

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

Auto close idle connections for specific user (not by pg_cancel command)

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

Re: Auto close idle connections for specific user (not by pg_cancel command)

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

Re: Auto close idle connections for specific user (not by pg_cancel command)

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 >

Re: Auto close idle connections for specific user (not by pg_cancel command)

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

Re: Auto close idle connections for specific user (not by pg_cancel command)

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

RE: Connection issue

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