PostgreSQL

Revision as of 10:38, 17 June 2014 (view source)

Rade (Talk | contribs)

m (→Koriscenje proceduralinih jezika)

← Older edit

Latest revision as of 10:38, 26 July 2016 (view source)

Ognjen (Talk | contribs)

(→Upgrade major verzije)

Line 196:

Pre upgrade-a uraditi backup, i premestiti DB klaster direktorijum:

+

su - postgres

pg_dumpall > pg_all.sql

−

~~/etc/rc.d/init.d/postgresql stop~~

+

−

~~/etc/rc.d/init.d/~~postgresql-9.1 stop

+

exit

−

mv /var/lib/pgsql /var/lib/pgsql.old

+

service postgresql-9.3 stop

+

mv /var/lib/pgsql/9.3 /var/lib/pgsql/9.3-old

Opisano u

−

http://www.postgresql.org/docs/9.2/static/upgrading.html

+

http://www.postgresql.org/docs/9.5/static/upgrading.html

Za upgrade servera treba koristiti Postgresov yum repozitorijum:

Line 211:

Line 214:

Prateci linkove, nađite repository RPM, na primer:

−

~~http~~://~~yum~~.~~pgrpms~~.org/~~9.2/redhat/rhel-5-x86_64/pgdg-centos92-9.2-6.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.2/redhat/rhel-5-~~i386~~/pgdg-~~centos92~~-9.2-6.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.1/redhat/rhel-5-x86_64/pgdg-centos91-9.1-4.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.1/redhat/rhel-5-i386/pgdg-~~centos91~~-9.1-4.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.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:

−

wget ~~http~~://~~yum~~.~~pgrpms~~.org/9.2/redhat/rhel-5-x86_64/pgdg-~~centos92~~-9.2-6.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-~~centos~~-9.0-2.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.

−

~~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.

+

−

+

−

~~'''Samo za upgrade na 8.x''', instalirajte javni ključ za Postgres:~~

+

−

+

−

~~wget http://yum.pgsqlrpms.org/RPM-GPG-KEY-PGDG~~

+

−

~~rpm --import RPM-GPG-KEY-PGDG~~

+

−

+

Isključite traženje Postgresa iz standardnog repozitorijuma tako što ćete

u fajlu /etc/yum.repos.d/CentOS-Base.repo na kraj sekcija [base] i

Line 243:

Line 236:

exclude=postgresql*

−

~~'''Za 8.x''', update-ujte postgres sa:~~

−

~~yum update postgresql~~

−

'''Za 9.2''', instalirajte postgres:

+

'''Za 9.5''', instalirajte postgres:

−

yum install ~~postgresql92~~-server

+

yum install postgresql95-server

−

Terebalo bi da je kreiran novi, prazan direktorijum /var/lib/pgsql/9.2/data.

+

Terebalo bi da je kreiran novi, prazan direktorijum /var/lib/pgsql/9.3/data.

Proveriti. Kao korisnik root izvršiti inicijalizaciju DB klastera:

−

Za 9.2:

+

service postgresql-9.5 initdb

−

~~service postgresql-9.2 initdb~~

−

~~Za 8.x~~:

+

Startovati Postgres service kao korisnik root:

−

su - ~~postgres~~

+

service postgresql-9.5 start

−

~~initdb -D /var/lib/pgsql/data~~

+

−

~~Startovati Postgres service kao korisnik root:~~

−

~~exit~~

−

~~/etc/init.d/postgresql-9.2 start~~

−

~~/etc/init.d/postgresql start~~

Uraditi restore baze:

su - postgres

−

psql -d postgres -f ~~../pgsql.old/~~pg_all.sql

+

psql -d postgres -f pg_all.sql

Uraditi vacuum:

vacuumdb -az

+

exit

+

Ukljičiti novu verziju postgresa:

+

chkconfig postgresql-9.3 off

+

chkconfig postgresql-9.5 on --levels 2345

+

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==

* [http://trac.biostr.washington.edu/trac/wiki/PostgreSql lista psql komandi]

Latest revision as of 10:38, 26 July 2016

Personal tools

Namespaces

Variants

Views

Actions

Search

Navigation

Toolbox

@@ Line 196: / Line 196: @@
 Pre upgrade-a uraditi backup, i premestiti DB klaster direktorijum:
+  su - postgres
    pg_dumpall > pg_all.sql
-   /etc/rc.d/init.d/postgresql stop
-   /etc/rc.d/init.d/postgresql-9.1 stop
+   exit
-   mv /var/lib/pgsql /var/lib/pgsql.old
+  service postgresql-9.3 stop
+   mv /var/lib/pgsql/9.3 /var/lib/pgsql/9.3-old
 Opisano u
-   http://www.postgresql.org/docs/9.2/static/upgrading.html
+   http://www.postgresql.org/docs/9.5/static/upgrading.html
 Za upgrade servera treba koristiti Postgresov yum repozitorijum:
@@ Line 211: / Line 214: @@
 Prateci linkove, nađite repository RPM, na primer:
-   http://yum.pgrpms.org/9.2/redhat/rhel-5-x86_64/pgdg-centos92-9.2-6.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.2/redhat/rhel-5-i386/pgdg-centos92-9.2-6.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.1/redhat/rhel-5-x86_64/pgdg-centos91-9.1-4.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.1/redhat/rhel-5-i386/pgdg-centos91-9.1-4.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.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:
-   wget http://yum.pgrpms.org/9.2/redhat/rhel-5-x86_64/pgdg-centos92-9.2-6.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-centos-9.0-2.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.
-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.
-'''Samo za upgrade na 8.x''', instalirajte javni ključ za Postgres:
-  wget http://yum.pgsqlrpms.org/RPM-GPG-KEY-PGDG
-  rpm --import RPM-GPG-KEY-PGDG
 Isključite traženje Postgresa iz standardnog repozitorijuma tako što ćete
 u fajlu /etc/yum.repos.d/CentOS-Base.repo na kraj sekcija [base] i
@@ Line 243: / Line 236: @@
    exclude=postgresql*
-'''Za 8.x''', update-ujte postgres sa:
-  yum update postgresql
-'''Za 9.2''', instalirajte postgres:
+'''Za 9.5''', instalirajte postgres:
-   yum install postgresql92-server
+   yum install postgresql95-server
-Terebalo bi da je kreiran novi, prazan direktorijum /var/lib/pgsql/9.2/data.
+Terebalo bi da je kreiran novi, prazan direktorijum /var/lib/pgsql/9.3/data.
 Proveriti. Kao korisnik root izvršiti inicijalizaciju DB klastera:
-Za 9.2:
+  service postgresql-9.5 initdb
-  service postgresql-9.2 initdb
-Za 8.x:
+Startovati Postgres service kao korisnik root:
-   su - postgres
+   service postgresql-9.5 start
-  initdb -D /var/lib/pgsql/data
-Startovati Postgres service kao korisnik root:
-  exit
-  /etc/init.d/postgresql-9.2 start
-  /etc/init.d/postgresql start
 Uraditi restore baze:
    su - postgres
-   psql -d postgres -f ../pgsql.old/pg_all.sql
+   psql -d postgres -f pg_all.sql
 Uraditi vacuum:
    vacuumdb -az
+  exit
+Ukljičiti novu verziju postgresa:
+  chkconfig postgresql-9.3 off
+  chkconfig postgresql-9.5 on --levels 2345
 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==
 * [http://trac.biostr.washington.edu/trac/wiki/PostgreSql lista psql komandi]