|
|
Testovaci server => tablexia-devel.labs.nic.cz
|
|
|
Produkcni server => tablexia-server.labs.nic.cz
|
|
|
|
|
|
|
|
|
### Zakladni ovladani serveru
|
|
|
`sudo service tablexia-server start|stop|restart`
|
|
|
|
|
|
### Migrace DB
|
|
|
```
|
|
|
cd /var/lib/tablexia-server
|
|
|
sudo java -jar -server tablexia-server.jar db migrate /etc/tablexia-server.yml
|
|
|
```
|
|
|
|
|
|
### Typicky postup reinstalace serveru
|
|
|
sudo service tablexia-server stop
|
|
|
```
|
|
|
sudo dpkg -i tablexia-server.deb
|
|
|
|
|
|
// Pokud je treba migrace databaze
|
|
|
cd /var/lib/tablexia-server
|
|
|
sudo java -jar -server tablexia-server.jar db migrate /etc/tablexia-server.yml
|
|
|
|
|
|
sudo systemctl daemon-reload
|
|
|
sudo service tablexia-server start
|
|
|
```
|
|
|
|
|
|
|
|
|
sudo su postgres
|
|
|
pg_dump tablexia > /home/***/backup/nazev_souboru
|
|
|
|
|
|
psql tablexia s
|
|
|
\dt - Vypsat tabulky
|
|
|
\d nazev_tabulky - Vypise fieldy v tabulce
|
|
|
\q - quit |
|
|
\ No newline at end of file |