5 September 2017: 2ndQuadrant is proud to announce the release of Barman version 2.3, a Backup and Recovery Manager for PostgreSQL.
This minor release introduces support for PostgreSQL 10.
PROGRAM
The program line gives the name of a program to be run when
mdadm --monitor detects potentially interesting events on any of
the arrays that it is monitoring. This program gets run with
two or three arguments, they being the Event, the md device, and
possibly the related component device.
There should only be one program line and it should be give only
one program.
A procedure is a database object similar to a function. The difference is that a procedure does not return a value, so there is no return type declaration.
и инкрементный каждый час.
UPDATE tablename
SET
name = ?,
domain = ?,
in_chats = usersdata_mirror.in_chats || ARRAY[?]::int[]
WHERE
not(usersdata_mirror.in_chats @> ARRAY[?]::int[]) and user_id = ?
in_chats = case when ... then ... else usersdata_mirror.in_chats end
Завести комп с этим процессором и четырьмя планками удалось только на 2666 МГц.
4 x DIMM, max. 64GB, DDR4 3533(O.C.)/3466(O.C.)/3200(O.C.)/3000(O.C.)/2800(
O.C)/2666/ 2400/2133 MHz, un-buffered memory