### pgAdmin3 CVS snapshots in binary formats

pgAdmin3 CVS snapshots are available for several platforms, including GNU/Linux, FreeBSD and Microsoft Windows 2000/XP. Several ports are in preparation, including MacOsX. We are doing our best to update these snapshots almost nightly.

Please report bugs, problems and suggestions to the pgadmin mailing list: pgadmin-support@postgresql.org or pgadmin-hackers@postgresql.org. A registration on the mailing-list is needed before posting a message.

### Important note:

There is no guarantee that these packages work in any way: it is beta developer software intended for testing and development.

Presently, daily snapshots are compiled for the following platforms:

- GNU/Linux Debian

- GNU/Linux RedHat 9, SuSE 8.2, Mandrake 9.1

- GNU/Linux Slackware 9.0

- FreeBSD 5.1

- Microsoft Windows 2000 & XP

### GNU/Linux Debian

Packager: Raphaël Enrici
The packages are available from pgAdmin apt repository. If you want to install pgAdmin3 on a Debian subsystem please follow these instructions :

- APT Configuration
  Edit /etc/apt/sources.list and add the following line:

  - For Debian WOODY:
    deb http://www.pgadmin.org/snapshots/linux/debian woody pgadmin

  - For Debian TESTING:
    deb http://www.pgadmin.org/snapshots/linux/debian testing pgadmin

  - For Debian UNSTABLE:
    deb http://www.pgadmin.org/snapshots/linux/debian unstable pgadmin

- Installation
  After you configured you sources.list as mentioned above, simply do this as root:
  # apt-get update
  # apt-get install pgadmin3
  Launch the software by typing "pgadmin3" and have fun! Please, feel free to report any problem to pgadmin-hackers list. Thanks!

- DEVELOPERS' CORNER
  If you want to get the source packages simply modify your /etc/apt/sources.list:

  - For Debian WOODY:
    deb-src http://www.pgadmin.org/snapshots/linux/debian woody pgadmin

  - For Debian TESTING:
    deb-src http://www.pgadmin.org/snapshots/linux/debian testing pgadmin

  - For Debian UNSTABLE:
    deb-src http://www.pgadmin.org/snapshots/linux/debian unstable pgadmin

  You may also want to check wxWidgets 2.5 cvs version static packages which were used to build pgadmin3 packages:
  (PLEASE REMEMBER, THESE PACKAGES ARE REALLY EXPERIMENTAL, THEY CAN BREAK YOUR SYSTEM!! YOU HAVE BEEN WARNED!)
  Binaries and sources are available for woody, testing and unstable:

  - For Debian WOODY:
    deb http://www.pgadmin.org/snapshots/linux/debian experimental/woody wxWidgets-pgadmin3
    deb-src http://www.pgadmin.org/snapshots/linux/debian experimental/woody wxWidgets-pgadmin3

  - For Debian TESTING:
    deb http://www.pgadmin.org/snapshots/linux/debian experimental/testing wxWidgets-pgadmin3
    deb-src http://www.pgadmin.org/snapshots/linux/debian experimental/testing wxWidgets-pgadmin3

  - For Debian UNSTABLE:
    deb http://www.pgadmin.org/snapshots/linux/debian experimental/unstable wxWidgets-pgadmin3
    deb-src http://www.pgadmin.org/snapshots/linux/debian experimental/unstable wxWidgets-pgadmin3

  It contains the three following packages which were used to build pgadmin3:

  - pgadmin3-libwxgtk2ud2.5

  - pgadmin3-libwxgtk2ud2.5-contrib

  - pgadmin3-libwxgtk2ud2.5-dev

  And if you want sources of the three precedent packages:
  # deb-src http://www.pgadmin.org/snapshots/linux/debian experimental/woody wxWidgets-pgadmin3

- To compile and rebuild the pgadmin3 package:

  - First, as root
    # apt-get update
    # apt-get build-dep pgadmin3
    This should install pgadmin3-wxWidgets* packages.

  - Then as a normal user
    Fetch the source # apt-get source pgadmin3
    # cd pgadmin3-0.1.1
    Compile and build the package # dpkg-buildpackage -rfakeroot
    # cd .. ; ls *.deb

  - Or as root (not recommended)
    Fetch,compile & build the package
    # apt-get --compile source pgadmin3

  Any comments are welcome.

### GNU/Linux Mandrake 9.1, RedHat 9, SuSE 8.2

Packager: Jean-Michel POURE

