Re: Cygwin PostgreSQL Distribution

Jason Tishler wrote:
> By extracting pg_config from the following:

>     ftp://ftp.postgresql.org/pub/pub/dev/test-rpms/postgresql-devel-7.1RC2-1.i386.rpm

> I have discovered that at least one PostgreSQL Distribution is
> configured as follows:

>     --enable-locale --with-CXX --prefix=/usr --with-perl
>     --enable-multibyte --with-tcl --with-odbc --enable-syslog
>     --with-python --sysconfdir=/etc/pgsql --mandir=/usr/man
>     --docdir=/usr/doc --includedir=/usr/include/pgsql
>     --datadir=/usr/share/pgsql

And I'm using 'pgsql' instead of 'postgresql' for historical reasons, as
I must fit the RPMset into an environment where the data has lived for
ages in /var/lib/pgsql, the libraries have lived forever in
/usr/lib/pgsql....  Changing to using 'postgresql' is currently not
planned. I may do so for a future version, however, if the _need_
arises.

After all, even on postgresql.org, the snapshots extract to the 'pgsql'
tree.  Yes, it is inconsistent.

> Should I be using the above?  Or, at least the directory affecting
> options (with possibly pgsql replaced by postgresql as you previously
> suggested)?

For your application, you can pretty much dictate where everything will
go as there really isn't a preexisting standard layout.  However, to get
the 'postgresql' part of the directory name only requires that you drop
the 'pgsql' from the above -- the 'postgresql' will be automatically
appended.

Glad you're grabbing the bull by the horns, though!
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11