Crowdly
Add to Chrome
INSY 5xHIT 25/26
Looking for INSY 5xHIT 25/26 test answers and solutions? Browse our comprehensive collection of verified answers for INSY 5xHIT 25/26 at elearning.tgm.ac.at.
Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!
Ist die folgende Aussage wahr oder falsch?
pg_dump is a utility for backing up a PostgreSQL database. It makes consistent backups even if the database is being used concurrently. pg_dump does not block other users accessing the database (readers or writers).
pg_dump only dumps a single database. To back up an entire cluster, or to back up global objects that are common to all databases in a cluster (such as roles and tablespaces), use pg_dumpall.
Folgendes Snippet ist aus dem restore.sql entnommen:
--
-- NOTE:
--
-- File paths need to be edited. Search for /data and
-- replace it with the path to the directory containing
-- the extracted data files.
--
--
-- PostgreSQL database dump
--
-- Dumped from database version 9.6.9
-- Dumped by pg_dump version 13.7 (Debian 13.7-0+deb11u1)
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
DROP DATABASE venlab;
--
-- Name: venlab; Type: DATABASE; Schema: -; Owner: postgres
--
CREATE DATABASE venlab WITH TEMPLATE = template0 ENCODING = 'UTF8' ;
ALTER DATABASE venlab OWNER TO postgres;
\connect venlab
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
Welche Aussagen stimmen?
Welche Punkte sind wichtig bei der Verwendung von der restore.sql
Welche Aussagen treffen auf die Data Manipulation Language (DML) und deren Befehle zu?
Welche Aussagen sind in Bezug auf ein Postgresql-Backup zutreffend?