omnidb syntax

Dear All,

Could you please advise what I may be doing  wrong with omnidb syntax (DP 24.4 but on other versions it's the same). I would need to get the list of WAL files taken by a backup session.

I’ve retrieved object and session-ID with the following command:

PS C:\> omnidb -object -integ PostgreSQL

Object Name                                                     Object type

===============================================================================

pg-rhel.hited.kz:D1:/DATA:0                                     PostgreSQL

pg-rhel.hited.kz:D1:/DATA:3                                     PostgreSQL

pg-rhel.hited.kz:D1:/DATA:4                                     PostgreSQL

pg-rhel.hited.kz:D1:/DATA:1                                     PostgreSQL

pg-rhel.hited.kz:D1:/DATA:2                                     PostgreSQL

pg-rhel.hited.kz:D1:/METADATA:0                                 PostgreSQL

pg-rhel.hited.kz:D1:/METADATA:1                                 PostgreSQL

pg-rhel.hited.kz:D1:/WAL:3                                      PostgreSQL

pg-rhel.hited.kz:D1:/WAL:4                                      PostgreSQL

pg-rhel.hited.kz:D1:/WAL:2                                      PostgreSQL

pg-rhel.hited.kz:D1:/WAL:0                                      PostgreSQL

pg-rhel.hited.kz:D1:/WAL:1                                      PostgreSQL

 

But when I try to output the catalog of this object, I get the error:

PS C:\> omnidb pg-rhel.hited.kz:D1:/WAL:3 -session 2024/12/05-5 -catalog

Usage synopsis:

 

omnidb -version | -help

 

omnidb -session [ -datalist Datalist] [-type { restore | backup | verification } ] [-user User]

       [ [-since Date] [-until Date] | -last Number | -latest |

         -wo start duration ]

       [ -detail ]

 

It looks like a syntax error. I've tried putting the name of the object in double quotes, but it doesn't help.

Thank you!

  • Verified Answer

    +1  

    Please check the manual page for omnidb

    omnidb Object [ -noexpand ] -session SessionID [ -copyid CopyID ] [ -report [ warning | minor | major | critical ] | -change_protection Protection | -change_catprotection Protection | -strip | -catalog | -encryptioninfo ]

    In general your syntax is fine, only if you scroll down on the page then you'll notice the meaning of "Object". Besides other possibilities, the following is seen for PostgreSQL:

    -integ PostgreSQL Host:Set

    So adding "-integ PostgreSQL" should resolve your problem.