Re: Offlne Slony Installation
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. Then I copied these 2 files to offline windows 10 machine. I install both of them. After that, i try to run a simple slonik script to setup master. while executing "init cluster" command i get file not found error, c:servershare/slony1_base.2.8.sql. Do you have an idea what is going on? 1. Does the file c:\servershare\slony1_base.2.8.sql exist ? This looks very strange, I would expect the file for 2.2.8 to be named slony1_base.2.2.8.sql What version of slony did you install? (slonik -v should return this) If the slony files are installed in a different location you could try setting the environment variable SLONY_SHARE_DIR to the location that the slony1 .sql files are in. Steve Best Regards,
Re: Occasional lengthy locking causing stalling on commit
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 than where the notify traffic gets dumped out. > If you could identify which process has the "database 0" lock during one > of these delays, and capture a stack trace from it, that would be > super-informative. Not sure about a good way to do that though. > Maybe you could automate tailing the log for "DETAIL: Process holding the > lock: nnn." and gdb'ing that process. > > regards, tom lane Thanks for the reply Tom. We're running on Google Cloud SQL so we won't be able to use gdb - unless we can convince Google to run it for us :) 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"? Cheers Ben
Re: Occasional lengthy locking causing stalling on commit
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 running anything that would take a long time or have a significant probability of failure. So I'm a bit mystified as to what it could be. Ockham's razor suggests that it's the notify processing itself, as you seem to be an outlier in how heavily you're using that; but that's no sure thing. 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 here...) wraparound of the file names back to ? regards, tom lane
Re: Occasional lengthy locking causing stalling on commit
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 here...) > wraparound of the file names back to ? We don't have filesystem access on Cloud SQL - the downside of the managed route :) It sounds like it might be time to bump the pg13 upgrade up the TODO list. Cheers Ben
Re: Offlne Slony Installation
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 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. Then I copied these 2 files to offline windows 10 machine. I install both of them. After that, i try to run a simple slonik script to setup master. while executing "init cluster" command i get file not found error, c:servershare/slony1_base.2.8.sql. Do you have an idea what is going on?1. Does the file c:\servershare\slony1_base.2.8.sql exist ?This looks very strange, I would expect the file for 2.2.8 to be named slony1_base.2.2.8.sqlWhat version of slony did you install?(slonik -v should return this)If the slony files are installed in a different location you could try setting the environment variableSLONY_SHARE_DIR to the location that the slony1 .sql files are in.Steve Best Regards,
Re: Edb Jdbc Ssl Connection
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 link.https://www.enterprisedb.com/postgres-tutorials/how-enable-ssl-authentication-edb-postgres-advanced-server I tested ssl connection successfully using "psql". But I cannot establish a jdbc connection. I got "FATAL: connection requires a valid client certificate" error. After a little googling, I want to use a different url than specified here just to consume all the possibilities. After modifiying the url with "sslcert=./test/client.crt sslkey=./test/client.key sslrootcert=./test/server.crt" I got "SSLSocket duplex close failed". Could you please help me with this problem? Thanks for you in advance.
