PowerGres R on Linux
Linux Linus Torvalds TM R
1 2 2 PowerGres on Linux 2 2.1 PowerGres on Linux.................................... 2 2.2.............................................. 2 2.3.............................................. 3 2.4.......................................... 3 3 3 4 3 4.1........................................ 3 4.2....................................... 6 4.3....................................... 9 5 10 5.1 RPM................................. 10 5.2 ODBC.................................. 11 6 11 7 12 7.1....................................... 12 7.2............................................ 13 7.3 PostgreSQL/PowerGres &........................ 13 8 13 1
1 PowerGres on Linux PowerGres on Linux PostgreSQL PowerGres Administrator Tool Web PowerGres on Linux PowerGres Administrator Tool PowerGres Administrator Tool 2 PowerGres on Linux 2.1 PowerGres on Linux PowerGres on Linux PostgreSQL PostgreSQL PostgreSQL PowerGres on Linux PostgreSQL 7 (12 ) 3 PostgreSQL PowerGres on Linux PostgreSQL PowerGres (PowerGres on Windows ) PowerGres on Linux GUI C JDBC 2.2 PowerGres on Linux CD-ROM PowerGres on Linux 2
PowerGres on Linux PowerGres Administrator Tool ( ) 2.3 PowerGres on Linux OS Red Hat Enterprise Linux AS/ES 3 Red Hat Enterprise Linux AS/ES 4 Red Hat Enterprise Linux 5/Advanced Platform CPU Intel x86 AMD64 Intel 64(EM64T) 128MB (256MB ) 100MB PowerGres Administrator Tool PowerGres Administrator Tool 2.4 PowerGres on Linux PowerGres Administrator Tool PowerGres Administrator Tool 3 PowerGres on Linux 1 E-mail URL http://powergres.sraoss.co.jp/ 4 4.1 PowerGres on Linux PowerGres Administrator Tool 3
PowerGres on Linux 4.2 (6 ) CD-ROM CD-ROM /mnt/cdrom root 1. # sh /mnt/cdrom/install.sh Welcome to PowerGres on Linux 2. Please input a license key (ex. ABCD-EFGH-IJKL-MNOP): The license key could not be authenticated. The license key has been authenticated. 3. PowerGres on Linux Please input the superuser name [postgres]: postgres OS OS root "postgres" already exists. The superuser is "postgres". OS 4
test "test" still does not exist. Creating "test"... Succeeded. The superuser is "test". 4. Please input the password: Please input the password once more: 2 OS PowerGres Administrator Tool 5. PowerGres Administrato Tool Please input the port for PowerGres Administrator Tool [8080]: 8080 1023 The port for PowerGres Administrator Tool is 8080. 6. ( ) Installing packages... Preparing... ########################################### [100%] 1:powergres-libs ########################################### [ 9%] 2:powergres ########################################### [ 18%] 3:powergres-server ########################################### [ 27%] 4:powergres-contrib ########################################### [ 36%] 5:powergres-devel ########################################### [ 45%] 6:powergres-docs ########################################### [ 55%] 7:powergres-pl ########################################### [ 64%] 8:powergres-test ########################################### [ 73%] 9:powergresadmin ########################################### [ 82%] 10:powergresadmin-apache ########################################### [ 91%] 11:powergresadmin-php ########################################### [100%] Packages have been installed. 7. OS ( ) PowerGres on Linux OS 5
Configuring shared memory... Succeeded. 8. ( ) Setting after installation... Succeeded. 9. PowerGres Administrator Tool ( ) URL URL ( ) PowerGres Administrator Tool SETTING initdb PowerGres Administrator Tool PowerGres Administrator Tool Starting PowerGres Administrator Tool... Succeeded. You can access PowerGres Administrator Tool with the following URL: http://hostname:8080/ OS PowerGres on Linux PowerGres Administrator Tool OS 4.2 PowerGres on Linux 4.x PowerGres on Linux CD-ROM CD-ROM /mnt/cdrom root 1. 6
PowerGres Administrator Tool BACKUP backup PowerGres Administrator Tool 7.1 PostgreSQL III. 23 PowerGres on Linux 1.0.x PowerGres Administrator Tool (postgresql.conf pg hba.conf pg ident.conf ) 2. PowerGres Administrator Tool DAEMON stop postmaster 3. PowerGres Administrator Tool # /etc/init.d/powergresadmin stop 4. # sh /mnt/cdrom/upgrade.sh Welcome to PowerGres on Linux 5. Do you upgrade PowerGres on Linux really (yes/no): yes no 6. ( ) Please input a license key (ex. ABCD-EFGH-IJKL-MNOP): The license key has been authenticated. 7
The license key could not be authenticated. 7. ( ) Updateing packages... preparing... ########################################### [100%] 1:powergres-libs ########################################### [ 8%] 2:powergres ########################################### [ 17%] 3:powergres-server ########################################### [ 25%] 4:powergres-contrib ########################################### [ 33%] 5:powergres-devel ########################################### [ 42%] 6:powergres-docs ########################################### [ 50%] 7:powergres-pl ########################################### [ 58%] 8:powergres-test ########################################### [ 67%] 9:powergres-jdbc ########################################### [ 75%] 10:powergresadmin ########################################### [ 83%] 11:powergresadmin-apache ########################################### [ 92%] 12:powergresadmin-php ########################################### [100%] Packages have been upgraded. 8. ( ) Setting after upgrade... Succeeded. 9. PowerGres Administrator Tool ( ) Starting PowerGres Administrator Tool... Succeeded. You can access PowerGres Administrator Tool with the following URL: http://hostname:8080/ 10. PowerGres Administrator Tool SETTING initdb 11. PowerGres Administrator Tool BACKUP restore PowerGres Administrator Tool 7.1 PostgreSQL III. 23 8
12. ( ) (postgresql.conf pg hba.conf pg ident.conf ) PowerGres Administrator Tool 11.1.3 PostgreSQL postgresql.conf 13. PowerGres Administrator Tool DAEMON start postmaster 4.3 PowerGres on Linux RPM powergres PostgreSQL HTML ( ) powergres-server powergres-devel libpq ecpg powergres-libs libpq ecpg powergres-pl (PL/Perl PL/Python PL/Tcl) powergres-test regression test ( ) powergres-docs (SGML ) powergres-contrib PostgreSQL contrib powergresadmin PowerGres Administrator Tool PostgreSQL powergresadmin-apache PowerGres Administrator Tool Apachel Web powergresadmin-php PowerGres Administrator Tool PHP 9
5 PowerGres on Linux PowerGres on Linux PowerGres Administrator Tool RPM powergres-python... PygreSQL powergres-jdbc... JDBC powergres-tcl... Tcl (Pgtcl) ODBC... PostgreSQL ODBC (Windows ) ODBC PostgreSQL/PowerGres & ODBC JDBC 5.1 RPM CD-ROM CD-ROM CD-ROM root RPM 1. OS RPM OS RPM OS Red Hat Enterprise Linux AS/ES 3 Red Hat Enterprise Linux AS/ES 4 Red Hat Enterprise Linux 5/Advanced Platform Intel x86 RPMS/rhel3-i386 AMD64 Intel 64 RPMS/rhel3-x86 64 Intel x86 RPMS/rhel4-i386 AMD64 Intel 64 RPMS/rhel4-x86 64 Intel x86 RPMS/rhel5-i386 AMD64 Intel 64 RPMS/rhel5-x86 64 OS Red Hat Enterprise Linux AS 5 CPU Intel x86 RPMS/rhel4-i386 # cd RPMS/rhel5-i386 2. RPM JDBC 10
# rpm -ivh powergres-jdbc-*.rpm Preparing... ########################################### [100%] 1:powergres-jdbc ########################################### [100%] RPM 5.2 ODBC ODBC Windows CD-ROM CD-ROM D: ODBC 1. CD-ROM (D:Y=ODBCY=psqlodbc-07 03 0200-1.zip) (psqlodbc.exe) 2. (psqlodbc.exe) 6 CD-ROM CD-ROM /mnt/cdrom root 1. PowerGres Administrator Tool DAEMON stop postmaster 2. PowerGres Administrator Tool # /etc/init.d/powergresadmin stop 3. # sh /mnt/cdrom/uninstall.sh Welcome to PowerGres on Linux 4. 11
Do you uninstall PowerGres on Linux really (yes/no): yes no 5. ( ) Uninstalling packages... The uninstallation of PowerGres on Linux completed successfully. PowerGres on Linux PostGIS : : libpq.so.4 postgis-1.0.4-1 powergres = 3.0.0 postgis-1.0.4-1 ( postgis) RPM # rpm -e postgis 6. RPM /opt/powergres 7 PowerGres on Linux PowerGres Web Web 7.1 1 E-mail 3 (3 ) 12
7.2 PowerGres on Linux 3 PowerGres ( ) API (C PHP JDBC) Web 9 12 13 19 7.3 PostgreSQL/PowerGres & 8 SRA OSS, Inc. 170-0005 3-46-3 5F powergres-sales@sraoss.co.jp 13