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 14:59] – nessa | kb:pg:migracija_iz_93_u_96 [2019/04/16 11:56] (current) – milica | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== Migracija podataka iz PostgreSQL 9.3 u 9.6 bazu ====== | ====== Migracija podataka iz PostgreSQL 9.3 u 9.6 bazu ====== | ||
- | 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. | + | 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, a baza na serveru 9.6 mora biti raščlanjena.\\ | ||
+ | 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, baza b7 | + | 1. **Tekuća godina** - npr. PGS server 9.3 na računaru MOC, PGS server 9.6 na računaru 192.168.0.15, baza b7 |
- | **Izvoz **podataka komandom\\ | + | **Izvoz **podataka komandom |
- | <font 12px/ | + | <code> |
- | < | + | pg_dump |
</ | </ | ||
- | Otvoriti fajl nekim editorom teksta npr. Notepad++ | + | Otvoriti fajl nekim editorom teksta npr. Notepad++.\\ |
+ | Promeniti | ||
\\ | \\ | ||
Pre prve INSERT komande dodati: | Pre prve INSERT komande dodati: | ||
Line 21: | Line 25: | ||
* SET session_replication_role = DEFAULT; – uključuje strane ključeve | * SET session_replication_role = DEFAULT; – uključuje strane ključeve | ||
- | Uvoz podaaka | + | Uvoz podataka |
+ | |||
+ | < | ||
+ | psql --dbname=postgresql:// | ||
+ | </ | ||
+ | |||
+ | 2. **Prethodna godina** | ||
+ | |||
+ | **Izvoz **podataka komandom | ||
+ | |||
+ | < | ||
+ | pg_dump --no-owner --no-privileges --data-only --column-inserts --dbname=postgresql:// | ||
+ | </ | ||
+ | |||
+ | 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, | ||
+ | |||
+ | Uvoz podataka komandom: | ||
+ | |||
+ | < | ||
+ | psql --dbname=postgresql:// | ||
+ | </ | ||
+ | |||
+ | Komande za čišćenje tabela koje u nultoj bazi imaju podatke: | ||
< | < | ||
- | psql --dbname=postgresql:// | + | DELETE FROM " |
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM " | ||
+ | DELETE FROM "schemaname" | ||
+ | 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 " | ||
</ | </ | ||