Projects : Databases

BSDforge™

FreeBSD ports, or other *BSD related projects, that I either created, maintain, host, or worked on. Following, are those in the databases category.

PgWorksheet Installation

Supported Operating Systems:

PgWorksheet requires the following software to run:


Please use the package/ports system of your UNIX/BSD system, or Linux distribution, to install these dependencies.

FreeBSD

By far, FreeBSD is probably the easiest version to install.

Using the ports system:

cd /usr/ports/databases/pgworksheet
make install clean
Using the pkg system:
pkg install databases/pgworksheet

Microsoft Windows XP/Vista

To install and run PgWorksheet under Microsoft Windows XP/Vista:

Download the pgworksheet-1.9-setup-win32.exe setup program and execute it.

This setup will create a shortcut to PgWorksheet in the start menu.

Linux Fedora

Install the dependencies:

su
yum install python-pgsql
Install PgWorksheet:

Download the PgWorksheet RPM

Install the RPMs:

rpm -ivh pgworksheet-1.9-1.fedora.noarch.rpm
Once installed, you can find a new icon in the Gnome menu.

If your processor architecture isn't supported by the pre-compiled packages, use the source RPMs avaibles in the downloads.

Linux Mandriva

PgWorksheet is in the Mandriva contrib repository.

You can install it using Install & Remove Software.

Alternatively, you can install this package using urpmi:

su
urpmi pgworksheet
After installation, a new icon is installed in the More Applications menu.

Ubuntu Linux

Install the dependencies:

sudo apt-get install postgresql-client python-pgsql
Install PgWorksheet

Download the PgWorksheet DEB

Install the DEB:

sudo dpkg -i pgworksheet_1.9-1_all.deb
A new icon is installed in the Gnome menu.

OpenSUSE

Install the following dependency using the Install Software icons or using the command line:

postgresql
Install PgWorksheet:

Download the python-pgsql package

Download the PgWorksheet package

Install the packages:

sudo rpm -ivh python-pgsql-0.9.7-1.opensuse.i586.rpm
sudo rpm -ivh pgworksheet-1.9-1.opensuse.noarch.rpm
A new icon is installed in the menu.

For the python-pgsql package if your processor architecture isn't supported, use the source RPMs avaibles in the downloads.

Other Operating Systems

If your operating system is not listed here, or if something goes wrong with the binary, pre-compiled packages:

  • Install the dependencies: Please see above, for each operating system, or below for generic insctructions.
  • Download the os-independent package.
  • Install the package:
    • cd pgworksheet-1.9
    python setup.py build
    python setup.py install

Once installed, simply execute the pgworksheet script.