PostgreSQL

Revision as of 22:41, 5 February 2015 (view source) Ognjen (Talk | contribs) (→Upgrade major verzije) ← Older edit		Revision as of 10:26, 26 July 2016 (view source) Ognjen (Talk | contribs) (→Upgrade major verzije) Newer edit →
Line 197:		Line 197:
	pg_dumpall > pg_all.sql		pg_dumpall > pg_all.sql
−	/etc/rc.d/init.d/postgresql stop	+	/etc/rc.d/init.d/postgresql-9.3 stop
−	/etc/rc.d/init.d/postgresql-9.1 stop	+	mv /var/lib/pgsql/9.3 /var/lib/pgsql/9.3-old
−	mv /var/lib/pgsql /var/lib/pgsql.old	+
	Opisano u		Opisano u
−	http://www.postgresql.org/docs/9.3/static/upgrading.html	+	http://www.postgresql.org/docs/9.5/static/upgrading.html
	Za upgrade servera treba koristiti Postgresov yum repozitorijum:		Za upgrade servera treba koristiti Postgresov yum repozitorijum:
Line 211:		Line 210:
	Prateci linkove, nađite repository RPM, na primer:		Prateci linkove, nađite repository RPM, na primer:
−	http://yum.pgrpms.org/9.3/redhat/rhel-6-x86_64/pgdg-centos93-9.3-1.noarch.rpm	+	https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-6-x86_64/pgdg-centos95-9.5-2.noarch.rpm
−	http://yum.pgrpms.org/9.3/redhat/rhel-6-i386/pgdg-centos93-9.3-1.noarch.rpm	+	https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-6-i386/pgdg-centos95-9.5-2.noarch.rpm
−		+
−	http://yum.pgrpms.org/9.3/redhat/rhel-5-x86_64/pgdg-centos93-9.3-1.noarch.rpm	+	https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-5-x86_64/pgdg-centos95-9.5-2.noarch.rpm
−	http://yum.pgrpms.org/9.3/redhat/rhel-5-i386/pgdg-centos93-9.3-1.noarch.rpm	+	https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-5-i386/pgdg-centos95-9.5-2.noarch.rpm
−		+
−	http://yum.pgrpms.org/9.2/redhat/rhel-5-x86_64/pgdg-centos92-9.2-6.noarch.rpm	+
−	http://yum.pgrpms.org/9.2/redhat/rhel-5-i386/pgdg-centos92-9.2-6.noarch.rpm	+
−		+
−	http://yum.pgrpms.org/9.1/redhat/rhel-5-x86_64/pgdg-centos91-9.1-4.noarch.rpm	+
−	http://yum.pgrpms.org/9.1/redhat/rhel-5-i386/pgdg-centos91-9.1-4.noarch.rpm	+
−		+
−	http://yum.pgrpms.org/9.0/redhat/rhel-5-x86_64/pgdg-centos90-9.0-5.noarch.rpm	+
−	http://yum.pgrpms.org/9.0/redhat/rhel-5-i386/pgdg-centos90-9.0-5.noarch.rpm	+
−		+
−	http://yum.pgrpms.org/8.4/redhat/rhel-6-x86_64/pgdg-centos-8.4-3.noarch.rpm	+
−	http://yum.pgrpms.org/8.4/redhat/rhel-6-i386/pgdg-centos-8.4-3.noarch.rpm	+
	Instalirajte RPM sa:		Instalirajte RPM sa:
−	wget http://yum.pgrpms.org/9.3/redhat/rhel-5-x86_64/pgdg-centos93-9.3-1.noarch.rpm	+	wget https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-5-x86_64/pgdg-centos95-9.5-2.noarch.rpm
−	rpm -i pgdg-centos93-9.3-1.noarch.rpm	+	yum install pgdg-centos95-9.5-2.noarch.rpm
		+	yum remove pgdg-centos93
		+	yum remove pgdg-centos91
	Proverite da li se u /etc/yum.repos.d/ nalazi pgdg-XX-centos.repo.		Proverite da li se u /etc/yum.repos.d/ nalazi pgdg-XX-centos.repo.
−	Obrisati viškove. Na primer, ako se radi migracija sa 9.1 na 9.2 moguće je da već postoji	+	Proveriti da nema viškova (9.1 i 9.3). Ako ima konflikta deinstalirati stari Postgres.
−	stari pgdg-91-centos.repo koga treba obrisati. Ako ima konflikta deinstalirati stari Postgres.	+
	Isključite traženje Postgresa iz standardnog repozitorijuma tako što ćete		Isključite traženje Postgresa iz standardnog repozitorijuma tako što ćete
Line 245:		Line 233:
−	'''Za 9.3''', instalirajte postgres:	+	'''Za 9.5''', instalirajte postgres:
−	yum install postgresql93-server	+	yum install postgresql95-server
	Terebalo bi da je kreiran novi, prazan direktorijum /var/lib/pgsql/9.3/data.		Terebalo bi da je kreiran novi, prazan direktorijum /var/lib/pgsql/9.3/data.
	Proveriti. Kao korisnik root izvršiti inicijalizaciju DB klastera:		Proveriti. Kao korisnik root izvršiti inicijalizaciju DB klastera:
−	service postgresql-9.3 initdb	+	service postgresql-9.5 initdb
	Startovati Postgres service kao korisnik root:		Startovati Postgres service kao korisnik root:
−	service postgresql-9.3 start	+	service postgresql-9.5 start
Line 264:		Line 252:
	su - postgres		su - postgres
	psql -d postgres -f pg_all.sql		psql -d postgres -f pg_all.sql
		+
		+	exit
	Uraditi vacuum:		Uraditi vacuum:
Line 271:		Line 261:
	Ukljičiti novu verziju postgresa:		Ukljičiti novu verziju postgresa:
−	chkconfig postgresql-9.1 off	+	chkconfig postgresql-9.3 off
−	chkconfig postgresql-9.3 on --levels 2345	+	chkconfig postgresql-9.5 on --levels 2345
	Podesiti postgresql.conf i pg_hba.conf. Podesiti iptables.		Podesiti postgresql.conf i pg_hba.conf. Podesiti iptables.
−	Pri prelasku sa 8.3 na 8.4 često se može koristiti isti postgres.conf, samo treba izaciti parametar	+	su - postgres
−	max_fsm_pages.	+	mv 9.5/data/pg_hba.conf 9.5/data/pg_hba.conf.orig
		+	cp 9.3/data/pg_hba.conf 9.5/data/pg_hba.conf
		+	cp 9.5/data/postgresql.conf 9.5/data/postgresql.conf.orig
	==Spoljašne veze==		==Spoljašne veze==
	* [http://trac.biostr.washington.edu/trac/wiki/PostgreSql lista psql komandi]		* [http://trac.biostr.washington.edu/trac/wiki/PostgreSql lista psql komandi]

---

Revision as of 10:26, 26 July 2016