- Binary RPM packages

  pgAdmin3 binary RPM packages are compiled statically against wxGTK 2.5. Therefore there is not need to install wxGTK 2.5 libraries. pgAdmin3 binaries are compiled with Unicode and debugging mode and linked against GTK2. The binaries are localised in several languages and include the latest PostgreSQL documentation. The required steps for installation are:

  1. Download the latest pgAdmin3 RPM package from:
     http://www.pgadmin.org/snapshots/linux/mandrake91/RPMS
     http://www.pgadmin.org/snapshots/linux/redhat9/RPMS.
     http://www.pgadmin.org/snapshots/linux/suse82/RPMS.

  2. Install the downloaded RPM using the following command:
     # rpm -Uvh pgadmin3*.rpm

  3. pgAdmin3 RPM will check for the needed dependencies and warn you if some packages are not installed. All needed dependencies are included in the stock RedHat 9 distribution.

- wxGTK 2.5 libraries

  If you want to contribute pgAdmin3 projects or simply compile from source, you need a recent GNU/Linux distribution with wxGTK 2.5 libraries, header files and contributed libraries. For your convenience and to avoid long compilation times (sometimes hours), we provide wxGTK 2.5 CVS snapshots in RPM format.

  1. Download the four latest wxGTK 2.5 RPM packages from:
     http://www.pgadmin.org/snapshots/linux/mandrake91/wxGTK2
     http://www.pgadmin.org/snapshots/linux/redhat9/wxGTK2
     http://www.pgadmin.org/snapshots/linux/suse82/wxGTK2
     The packages are numbered:
     - wxGTK2ud-$version-.i386.rpm
     - wxGTK2ud-devel-$version.i386.rpm
     - wxGTK2ud-xtc-$version.i386.rpm
     - wxGTK2ud-stc-$version.i386.rpm

  2. Install the downloaded RPM using the following command:
     # rpm -Uvh wxGTK2ud*.rpm

  3. wxGTK2ud RPMs will check for the needed dependencies and warn you if some packages are not installed.

### GNU/Slackware 9.0

Packager: Dave Page

- Binary packages

  pgAdmin3 binary packages are compiled statically against wxGTK 2.5. Therefore there is not need to install wxGTK 2.5 libraries. pgAdmin3 binaries are compiled with Unicode and debugging mode and linked against GTK2. The binaries are localised in several languages and include the latest PostgreSQL documentation. The required steps for installation are:

  1. Download the latest packages from http://www.pgadmin.org/snapshots/linux/slackware90.

  2. Install the downloaded packages using Slackwares pkgtool or installpkg.

- wxGTK 2.5 libraries

  Sorry, we do not provide development packages in GNU/Slackware 9.0. If you want to contribute pgAdmin3 projects or simply compile from source, you need a recent GNU/Linux distribution with wxGTK 2.5 CVS libraries, header files and contributed libraries compiled from source. This is actually very straightforward on Slackware 9 as all dependencies should already be installed. You should find that the compilation instructions detail the exact steps required.

  ### FreeBSD 5.1

  Packager: Hiroshi Saito

  pgAdmin3 binary packages are compiled statically against wxGTK 2.5. Therefore there is not need to install wxGTK 2.5 libraries. pgAdmin3 binaries are compiled with Unicode and debugging mode and linked against GTK2. The binaries are localised in several languages and include the latest PostgreSQL documentation.

  1. Installation

     # pkg_add pgadmin3-yyyymmdd.tgz

  2. Create a symlink to pgadmin3 binary

     # ln -sf /usr/local/pgadmin3/bin/pgadmin3 /usr/local/bin/pgadmin3

  3. Check that pgadmin3 is in the path

     # which pgadmin3 # /usr/local/bin/pgadmin3

  4. UnInstall

     # pkg_delete pgadmin3-0.1.1

  ### Microsoft Windows 2000 & XP

  Packager: Andreas Pflug

  1. Binary packages

     pgAdmin3 binary packages are compiled statically against wxGTK 2.5. Therefore there is no need to install wxGTK 2.5 libraries. pgAdmin3 binaries are compiled with Unicode. The binaries are localised in several languages. The required steps for installation are:

     1. Download the latest packages from http://www.pgadmin.org/snapshots/win32.

     2. Unzip and copy all files in the directory of your choice.

     3. Double-click on pgAdmin3.exe.

  2. wxGTK 2.5 libraries

     Presently, we do not provide wxGTK 2.5 packages for compiling pgAdmin3 under Windows. You will need to install wxGTK 2.5 cvs version from source. We would love to hear your experience if you could compile pgAdmin3 successfully under Mingw. Stay tuned...