aswi2021virtual-surreality-gitlab/db_browser/db/psql_win7_install.txt @ c137512e
| 1 | c137512e | Oto Šťáva | 1. instalace postgres |
|---|---|---|---|
| 2 | 2. instalace firefox |
||
| 3 | 3. cmd -> do Program Files\Postgres\10\bin |
||
| 4 | createuser -U postgres -P -d embitron |
||
| 5 | |||
| 6 | 4. createdb -U embitron Cviceni |
||
| 7 | 5. psql -U postgres Cviceni < cviceni_data.sql |
||
| 8 | 6. pak v pgadmin "grant all for embitron" - na vse v db Cviceni dat grant all |
||
| 9 | |||
| 10 | upgrade db |
||
| 11 | ---------- |
||
| 12 | 1. v pgadminu Delete/Drop DB |
||
| 13 | 2. createdb -U embitron Cviceni |
||
| 14 | 3. psql -U embitron Cviceni < cviceni.sql |