Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
kb:pg:migracija_iz_93_u_96 [2019/01/24 15:31] – nessa | kb:pg:migracija_iz_93_u_96 [2019/04/16 11:56] (current) – milica | ||
---|---|---|---|
Line 2: | Line 2: | ||
Koristeći Pg_dump i psql moguće je preneti podatke iz baze servera verzije 9.3 u bazu servera 9.6.\\ | Koristeći Pg_dump i psql moguće je preneti podatke iz baze servera verzije 9.3 u bazu servera 9.6.\\ | ||
- | Obe baze moraju biti iste verzije npr. 10462.10536.20044, | + | \\ |
+ | **Obe baze moraju biti iste verzije npr. 10462.10536.20044, | ||
+ | Pre migracije podataka svi korisnici baze moraju izaći iz programa (Balans, kasa…) jer će se preneti neažurirana tabela UniBroj pa će njene vrednosti biti početne za unibroj sekvence na novom serveru što će dovesti do grešaka tipa " | ||
1. **Tekuća godina** - npr. PGS server 9.3 na računaru MOC, PGS server 9.6 na računaru 192.168.0.15, | 1. **Tekuća godina** - npr. PGS server 9.3 na računaru MOC, PGS server 9.6 na računaru 192.168.0.15, | ||
Line 37: | Line 39: | ||
</ | </ | ||
- | Na PostgreSQL serveru 9.6 u bazi b7 odraditi kopiranje scheme tekuće godine u praznu schemu a2016 komandom: | + | Na PostgreSQL serveru 9.6 u bazi b7 odraditi kopiranje scheme tekuće godine u praznu schemu a2016 komandom: |
+ | |||
+ | < | ||
+ | select _blnscloneschema(' | ||
+ | </ | ||
Dodati komande SET search_path, | Dodati komande SET search_path, | ||
Line 43: | Line 49: | ||
Uvoz podataka komandom: | Uvoz podataka komandom: | ||
- | < | + | < |
+ | psql --dbname=postgresql:// | ||
+ | </ | ||
+ | |||
+ | Komande za čišćenje tabela koje u nultoj bazi imaju podatke: | ||
+ | |||
+ | < | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | </ | ||