Tomas Lipensky - vedomostni koutek

Trace:

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
db:postgresql [2026/04/02 11:36]
tomas 		db:postgresql [2026/04/02 11:37] (current)
tomas [Příkazová řádla]
Line 12: Line 12:
  
 ===zaloha / obnoveni zalohy databaze=== ===zaloha / obnoveni zalohy databaze===
-pg_dump dbname > outfile\\ +pg_dump dbname > outfile\\ 
-pg_dump -h db_server -U db_user -W db_name > db.20070725.dump\\+pg_dump -h db_server -U db_user -W db_name > db.20070725.dump\\
  
-psql dbname > infile\\ +psql dbname > infile\\ 
-pg_dumpall > vse.sql ... zazalohuje vse do txt souboru vse.sql\\+pg_dumpall > vse.sql ... zazalohuje vse do txt souboru vse.sql\\
 psql -f vse.sql postgres ... obnovi vse z txt soubotu vse.txt\\ psql -f vse.sql postgres ... obnovi vse z txt soubotu vse.txt\\
  
Last modified: 2026/04/02 11:37
GNU Free Documentation License 1.3 Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3