nec-postgres / tdeforpg

PostgreSQL Transparent Data Encryption tool development
Other
88 stars 18 forks source link

English translation of manual - Attached #8

Open tadam98 opened 6 years ago

tadam98 commented 6 years ago

Attached please find my google english translation of the manual.

Manual (EN) · nec-postgres _ tdeforpg Wiki · GitHub.pdf.docx

Question: Should the free TDE also work with Postgres 10.X ?

Best, Mickey Cohen mickey@shanit.co.il

bocaph commented 6 years ago

Thanks for the comment. We are planning to release a new Free Edition version which includes support for PostgreSQL 10 in the next few months.

tadam98 commented 6 years ago

Thank you. Could you add a line in the README file of the project: "Compile with maven and ant with the command 'ant all'"

Thanks you, Mickey cohen

tadam98 commented 6 years ago

Apparently I had the previous version. I downloaded the new version and not sure about the compilation and testing procedure under maven. I did a sequence of: maven pre-clean maven initialize maven compile maven install

And... I got many errors. I started postgres so the tests have a port at 5432 that answers. Still many errors.

But, please provide a simple text on the correct way to compile, install, test and use? In my Ubuntu the final driver should be placed in $JAVA_HOME/jre/lib/ext and renamed to postgres.jar when I do this the test program in the manual worked with the previous version.

Thanks, Mickey Cohen PS. Previous version nicely as documented. When finished, I will update the attached English manual to reflect my current experience.

bocaph commented 6 years ago

Build of Postgresql JDBC Driver for TDEforPG is the same as PostgreSQL JDBC Driver.

In our environment. We build fine with the following command.

<maven installed directory>/mvn package -DskipTests

With JDK1.7 you can build as below.

cd pgjdbc-jre7/
<maven installed directory>/mvn package -DskipTests

For more detail please reference in the PostgreSQL JDBC Page

But why do you need to build it?
You can download the latest version which we have just released from here.

Thanks for the attached Document, we appreciate it.

regards,

tadam98 commented 6 years ago

I have built it with Netbeans 8.2 by selecting "jar" project and got the attached. postgresjdbc.zip

"But why do you need to build it?" -> I am a developer I enjoy seeing the nice work of others. Also, I work with NEC on biometrics. And enjoy it too.

What is the difference between the *.jar files?

/mvn package -DskipTests ==> **Worked fine**. What do I need to do to run the tests too ? Please wait with the English document, I will update it further when I finish my tests. Then, you have permission to take ownership of it and publish/modify it as you see needed.
bocaph commented 6 years ago

I am a developer I enjoy seeing the nice work of others. Also, I work with NEC on biometrics. And enjoy it too.

Wellcome!

You can find the detail about the build for PostgreSQL JDBC Driver from here. As above page mentioned "PgJDBC doesn't natively support building from IDEs like Eclipse, NetBeans", so you need building with the mvn command.

What is the difference between the *.jar files?

The JDBC Driver for TDEforPG is postgresql-tdeforpg-42.2.1.jar. pgjdbc-aggregate-42.2.1-site.jar is not a Driver, it is just about a JDBC Driver WebPage related to maven.

About test, you should config the build.properties to access your PostgreSQL server and others before building with the test. Please find the detail from here.

We tested JDBC Driver for TDEforPG with our own test package. Related to Enterprise Edition License, We do not public it.

Thanks,

bocaph commented 6 years ago

Hi Mickey Cohen, Just want to remind you that PostgreSQL 10 supported TDEforPG V1.2.1 Free Edition has just released.