Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
db:postgresql [2026/04/02 11:34] tomas [Start/stop/status] |
db:postgresql [2026/04/02 11:37] (current) tomas [Příkazová řádla] |
||
|---|---|---|---|
| Line 2: | Line 2: | ||
| ======PgSQL (Postgre SQL)====== | ======PgSQL (Postgre SQL)====== | ||
| - | ===Externi odkazy=== | + | ==== Odkazy ==== |
| Line 10: | Line 10: | ||
| ==== Příkazová řádla ==== | ==== Příkazová řádla ==== | ||
| - | === Start/ | ||
| - | === client | + | ===zaloha / obnoveni zalohy databaze=== |
| - | %%psql -U uživatel postgre:// | + | pg_dump dbname > outfile\\ |
| + | pg_dump -h db_server -U db_user -W db_name > db.20070725.dump\\ | ||
| + | |||
| + | psql dbname > infile\\ | ||
| + | pg_dumpall > vse.sql ... zazalohuje vse do txt souboru vse.sql\\ | ||
| + | psql -f vse.sql postgres ... obnovi vse z txt soubotu vse.txt\\ | ||
| + | |||
| + | === klient | ||
| + | %%psql -U uživatel postgre:// | ||
| ==== Postgre SQL příkazy a SQL jazyk ==== | ==== Postgre SQL příkazy a SQL jazyk ==== | ||
| Line 55: | Line 62: | ||
| ===Vnitrni funkce psql=== | ===Vnitrni funkce psql=== | ||
| - | |||
| - | |||
| timeofday(); | timeofday(); | ||
| - | |||
| - | |||
| - | ===zaloha / obnoveni zalohy databaze=== | ||
| - | pg_dump dbname > outfile\\ | ||
| - | pg_dump -h db_server -U db_user -W db_name > db.20070725.dump\\ | ||
| - | |||
| - | psql dbname > infile\\ | ||
| - | pg_dumpall > vse.sql ... zazalohuje vse do txt souboru vse.sql\\ | ||
| - | psql -f vse.sql postgres ... obnovi vse z txt soubotu vse.txt\\ | ||
| ====SQL==== | ====SQL==== | ||
Last modified: 2026/04/02 11:34
Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3