SHIBUYA Hisao E-mail : shibuya@alpha.or.jp 58 - Software Design
c h a p t e r 6 $ rpm -q glibc glibc-2.1.2-17vl2 [glibc 2.1]Vine 2.0beta2 glibc-2.0.7-29 [glibc 2.0]Vine 1.1 ftp://ftp. vinelinux.org/ # rpm -ivh postgresql-6.5.3_jp-2.i386.rpm $ rpm -qa grep postgresql $ ls /var/lib/pgsql Jun. 2000-59
# /etc/rc.d/init.d/postgresql start $ pg_dumpall > db.bak $ /etc/rc.d/init.d/postgresql stop $ cd /var/lib/; mv pgsql pgsql.orig $ rpm -qa grep postgres $ rpm -e $ rpm -ivh $ cd /var/lib; cp pgsql pgsql.orig $ rpm -Uvh $ initdb --pglib=/usr/lib/pgsql --pgdata= /var/lib/pgsql) $ psql -e template1 <db.bak 60 - Software Design
c h a p t e r 6 KUWAMURA Jun E-mail : juk@yokohama.email.ne.jp ftp://ftp.linet.gr.jp/ pub/plamo/ ftp://plamo.linet.gr. jp/pub/ http://www.linux4u.net/ Jun. 2000-61
# mount /cdrom # cd /cdrom/contrib/database # installpkg pgsql653+.tgz # mount /cdrom # cd /cdrom/contrib/database # pkgtool 62 - Software Design
c h a p t e r 6 Jun. 2000-63
Kenshi MUTO E-mail : kmuto@debian.org deb ftp://ftp.jp.debian.org/debian woody main contrib non-free ftp://ftp.jp.debian.org/debian/ # apt-get update 64 - Software Design
c h a p t e r 6 Reading Package Lists... Done Building Dependency Tree... Done The following extra packages will be installed: ecpg libpgsql2 libpgtcl pgaccess postgresql postgresql-client postgresql-contrib postgresql-doc postgresql-pl tcl8.0 tk8.0 The following NEW packages will be installed: ecpg libpgsql2 libpgtcl pgaccess postgresql postgresql-client postgresql-contrib postgresql-doc postgresql-pl task-database-pg tcl8.0 tk8.0 0 packages upgraded, 12 newly installed, 0 to remove and 15 not upgraded. Need to get 0B/4432kB of archives. After unpacking 13.1MB will be used. Do you want to continue? [Y/n] # apt-get install task-database-pg # apt-get update; apt-get dist-upgrade # cd /usr/lib/postgresql/dumpall/6.3 # ln -s postgres postmaster $ postgresql-dump -t db.out -dcilp $PGDATA/../data.save Jun. 2000-65
# /etc/init.d/postgresql restart 66 - Software Design
c h a p t e r 6 FUKUHARA Ichiro Email : ichiro@jp.postgresql.org Jun. 2000-67
ftp://ftp.jp.freebsd.org/pub/freebsd/ branches/-current/ports.tar.gz ftp://ftp.jp.netbsd.org/pub/net BSD/packages/1.4.2/i386/databases/postgres ql-6.5.3.tgz # /usr/sbin/pkg_add postgresql-6.5.3.tgz http:// www.jp.netbsd.org/ja/jp/documentation/ anoncvs.html # cd /usr/ports/japanese/postgresql # make MULTIBYTE=EUC_JP, USE_TCL=yes, USE_PERL=yes, USE_ODBC=yes # make install 68 - Software Design
c h a p t e r 6 TANIDA Yutaka E-mail : yutaka@hi-net.zaq.ne.jp $ mkdir /etc $ mkdir /tmp $ mount c:/cygnus/cygwin-b20/h-i586- cygwin32/bin /bin http://sourceware.cygnus.com/cygwin/ $ mkpasswd -l > /etc/passwd $ mkgroups -l > /etc/groups http://www.xemacs.freeserve. co.uk/ Jun. 2000-69
$ bzip2 -d cygwin32_ipc-1.03-bin-patched.tar.bz2 $ tar -xf cygwin32_ipc-1.03-bin-patched.tar $ cp bin/* /bin $ ipc-daemon & $ mkdir /usr $ mkdir /usr/local $ bzip2 -d postgresql-cygwinb20.1-6.5.3-euc_jp.tar.bz2 $ tar -xf postgresql-cygwinb20.1-6.5.3-euc_jp.tar $ cp -r pgsql /usr/local/ $ ipc-daemon &... $ initdb... $ postmaster -i... $ psql -h 127.0.0.1 template1 Welcome to the POSTGRESQL interactive sql monitor: Please read the file COPYRIGHT for copyright terms of POSTGRESQL [PostgreSQL 6.5.3 on i686-pc-cygwin, compiled by gcc 2.95] type \? for help on slash commands type \q to quit type \g or terminate with semicolon to execute query You are currently connected to the database: template1 template1=> 70 - Software Design
c h a p t e r 6 http://innovation. idetix.com/invoker/ C:\>invoker install cygipc cygipc "ipc-daemon.exe -q" manual true C:\>invoker install pgsql pgsql "sh -c 'postmaster -i'" manual true Jun. 2000-71