cancel
Showing results for 
Search instead for 
Did you mean: 
Post a Question
Highlighted

psql_client cpm postgres fromversion toversion - output interpretation

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

Tags (1)
6 Replies

Re: psql_client cpm postgres fromversion toversion - output interpretation

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. 

0 Kudos

Re: psql_client cpm postgres fromversion toversion - output interpretation

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

0 Kudos

Re: psql_client cpm postgres fromversion toversion - output interpretation

We will remove it off the course.

The only supported way is Management API.

0 Kudos

Re: psql_client cpm postgres fromversion toversion - output interpretation

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
Iron

Re: psql_client cpm postgres fromversion toversion - output interpretation

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

0 Kudos

Re: psql_client cpm postgres fromversion toversion - output interpretation

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

0 Kudos