1. Forum
  2. Usenet
  3. COMP.DATABASES.INGRES

  • [Info-ingres] Checkpoint Options

    From Karl Schendel@21:1/5 to All on Tue Jul 6 08:47:21 2021
    On Jul 6, 2021, at 8:39 AM, Steve <s.anderson.au@gmail.com> wrote:

    Hi folks

    Our backup script has the following checkpoint command:

    ckpdb '-timeout=03:00' '#x' '#m14' mydatabase

    What is the #x option? It's literally #x. Could it be some obsolete option?


    The #x option enables some ckpdb tracing to a file named ckpdb.dbg.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Martin Bowes@21:1/5 to Steve on Tue Jul 6 12:48:27 2021
    To: info-ingres@lists.planetingres.org (info-ingres@lists.planetingres.org)

    Hi Steve.

    The #x is a debug feature. It will cause the creation of a file ckpdb.dbg ... the purpose of which is unknown to me.

    Marty

    -----Original Message-----
    From: Steve <s.anderson.au@gmail.com>
    Sent: 06 July 2021 13:39
    To: info-ingres@lists.planetingres.org
    Subject: [Info-ingres] Checkpoint Options

    Hi folks

    Our backup script has the following checkpoint command:

    ckpdb '-timeout=03:00' '#x' '#m14' mydatabase

    What is the #x option? It's literally #x. Could it be some obsolete option?

    The command runs fine.

    Thanks
    Steve

    _______________________________________________
    Info-ingres mailing list
    Info-ingres@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Steve@21:1/5 to Martin Bowes on Mon Jul 12 04:52:40 2021
    On Tuesday, July 6, 2021 at 10:50:09 PM UTC+10, Martin Bowes wrote:
    Hi Steve.

    The #x is a debug feature. It will cause the creation of a file ckpdb.dbg ... the purpose of which is unknown to me.

    Marty
    -----Original Message-----
    From: Steve <s.ande...@gmail.com>
    Sent: 06 July 2021 13:39
    To: info-...@lists.planetingres.org
    Subject: [Info-ingres] Checkpoint Options

    Hi folks

    Our backup script has the following checkpoint command:

    ckpdb '-timeout=03:00' '#x' '#m14' mydatabase

    What is the #x option? It's literally #x. Could it be some obsolete option?

    The command runs fine.

    Thanks
    Steve
    _______________________________________________
    Info-ingres mailing list
    Info-...@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres

    Thanks Karl, Martin.

    After posting my question I did see the ckpdb.dbg file in the checkpoint directory and put two and two together.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)