Date: 28-10-01 19:33
(posted by Dan Langille)
Pgaccess (http://www.flex.ro/pgaccess) is a GUI for the PostgreSQL
database. It has the ability to create tables, queries, views, reports,
forms, schema and many other functions. However it does take a bit of configuring to get it working properly on FreeBSD... one of the joys of using FreeBSD as opposed to our more popular cousin ;).
The main problem is configuring Postgres to use the proper versions of wish,tcl,and tk (as FreeBSD uses multiple versions) and editing a few files.
The ports didn't work for me, so I downloaded the Postgres tarball from their website and untarred it in /usr/local. Changing to the
Postgresql-*.*.*/src/ directory, I configured it as follows:
./configure --with-odbc --with-tcl=/usr/local/include/tcl8.3
You can add the Perl interface and others as you prefer.
Then do a gmake install, as Postgres won't compile with regular make.
I then cd'd to /interfaces/libpgtcl to build libpgtcl and added this to
CFLAGS += -I/usr/local/include/tcl8.3
CFLAGS += -I/usr/local/include/tk8.3
Then a gmake install to build it.
I then went into /usr/local/bin and edited the following lines in
pgaccess to read:
I then edited my home .profile to add the directory to my path:
/usr/local/pgsql/bin; export PATH
I kept getting libpgtcl errors when I tried to run pgaccess, so I added
the following to /etc/rc.conf as FreeBSD doesn't use ld.so.conf for
ldconfig_paths="/usr/lib/compat /usr/X11R6/lib /usr/local/lib /usr/
You can also do this manually using the ldconfig command but I think
it's easier to put it in /etc/rc.conf so it's there permanently. I then
After doing your initdb and postmaster commands for Postgres to specify the directory for the databases, you can then call up Postgres with the following:
postmaster -i -D /path/to/your/databases
Then a command of:
should bring up the gui and get you started. Just add your database name after the pgaccess command if you want to start working in an existing database.
This is how I got it working, but any comments, suggestions or other
tips are welcome.