From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: X-Spam-Checker-Version: SpamAssassin 3.4.1 (2015-04-28) on sa.local.altlinux.org X-Spam-Level: X-Spam-Status: No, score=-2.0 required=5.0 tests=BAYES_00,DKIM_SIGNED, DKIM_VALID,DKIM_VALID_AU,FREEMAIL_FROM autolearn=ham autolearn_force=no version=3.4.1 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:to:subject:message-id:date:user-agent:mime-version :content-transfer-encoding:content-language; bh=wvQ+abFReJUtLilSFF8bDVemySrNBZa++SecSvsdu+Q=; b=JXeANSzOclMNXs1vNp7a66HaHt7FUMdPLTXYO/LrAAtKW6zeXdwaw0ZeeFXjLZTfLj mkZYOWDsfu+m/sPUyoZMmsbB914XRDyPi8l8yuEPrXEzyHRsu8h/4JFKT01nBB9Nrts3 pgvM8X/jvXu464FZFtQjtEdleiQvNQHDDuKbxcae5ABbq14lhY/dLc4RAywQ7peZAUnz VPUBbcKaULamzeGOm8vIgW6M7dV42xfhaCvYqyt5iYht3n/485bPFblmoZJIq55vgm8U tTJ3eIrtFnXOnj02SHquyznKEMSPynxxlsjfD0y9dmT9bXPH0qkyGSqFHac16CoGa6jm xkYg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:to:subject:message-id:date:user-agent :mime-version:content-transfer-encoding:content-language; bh=wvQ+abFReJUtLilSFF8bDVemySrNBZa++SecSvsdu+Q=; b=TkqPee2FXGSjqj1oI6BNVLGB+pMO0QQ48mobXIOUWfoZUzWEJQLG5vFNpQfuWjfpts /Ey93rpUUz3darE03h4PWcTsm/HDJfrnmSmZb5eluiZQKLiArJ5TSnLp/Tn3ybjUDP8g eRjdV6QQXj7B6/oF8Fq3uxe27brUPL5jRv0CDgdpn8Pbm1cNHc67yg+TKuMwc3dU3f5A zOxcfxPqccPcncjwG2on16/uFcKqZzuTf1MVBjOxh9Ux4dvNyLcbQZTPf5rEQlsdp/V7 SAntOtcXjJlgAhObMCNBGPj8yKOmM2hrSBgI0EYQ10tn8J/xV/WhTce2fphJGHcadZNB 1L2Q== X-Gm-Message-State: AOAM530XA+Kar50V8sRJH52aoutrfFeqfvDHBfupIZpah/X+KTLPH4c1 dyDuLsyFzdVYsgSx9igV62lTS9mw5N8= X-Google-Smtp-Source: ABdhPJxB50lbA7lerIo+F0s1I7PrJ6okH2GTjay1eB23qeA0p2RpML7GOjgraSdKcHX2s/qVUoMrHA== X-Received: by 2002:ac2:5dcc:: with SMTP id x12mr1166949lfq.648.1619068820482; Wed, 21 Apr 2021 22:20:20 -0700 (PDT) From: "=?UTF-8?B?0JLQsNC00LjQvCDQmNC70LvQsNGA0LjQvtC90L7Qsg==?=" X-Google-Original-From: =?UTF-8?B?0JLQsNC00LjQvCDQmNC70LvQsNGA0LjQvtC90L7Qsg==?= To: sysadmins@lists.altlinux.org Message-ID: <7df1632f-5992-7c58-3fec-ec1b79e9418e@gmail.com> Date: Thu, 22 Apr 2021 13:20:18 +0800 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.8.0 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US Subject: [Sysadmins] Postgre+TimescaleDB X-BeenThere: sysadmins@lists.altlinux.org X-Mailman-Version: 2.1.12 Precedence: list Reply-To: ALT Linux sysadmins' discussion List-Id: ALT Linux sysadmins' discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 22 Apr 2021 05:20:26 -0000 Archived-At: List-Archive: Доброго дня. Помнится, находил инструкцию, как (именно в Альте) настроить сабж, и делал всё по ней -- теперь что-то не могу нагуглить. На альт-вики тоже ни слова про TimescaleDB. Так вот, в конфигезадано shared_preload_libraries = 'timescaledb', нужная таблица в базе выглядит как надо: netxms=# \dx                                     Список установленных расширений      Имя     | Версия |   Схема    | Описание -------------+--------+------------+-------------------------------------------------------------------  plpgsql     | 1.0    | pg_catalog | PL/pgSQL procedural language  timescaledb | 2.0.1  | public     | Enables scalable inserts and complex queries for time-series data (2 строки) Тем не менее не удаётся поужимать чанки: netxms=# ALTER TABLE audit_log SET ( netxms(#   timescaledb.compress, netxms(#   timescaledb.compress_segmentby = 'timestamp' netxms(# ); ERROR:  unrecognized parameter namespace "timescaledb" ЧЯДНТ?