PostgreSQL (Instalace, konfigurace)

https://wiki.debian.org/PostgreSql

Prikazy

Vstup do konzole (na Debianu?)

su - postgres

psql

Vytvoreni spravcovskeho uctu

CREATE USER jmeno WITH SUPERUSER ENCRYPTED PASSWORD 'heslo';

Zalohovani

Spousteno cronem pod uzivatelem postgres

pg_dumpall -f jmeno_souboru.sql - provede dump celeho clusteru, tj. vsech databazi vcetne roli a schemat

pg_dump davical -f jmeno_souboru.sql - provede dump pouze obsahu zvolene databaze

Upgrade

Popisujeme upgrade z verze 9.1 na 9.4

su postgres
pg_dropcluster --stop 9.4 main #zatavime defaultne nainstalovany cluster
pg_upgradecluster -v 9.4 9.1 main #pg_upgradecluster -v NEW OLD main
...
Fixing hardcoded library paths for stored procedures...
Upgrading database czfmapa...
Analyzing database czfmapa...
Fixing hardcoded library paths for stored procedures...
Upgrading database template1...
Analyzing database template1...
Fixing hardcoded library paths for stored procedures...
Upgrading database hosts...
Analyzing database hosts...
Fixing hardcoded library paths for stored procedures...
Upgrading database nagios...
Analyzing database nagios...
Fixing hardcoded library paths for stored procedures...
Upgrading database postgres...
Analyzing database postgres...
Fixing hardcoded library paths for stored procedures...
Upgrading database davical...
Analyzing database davical...
Re-enabling connections to the old cluster...
Re-enabling connections to the new cluster...
Copying old configuration files...
Copying old start.conf...
Copying old pg_ctl.conf...
Copying old server.crt...
Copying old server.key...
Stopping target cluster...
Stopping old cluster...
Disabling automatic startup of old cluster...
Configuring old cluster to use a different port (5433)...
Starting target cluster on the original port...
Success. Please check that the upgraded cluster works. If it does,
you can remove the old cluster with
postgres@dev:~$ psql
psql (9.4.24)
Type "help" for help.