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 9 5.1 RPM................................. 10 5.2 ODBC.................................. 13 6 13 7 14 7.1....................................... 15 7.2............................................ 15 7.3 PostgreSQL/PowerGres &........................ 15 8 15 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 (14 ) 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 2.1/3/4 CPU Intel 32-bit x86 CPU (300MHz ) 128MB (256MB ) 100MB PowerGres Administrator Tool PowerGres Administrator Tool 2.4 PowerGres on Linux PowerGres Administrator Tool PowerGres Administrator Tool 3 PowerGres on Linux 30 E-mail URL http://powergres.sraoss.co.jp/ 4 4.1 PowerGres on Linux PowerGres Administrator Tool PowerGres on Linux 3.0 4.2 (6 3
) CD-ROM CD-ROM /mnt/cdrom root 1. # sh /mnt/cdrom/install.sh Welcome to PowerGres on Linux 2. Please input the license key (ex. ABCD-EFGH-IJKL-MNOP): The license key cannot be authenticated. The license key is authenticated. 3. PowerGres on Linux Please input the superuser name [postgres]: postgres OS OS root "postgres" already exists. The superuser is "postgres". OS test 4
"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. ( ) Preparing installation... Succeeded. Installing powergres-libs... Succeeded. Installing powergres... Succeeded. Installing powergres-devel... Succeeded. Installing powergres-contrib... Succeeded. Installing powergres-server... Succeeded. Installing powergres-test... Succeeded. Installing powergres-docs... Succeeded. Installing powergres-jdbc... Succeeded. Installing powergresadmin... Succeeded. Installing powergresadmin-apache... Succeeded. Installing powergresadmin-php... Succeeded. 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 3.0 3.0 PowerGres on Linux 3.0 3.0 CD-ROM CD-ROM /mnt/cdrom root 1. PowerGres Administrator Tool BACKUP backup PowerGres Administrator Tool 7.1 PostgreSQL III. 22 6
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 the license key (ex. ABCD-EFGH-IJKL-MNOP): The license key is authenticated. The license key cannot be authenticated. 7
7. ( ) Preparing upgrade... Succeeded. Upgrading powergresadmin... Succeeded. Upgrading powergresadmin-apache... Succeeded. Upgrading powergres-docs... Succeeded. Upgrading powergres-jdbc... Succeeded. Upgrading powergresadmin-php... Succeeded. Upgrading powergres-test... Succeeded. Upgrading powergres-contrib... Succeeded. Upgrading powergres-server... Succeeded. Upgrading powergres... Succeeded. Upgrading powergres-devel... Succeeded. Upgrading powergres-libs... Succeeded. 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. 22 12. ( ) (postgresql.conf pg hba.conf pg ident.conf ) PowerGres Administrator Tool 11.1.3 PostgreSQL postgresql.conf 13. 8
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-jdbc JDBC /opt/powergres/share/postgresql-8.0-319.jdbc2.jar /opt/powergres/share/postgresql-8.0-319.jdbc2ee.jar /opt/powergres/share/postgresql-8.0-319.jdbc3.jar JDK 1.4 powergres-test regression test ( ) powergres-docs (SGML ) powergres-contrib PostgreSQL contrib powergresadmin JDK 1.2 JDK1.3 JDK 1.3 (javax.sql.* ) PowerGres Administrator Tool PostgreSQL powergresadmin-apache PowerGres Administrator Tool Apachel Web powergresadmin-php PowerGres Administrator Tool PHP 5 PowerGres on Linux PowerGres on Linux PowerGres Administrator Tool Apache... Web PHP... pgpool... PostgreSQL 9
PostGIS... PostgreSQL ODBC... PostgreSQL ODBC (Windows ) pgpool PostgreSQL/PowerGres & PostGIS ODBC PostgreSQL/PowerGres & Apache PHP pgpool PostGIS OS RPM rpm rpm 5.1 5.1.1 ODBC 5.2 5.1 RPM Apache PHP RPM CD-ROM CD-ROM /mnt/cdrom root Apache PHP RPM RPM 1. OS RPM OS RPM Red Hat Enterprise Linux AS/ES 2.1 Red Hat Enterprise Linux AS/ES 3 Red Hat Enterprise Linux AS/ES 4 /mnt/cdrom/rpms/rhel2.1 /mnt/cdrom/rpms/rhel3.0 /mnt/cdrom/rpms/rhel4.0 OS Red Hat Enterprise Linux AS 4 /mnt/cdrom/rpms/rhel4.0 # cd /mnt/cdrom/rpms/rhel4.0 2. RPM RPM PHP Apache 10
Apache PHP pgpool PostGIS sra-apache-1.3.36-1.i386.rpm sra-php-4.4.2-1.i386.rpm pgpool-3.0.2-1vl1.i386.rpm postgis-1.1.2-1.i386.rpm (postgis-utils-2.2.2-1.i386.rpm) geos-2.2.2-1.i386.rpm (geos-devel-2.2.2-1.i386.rpm) proj-4.4.9-1.i386.rpm (proj-devel-4.4.9-1.i386.rpm) Apache # sudo rpm -ivh sra-apache-1.3.36-1.i386.rpm Preparing... ########################################### [100%] 1:sra-apache ########################################### [100%] RPM 5.1.1 5.1.1 Apache Apache /usr/local/apache Apache # /etc/init.d/apache start # /etc/init.d/apache stop 5.1.2 PHP PHP /usr/local/php PHP Apache PHP PHP Apache (/usr/local/apache/httpd.conf) ( ) Apache 11
<IfDefine SSL> LoadModule ssl_module libexec/libssl.so </IfDefine> LoadModule php4 module libexec/libphp4.so # Reconstruction of the complete module list from all available modules # (static and shared ones) to achieve correct module execution order. <IfDefine SSL> AddModule mod_ssl.c </IfDefine> AddModule mod php4.c # # ExtendedStatus controls whether Apache will generate "full" status # make certain files to be certain types. # AddType application/x-tar.tgz AddType application/x-httpd-php.php # # AddEncoding allows you to have certain browsers uncompress 5.1.3 pgpool pgpool /usr/local/bin/pgpool /usr/local/etc/pgpool.conf.sample pgpool /usr/local/etc/pgpool.conf pgpool.conf.sample pgpool.conf 5.1.4 PostGIS PostGIS PostGIS PostGIS $ /opt/powergres/bin/createlang plpgsql <dbname> $ /opt/powergres/bin/psql -f /opt/powergres/share/contrib/lwpostgis.sql -d <dbname> 12
<dbname> PostGIS 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. Do you uninstall PowerGres on Linux really (yes/no): yes no 5. ( ) 13
Preparing uninstallation... Succeeded. Uninstalling powergresadmin... Succeeded. Uninstalling powergresadmin-apache... Succeeded. Uninstalling powergresadmin-php... Succeeded. Uninstalling powergres-docs... Succeeded. Uninstalling powergres-jdbc... Succeeded. Uninstalling powergres-test... Succeeded. Uninstalling powergres-contrib... Succeeded. Uninstalling powergres-server... Succeeded. Uninstalling powergres... Succeeded. Uninstalling powergres-devel... Succeeded. Uninstalling powergres-libs... Succeeded. 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 14
7.1 30 E-mail 3 (3 ) 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 15