Re: Edb Jdbc Ssl Connection

2021-01-31 Thread ayagmur75
 42.2.9 and java 8 u162 have worked.31.01.2021, 08:51, "ayagmu...@yandex.com" :I want to establish simple jdbc ssl connection using edb as 11 and java 8 u271 with postgresql jdbc driver 42.2.9 (I have also tried these versions: 42.2.18 and 42.2.8).I followed the instructions from the following

Re: Offlne Slony Installation

2021-01-31 Thread ayagmur75
I had cut the error message. Full is "could not open file c:servershare/slony1_base.2.2.8.sql". slonik  version is 2.2.8. When I set SLONY_SHARE_DIR to default installation directory (c:\program files\edb\as13\share) it works quite well. Thank you very much. 01.02.2021, 00:18, "Steve Singer" :On Su

Re: Occasional lengthy locking causing stalling on commit

2021-01-31 Thread Ben Hoskings
On Mon, 1 Feb 2021 at 10:33, Tom Lane wrote: > > One thing that just occurred to me is that you might find it > interesting to keep tabs on what's in the $PGDATA/pg_notify > directory. Do the performance burps correspond to transitory > peaks in the amount of data there? Or (grasping at straws h

Re: Occasional lengthy locking causing stalling on commit

2021-01-31 Thread Tom Lane
Ben Hoskings writes: > I wonder if there are any likely candidates that we could look into - > for example, is it possible it could be due a batched index update > that we could alleviate with "fastupdate=off"? No. This is late enough in the commit code path that we really don't want to be runni

Re: Occasional lengthy locking causing stalling on commit

2021-01-31 Thread Ben Hoskings
On Sun, 31 Jan 2021 at 03:50, Tom Lane wrote: > > Possibly you'd benefit from updating to v13, which has the listen/notify > performance improvements Martijn referred to in the other thread. > > It's also possible that the hangup is unrelated to that, being somewhere > later in commit processing t

Re: Offlne Slony Installation

2021-01-31 Thread Steve Singer
On Sun, 31 Jan 2021, ayagmu...@yandex.com wrote: I want to use slony replication tool offline with edb or postgresql. I have been using Windows 10 operating system. For this, I have downloaded enterprise database 13.1 version. After installation I select slony download from stackbuilder plus.