diff options
Diffstat (limited to 'postgresql')
| -rw-r--r-- | postgresql/Makefile | 90 | ||||
| -rwxr-xr-x | postgresql/bin/pg_hba.conf | 169 | ||||
| -rwxr-xr-x | postgresql/bin/postgresql-backup | 47 | ||||
| -rw-r--r-- | postgresql/share/bash-completion/pg_hba.conf | 48 | ||||
| -rw-r--r-- | postgresql/share/man/Makefile | 59 | ||||
| -rw-r--r-- | postgresql/share/man/container.1.rst | 145 | ||||
| -rw-r--r-- | postgresql/share/man/man.in | 19 |
7 files changed, 0 insertions, 577 deletions
diff --git a/postgresql/Makefile b/postgresql/Makefile deleted file mode 100644 index 9bc75b3..0000000 --- a/postgresql/Makefile +++ /dev/null @@ -1,90 +0,0 @@ -# Open Infrastructure: service-tools - -# Copyright (C) 2014-2022 Daniel Baumann <daniel.baumann@open-infrastructure.net> -# -# SPDX-License-Identifier: GPL-3.0+ -# -# This program is free software: you can redistribute it and/or modify -# it under the terms of the GNU General Public License as published by -# the Free Software Foundation, either version 3 of the License, or -# (at your option) any later version. -# -# This program is distributed in the hope that it will be useful, -# but WITHOUT ANY WARRANTY; without even the implied warranty of -# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the -# GNU General Public License for more details. -# -# You should have received a copy of the GNU General Public License -# along with this program. If not, see <https://www.gnu.org/licenses/>. - -SHELL := sh -e - -SCRIPTS = bin/* - -all: build - -test: - @echo -n "Checking for syntax errors with sh... " - @for SCRIPT in $(SCRIPTS); \ - do \ - sh -n $${SCRIPT}; \ - echo -n "."; \ - done - @echo " done." - - @echo -n "Checking for bashisms... " - @if [ -x /usr/bin/checkbashisms ]; \ - then \ - for SCRIPT in $(SCRIPTS); \ - do \ - checkbashisms -f -x $${SCRIPT}; \ - echo -n "."; \ - done; \ - else \ - echo "Note: devscripts not installed, skipping checkbashisms."; \ - fi - @echo " done." - - @echo -n "Checking with shellcheck... " - @if [ -x /usr/bin/shellcheck ]; \ - then \ - for SCRIPT in $(SCRIPTS); \ - do \ - shellcheck -e SC2039 $${SCRIPT}; \ - echo -n "."; \ - done; \ - else \ - echo "Note: shellcheck not installed, skipping shellcheck."; \ - fi - @echo " done." - -build: - -install: build - mkdir -p $(DESTDIR)/usr/bin - cp -r bin/* $(DESTDIR)/usr/bin - ln -sf pg_hba.conf $(DESTDIR)/usr/bin/update-pg_hba.conf - - mkdir -p $(DESTDIR)/usr/share/bash-completion/completions - cp -r share/bash-completion/* $(DESTDIR)/usr/share/bash-completion/completions - -uninstall: - for FILE in share/bash-completion/*; \ - do \ - rm -f $(DESTDIR)/usr/share/bash-completion/completions/$$(basename $${FILE}); \ - done - - rm -f $(DESTDIR)/usr/bin/update-pg_hba.conf - for FILE in bin/*; \ - do \ - rm -f $(DESTDIR)/usr/bin/$$(basename $${FILE}); \ - done - rmdir --ignore-fail-on-non-empty --parents $(DESTDIR)/usr/bin || true - - rmdir --ignore-fail-on-non-empty --parents $(DESTDIR) || true - -clean: - -distclean: - -reinstall: uninstall install diff --git a/postgresql/bin/pg_hba.conf b/postgresql/bin/pg_hba.conf deleted file mode 100755 index 2b6c7cb..0000000 --- a/postgresql/bin/pg_hba.conf +++ /dev/null @@ -1,169 +0,0 @@ -#!/bin/sh - -# Open Infrastructure: service-tools - -# Copyright (C) 2014-2022 Daniel Baumann <daniel.baumann@open-infrastructure.net> -# -# SPDX-License-Identifier: GPL-3.0+ -# -# This program is free software: you can redistribute it and/or modify -# it under the terms of the GNU General Public License as published by -# the Free Software Foundation, either version 3 of the License, or -# (at your option) any later version. -# -# This program is distributed in the hope that it will be useful, -# but WITHOUT ANY WARRANTY; without even the implied warranty of -# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the -# GNU General Public License for more details. -# -# You should have received a copy of the GNU General Public License -# along with this program. If not, see <https://www.gnu.org/licenses/>. - -set -e - -PROGRAM="$(basename "${0}")" - -Parameters () -{ - GETOPT_LONGOPTIONS="add,init,remove,update" - GETOPT_OPTIONS="a,i,r,u," - - PARAMETERS="$(getopt --longoptions ${GETOPT_LONGOPTIONS} --name=${COMMAND} --options ${GETOPT_OPTIONS} --shell sh -- ${@})" - - if [ "${?}" != "0" ] - then - echo "'${COMMAND}': getopt exit" >&2 - exit 1 - fi - - eval set -- "${PARAMETERS}" - - while true - do - case "${1}" in - -a|--add) - ACTION="add" - shift 1 - ;; - - -i|--init) - ACTION="init" - shift 1 - ;; - - -r|--remove) - ACTION="remove" - shift 1 - ;; - - -u|--update) - ACTION="update" - shift 1 - ;; - - --) - shift 1 - break - ;; - - *) - echo "'${COMMAND}': getopt error" >&2 - exit 1 - ;; - esac - done -} - -Usage () -{ - echo "Usage: ${PROGRAM} [-i|--init] [-a|--add LINE] [-r|--remove LINE] [-u|--update]" >&2 - echo - echo "See ${PROGRAM}(1) for more information." - - exit 1 -} - -Parameters "${@}" - -Run_add() -{ - echo "'add' not implemented yet" - exit 0 -} - -Run_init() -{ - echo "'init' not implemented yet" - exit 0 -} - -Run_remove() -{ - echo "'remove' not implemented yet" - exit 0 -} - -Run_update() -{ - # Check for pg_hba.conf - if ! ls /etc/postgresql/*/*/pg_hba.conf > /dev/null 2>&1 - then - echo "W: no pg_hba.conf in /etc/postgresql found." >&2 - exit 1 - fi - - # Check for managed pg_hba.conf - if ! ls /etc/postgresql/*/*/pg_hba.conf.g > /dev/null 2>&1 - then - echo "W: no managed pg_hba.conf in /etc/postgresql found, maybe use '${PROGRAM} --init' first." >&2 - exit 1 - fi - - # Update pg_hba.conf from pg_hba.conf.g directories - for DIRECTORY in /etc/postgresql/*/*/pg_hba.conf.g - do - if ls "${DIRECTORY}"/*.conf > /dev/null 2>&1 - then - CONFIG="$(basename "${DIRECTORY}" .g)" - - echo -n "Updating ${CONFIG}..." - - rm -f "${CONFIG}" - - for FILE in "${DIRECTORY}"/*.conf - do - cat "${FILE}" >> "${CONFIG}" - done - - echo " done." - fi - done -} - -case "${PROGRAM}" in - update-pg_hba.conf) - ACTION="update" - ;; -esac - -case "${ACTION}" in - add) - Run_add - ;; - - init) - Run_init - ;; - - remove) - Run_remove - ;; - - update) - Run_update - ;; - - *) - Usage - ;; -esac diff --git a/postgresql/bin/postgresql-backup b/postgresql/bin/postgresql-backup deleted file mode 100755 index beaf2d8..0000000 --- a/postgresql/bin/postgresql-backup +++ /dev/null @@ -1,47 +0,0 @@ -#!/bin/sh - -# Open Infrastructure: service-tools - -# Copyright (C) 2014-2022 Daniel Baumann <daniel.baumann@open-infrastructure.net> -# -# SPDX-License-Identifier: GPL-3.0+ -# -# This program is free software: you can redistribute it and/or modify -# it under the terms of the GNU General Public License as published by -# the Free Software Foundation, either version 3 of the License, or -# (at your option) any later version. -# -# This program is distributed in the hope that it will be useful, -# but WITHOUT ANY WARRANTY; without even the implied warranty of -# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the -# GNU General Public License for more details. -# -# You should have received a copy of the GNU General Public License -# along with this program. If not, see <https://www.gnu.org/licenses/>. - -set -e - - -#!/bin/sh - -set -e - -DIRECTORY="/srv/$(cat /etc/hostname)/postgresql-backup/$(date +%Y-%m-%d)" -DATABASES="fbm_test" - -mkdir -p "${DIRECTORY}" -chown -R postgres:postgres "${DIRECTORY}" - -for DATABASE in ${DATABASES} -do - su - postgres -c "pg_dump -f ${DIRECTORY} -F d -j $(nproc) -C -d ${DATABASE}" -done - -chown -R root:root "${DIRECTORY}" - - - - -# FIXME -#postgres pg_dump ${DATABASE} | plzip > postgresql-backup/${DATABASE}-"$(date +\%Y\%m\%d)".sql.lz -#find postgresql-backup/ -mtime +90 -name "${DATABASE}-*lz" | xargs -r rm diff --git a/postgresql/share/bash-completion/pg_hba.conf b/postgresql/share/bash-completion/pg_hba.conf deleted file mode 100644 index c69b07b..0000000 --- a/postgresql/share/bash-completion/pg_hba.conf +++ /dev/null @@ -1,48 +0,0 @@ -# Open Infrastructure: service-tools - -# Copyright (C) 2014-2022 Daniel Baumann <daniel.baumann@open-infrastructure.net> -# -# SPDX-License-Identifier: GPL-3.0+ -# -# This program is free software: you can redistribute it and/or modify -# it under the terms of the GNU General Public License as published by -# the Free Software Foundation, either version 3 of the License, or -# (at your option) any later version. -# -# This program is distributed in the hope that it will be useful, -# but WITHOUT ANY WARRANTY; without even the implied warranty of -# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the -# GNU General Public License for more details. -# -# You should have received a copy of the GNU General Public License -# along with this program. If not, see <https://www.gnu.org/licenses/>. - -_pg_hba_conf() -{ - local cur prev pg_type - COMPREPLY=() - cur="${COMP_WORDS[COMP_CWORD]}" - prev="${COMP_WORDS[COMP_CWORD-1]}" - - if [ ${COMP_CWORD} -gt 0 ] - then - pg_type="${COMP_WORDS[1]}" - fi - - if [ "${prev}" = "--" ] - then - compopt -o bashdefault - COMPREPLY=( $(compgen -c -- $cur) ) - return 0 - fi - - case "${pg_type}" in - *) - local pg_types="local host hostssl hostnossl hostgssenc hostnogssenc" - COMPREPLY=( $(compgen -W "${pg_types}" -- ${cur}) ) - return 0 - ;; - esac -} - -complete -F _pg_hba_conf pg_hba.conf diff --git a/postgresql/share/man/Makefile b/postgresql/share/man/Makefile deleted file mode 100644 index a8af58d..0000000 --- a/postgresql/share/man/Makefile +++ /dev/null @@ -1,59 +0,0 @@ -# Open Infrastructure: compute-tools - -# Copyright (C) 2014-2021 Daniel Baumann <daniel.baumann@open-infrastructure.net> -# -# SPDX-License-Identifier: GPL-3.0+ -# -# This program is free software: you can redistribute it and/or modify -# it under the terms of the GNU General Public License as published by -# the Free Software Foundation, either version 3 of the License, or -# (at your option) any later version. -# -# This program is distributed in the hope that it will be useful, -# but WITHOUT ANY WARRANTY; without even the implied warranty of -# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the -# GNU General Public License for more details. -# -# You should have received a copy of the GNU General Public License -# along with this program. If not, see <https://www.gnu.org/licenses/>. - -# Depends: python3-docutils - -RST2MAN = rst2man \ - --no-datestamp \ - --no-generator \ - --strict \ - --strip-comments \ - --tab-width=4 \ - --verbose - -VERSION := $(shell cat ../../VERSION.txt) - -SHELL := sh -e - -all: build - -build: man - -rebuild: clean build - -man: man.in *.rst - @echo -n "Creating manpages... " - - @for FILE in *.rst; \ - do \ - cp man.in $$(basename $${FILE} .rst); \ - $(RST2MAN) $${FILE} | \ - sed -e '/^.\\" Man page generated/d' \ - -e '/^.\\" Generated by/d' \ - -e "s|^\(.TH .*\) \(\"\" \"\"\) |\1 $${VERSION} compute-tools |" \ - >> $$(basename $${FILE} .rst); \ - echo -n "."; \ - done - - @echo " done." - -clean: - rm -f *.[0-9] - -.PHONY: all clean build rebuild man diff --git a/postgresql/share/man/container.1.rst b/postgresql/share/man/container.1.rst deleted file mode 100644 index 6cd516f..0000000 --- a/postgresql/share/man/container.1.rst +++ /dev/null @@ -1,145 +0,0 @@ -.. Open Infrastructure: compute-tools - -.. Copyright (C) 2014-2021 Daniel Baumann <daniel.baumann@open-infrastructure.net> -.. -.. SPDX-License-Identifier: GPL-3.0+ -.. -.. This program is free software: you can redistribute it and/or modify -.. it under the terms of the GNU General Public License as published by -.. the Free Software Foundation, either version 3 of the License, or -.. (at your option) any later version. -.. -.. This program is distributed in the hope that it will be useful, -.. but WITHOUT ANY WARRANTY; without even the implied warranty of -.. MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the -.. GNU General Public License for more details. -.. -.. You should have received a copy of the GNU General Public License -.. along with this program. If not, see <https://www.gnu.org/licenses/>. - -============== -container-list -============== - ----------------------------- -List container on the system ----------------------------- - -:manual section: 1 -:manual group: Open Infrastructure - -Synopsis -======== - -| **container list** ['OPTIONS'] -| **cnt ls** ['OPTIONS'] - -Description -=========== - -The **container list** command lists container on the system. - -Options -======= - -The following **container list** options are available, defaults to '--started ---stopped': - --a, --all: - List all available container (started, stopped, and other). - ---csv-separator='SEPARATOR': - Specify custom CSV separator, defaults to ','. - --f, --format='FORMAT': - Use format to list container. Currently available formats are 'cli' (default), - 'csv', 'json', 'nwdiag', 'shell', 'sh', 'yaml', or 'xml'. - --h, --host='HOSTNAME': - List only container that are enabled for automatic start on the specified - hostname. Defaults to list containers of the local system only. Using 'all' - shows all container regardless of any automatic start configuration. - ---nwdiag-color='COLOR': - Specify custom nwdiag color for the host box, defaults to '#3465a4'. - ---nwdiag-label='LABEL': - Specify custom nwdiag label for the diagram, defaults to empty. - --o, --other: - List only container that are not enable for automatic start on the current - system. - --s, --started: - List only started container. - --t, --stopped: - List only stopped container. - -Examples -======== - -List all started and stopped containers of the local system: - - sudo container list - -List all started and other containers: - - sudo container list -s -o - -Create a CSV export of all started and stopped containers: - - sudo container list -f csv - -Create a JSON export of all started and stopped containers: - - sudo container list -f json - -Create a nwdiag export of all started and stopped containers: - - sudo container list -f nwdiag - -Create a SVG image via nwdiag of all started and stopped containers: - - sudo container list -f nwdiag | nwdiag -T svg -o cnt-list.svg - - -Create a shell export of all started and stopped containers: - - sudo container list -f shell - sudo container list -f sh - -Create a YAML export of all started and stopped containers: - - sudo container list -f yaml - -Create a XML export of all started and stopped containers: - - sudo container list -f xml - -See also -======== - -| compute-tools(7), -| container(1). - -Homepage -======== - -More information about compute-tools and the Open Infrastructure project can be -found on the homepage (https://open-infrastructure.net). - -Contact -======= - -Bug reports, feature requests, help, patches, support and everything else are -welcome on the Open Infrastructure Software Mailing List -<software@lists.open-infrastructure.net>. - -Debian specific bugs can also be reported in the Debian Bug Tracking System -(https://bugs.debian.org). - -Authors -======= - -compute-tools were written by Daniel Baumann -<daniel.baumann@open-infrastructure.net> and others. diff --git a/postgresql/share/man/man.in b/postgresql/share/man/man.in deleted file mode 100644 index f95ca67..0000000 --- a/postgresql/share/man/man.in +++ /dev/null @@ -1,19 +0,0 @@ -.\" Open Infrastructure: service-tools -.\" -.\" Copyright (C) 2014-2022 Daniel Baumann <daniel.baumann@open-infrastructure.net> -.\" -.\" SPDX-License-Identifier: GPL-3.0+ -.\" -.\" This program is free software: you can redistribute it and/or modify -.\" it under the terms of the GNU General Public License as published by -.\" the Free Software Foundation, either version 3 of the License, or -.\" (at your option) any later version. -.\" -.\" This program is distributed in the hope that it will be useful, -.\" but WITHOUT ANY WARRANTY; without even the implied warranty of -.\" MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the -.\" GNU General Public License for more details. -.\" -.\" You should have received a copy of the GNU General Public License -.\" along with this program. If not, see <https://www.gnu.org/licenses/>. -.\" |