Postgresql7 version 7.4.24 - How to Download and Install on Mac OS X
Sunday the 21st of March, 2010

    postgresql7  most recent diff


    version 7.4.24

      View the most recent changes for the postgresql7 port at: postgresql7.darwinports.com/diff
      Scroll down toward the bottom of the page to get installation instructions for postgresql7.
      The raw portfile for postgresql7 7.4.24 is located here:
      http://postgresql7.darwinports.com/dports/databases/postgresql7/Portfile
      Find related portfiles with the unique DarwinPorts.com search feature.
      Check for any related Fink projects here: pdb.finkproject.org/pdb/package.php/postgresql7


      The postgresql7 Portfile 57375 2009-09-10 08:16:41Z ryandesign macports.org $

      PortSystem 1.0

      Name: postgresql7
      Version: 7.4.24
      Category: databases
      Platform: darwin
      Maintainers: mww jwa
      Description: The most advanced open-source database available anywhere
      Long Description: PostgreSQL is Object-Relational Database Management System. It supports almost all SQL constructs, including transactions, subselects, and user-defined types and functions. Write-ahead logging means increased performance while retaining data integrity. This version does not work on Mac OS X Intel!

      Homepage: http://www.postgresql.org/
      Master Sites: http://ftp.de.postgresql.org/mirror/postgresql//source/v${version} postgresql:source/v${version}

      Checksums: md5 8287efcb6d4d0f2a631fd35149e8b8d2 sha1 a38d8045d2d01f501671e1a4b72473d7f8739107 rmd160 63a7908aef92ddc591d58332ff4bd0bdaa6b0fcf
      use_bzip2 yes

      depends_lib port:readline port:openssl port:zlib port:bison

      distname postgresql-${version}

      set libdir ${prefix}/lib/pgsql7
      configure.args --sysconfdir=${prefix}/etc/pgsql7 --bindir=${libdir}/bin --libdir=${libdir} --includedir=${prefix}/include/pgsql7 --datadir=${prefix}/share/${name} --mandir=${prefix}/share/man --docdir=${prefix}/share/doc/${name} --with-docdir=${prefix}/share/doc/${name} --with-includes=${prefix}/include --with-libraries=${prefix}/lib --with-openssl=${prefix} --with-rendezvous --with-readline --with-zlib --enable-thread-safety --enable-integer-datetimes --enable-multibyte --enable-unicode

      build.type gnu

      post-build {
      # build autovacuum
      system "cd ${worksrcpath}/contrib/pg_autovacuum && ${build.cmd}"
      # build tsearch2
      system "cd ${worksrcpath}/contrib/tsearch2 && ${build.cmd}"
      }

      test.run yes
      test.target check

      # install headers too
      destroot.target-append install-all-headers
      post-destroot {
      # install autovacuum
      xinstall -m 755 -s ${worksrcpath}/contrib/pg_autovacuum/pg_autovacuum ${destroot}${libdir}/bin
      # install tsearch2
      system "cd ${worksrcpath}/contrib/tsearch2 && ${build.cmd} install ${destroot.destdir}"
      # symlinks
      system "cd ${destroot}${prefix}/bin && ln -sf ${libdir}/bin/psql psql7"
      # nuke nonsense
      system "cd ${destroot}${prefix}/share && rm -rf doc"
      }

      # Defaults for database
      set dbdir ${prefix}/var/db/pgsql7/defaultdb
      set logdir ${prefix}/var/log/pgsql7
      set dbuser postgres7
      set dbgrp postgres

      Variant: perl description {add Perl support} {
      configure.args-append --with-perl
      depends_lib-append bin:perl:perl5
      }

      Variant: java description {add Java support} {
      configure.args-append --with-java
      depends_build port:apache-ant
      depends_lib-append bin:java:kaffe
      configure.env-append ANT=${prefix}/share/java/apache-ant/bin/ant
      }

      Variant: tcltk description {add tcl, tk support} {
      configure.args-append --with-tcl --with-tclconfig=${prefix}/lib --with-tkconfig=${prefix}/lib
      configure.env-append TCLSH=${prefix}/bin/tclsh
      depends_lib-append port:tcl port:tk
      }

      Variant: server description {add startup item for server} {
      startupitem.create yes
      startupitem.init "PGCTL=${libdir}/bin/pg_ctl"
      startupitem.start "su ${dbuser} -c \"\${PGCTL} -D \${POSTGRESQL7DATA:=${dbdir}} start -l ${logdir}/postgres.log\""
      startupitem.stop "su ${dbuser} -c \"\${PGCTL} -D \${POSTGRESQL8DATA:=${dbdir}} stop -s -m fast\""

      pre-destroot {
      xinstall -m 755 -d ${destroot}${dbdir} ${destroot}${prefix}/var/log/pgsql ${destroot}${prefix}/var/db/pgsql
      # Add User postgres:postgres
      addgroup ${dbuser}
      set gid [existsgroup ${dbgrp}]
      adduser ${dbuser} shell=/bin/sh gid=${gid} home=${prefix}/var/db/pgsql7 realname=PostgreSQL-7\ Server
      }

      post-destroot {
      destroot.keepdirs ${destroot}${prefix}/var/db/pgsql
      system "cd ${destroot}${prefix}/var/log/pgsql && touch pgsql.log pg_autovacuum.log"

      foreach d { db/pgsql log/pgsql log/pgsql/pgsql.log log/pgsql/pg_autovacuum.log } {
      file attributes ${destroot}${prefix}/var/${d} -group ${dbgr} -owner ${dbuser}
      }
      }

      post-install {
      ui_msg "\nTo create a database instance, after install do\n sudo su ${dbuser} -c \'${libdir}/bin/initdb -D ${dbdir}\'"
      }
      }

      platform darwin i386 {
      extract { return -code error "\n\nThis platform is not supported by PostgreSQL 7. Please migrate to the PostgreSQL 8 series!\n" }
      }

      livecheck.type regex
      livecheck.url ${homepage}
      livecheck.regex (7.4.\[0-9\]+)


    If you haven't already installed Darwin Ports, you can find easy instructions for doing so at the main Darwin Ports page.

    Once Darwin Ports has been installed, in a terminal window and while online, type the following and hit return:


      %  cd /opt/local/bin/portslocation/dports/postgresql7
      % sudo port install postgresql7
      Password:
    You will then be prompted for your root password, which you should enter. You may have to wait for a few minutes while the software is retrieved from the network and installed for you. Y ou should see something that looks similar to:

      ---> Fetching postgresql7
      ---> Verifying checksum for postgresql7
      ---> Extracting postgresql7
      ---> Configuring postgresql7
      ---> Building postgresql7 with target all
      ---> Staging postgresql7 into destroot
      ---> Installing postgresql7
    - Make sure that you do not close the terminal window while Darwin Ports is working. Once the software has been installed, you can find further information about using postgresql7 with these commands:
      %  man postgresql7
      % apropos postgresql7
      % which postgresql7
      % locate postgresql7

     Where to find more information:

    Darwin Ports



    Lightbox this page.