psql_client cpm postgres fromversion toversion - output interpretation

[Don_Paterson]

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';"

[Tomer_Sole]

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. 

[Don_Paterson]

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

[Tomer_Sole]

We will remove it off the course.

The only supported way is Management API.

[Don_Paterson]

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

[Ed_Munoz]

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 

Ed

[Don_Paterson]

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