Gigabyte MH60-RE1 (rev. 1.1) [11/49] 5 3 restore dbgsmv0xx backup

- 11 - Gigabyte Server Management

4. DownloadPGDGRPMle

[CentOS] curl -O

 http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/pgdg-centos93-9.3-1.noarch.rpm

[Red Hat] curl -O

 http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/pgdg-redhat93-9.3-1.noarch.rpm

5. InstallPGDGRPMle

[CentOS] rpm -ivh pgdg-centos93-9.3-1.noarch.rpm

[Red Hat] rpm -ivh pgdg-redhat93-9.3-1.noarch.rpm

6. Install PostgreSQL

yum install postgresql93-server

7. Initialize

service postgresql-9.3 initdb

8. Startup

 chkcongpostgresql-9.3on

1-5-3 Restore dbGSMv0XX.backup

1. Modifypg_hba.confle

[Ubuntu]

vi /etc/postgresql/9.3/main/pg_hba.conf

[CentOS / Red Hat]

vi /var/lib/pgsql/9.3/data/pg_hba.conf

2. Edit

TYPE DATABASE USER ADDRESS METHOD

Local all all→postgres peer→trust

host all all→postgres 127.0.0.1/32 indent→trust

host all all→postgres ::1/128 indent→trust

:wqtosaveeditedle.

3. Start service

[Ubuntu]

service postgresql restart