Offlne Slony Installation
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?Best Regards,
Edb Jdbc Ssl Connection
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-serverI 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.
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.
