topic Re: psql_client cpm postgres fromversion toversion - output interpretation in Firewall and Security Management

psql_client cpm postgres fromversion toversion - output interpretation

Don_Paterson — Mon, 02 Jul 2018 22:22:45 GMT

Can anyone explain the change in version numbers when reviewing the output of this command and how to translate and interpret the fromversion and toversion outputs?

psql_client cpm postgres -c "select objid,dlesession,fromversion,toversion from dleobjectderef_data where name='Corp-FW-1';"

Re: psql_client cpm postgres fromversion toversion - output interpretation

Tomer_Sole — Tue, 03 Jul 2018 03:14:35 GMT

use show-changes. Check Point - Management API reference

we do not support connecting directly to postgres, do not commit on staying in this format, and any direct connection to postgres is unaudited.

Re: psql_client cpm postgres fromversion toversion - output interpretation

Don_Paterson — Tue, 03 Jul 2018 05:30:46 GMT

Thanks Toner,

The command (with only the select command used) is used in the Security Master (CCSM) course labs but there is no explanation for the version number changes (after a single change (color) to and object, and a publish (all in SmartConsole)) so I was looking for an answer to that.

I have seen an SK with the 'alter' psql_client command but that was for something specific missing from a table.

Can you explain the version numbering or point me to a PostgreSQL help file?

Regards,

Don

Re: psql_client cpm postgres fromversion toversion - output interpretation

Tomer_Sole — Tue, 03 Jul 2018 06:07:02 GMT

We will remove it off the course.

The only supported way is Management API.

Re: psql_client cpm postgres fromversion toversion - output interpretation

Don_Paterson — Tue, 03 Jul 2018 06:21:43 GMT

OK. Education is working on a update (V2) at the moment .

There is a two day API specialist course anyway so that covers the that.

The CCSM PostGREs lab is simply exploring the tables after explaining the domains and tables.

Thanks,

Don

Re: psql_client cpm postgres fromversion toversion - output interpretation

Ed_Munoz — Thu, 28 Feb 2019 10:47:15 GMT

Considering that it has been about 8 months since the last comment in this post. I am just wondering whether this content has also been removed from the CCSM R80 exam? Reading the Study Guide content shows "Chapter 1 - Advanced Database Management " which suggest few questions related to DB manipulation.

Extract from the guide

Review how objects are represented in the database.

Which database does R80.x use for storing all objects?

Thanks

Re: psql_client cpm postgres fromversion toversion - output interpretation

Don_Paterson — Thu, 28 Feb 2019 12:33:35 GMT

Hi Ed,

The decision was made not to remove the content from the course and so I expect it will still be in the exam, or at least you will still want to prepare for the exam using the courseware content.

The PostGRESQL database system is use to store all objects but the system is a relational DB system so there are various tables used to store the data. For example the objects may be stored in one table but not all of the properties about the objects, which are stored in another table. I think the book details a bit of that and shows some tables in the labs. Working at that level is probably not recommended outside of a learning lab or if not under the advise of TAC but it is good to know about it for CCSM level people.

https://www.checkpoint.com/downloads/product-related/r80.10-mgmt-architecture-overview.pdf

Hope that helps.

Don