FreeBSD port of CONNECT BY patch for pgsql
john at jnielsen.net
Tue Mar 15 21:36:46 PST 2005
I am interested in creating a FreeBSD port of PostgreSQL 8.0.1 that
incorporates the CONNECT BY patch found here:
I have successfully compiled and installed the modified postgres on my
system, and I'd like to save myself and others in the future the trouble I
went to. Before I proceed, I have a few questions.
First, am I duplicating anyone else's effort?
Second, what would be the best approach in structuring the port? Mr.
Potemkin distributes his modifications as a single diff against the
postgres source tree. In addition to needing this file, the port will also
need to add devel/bison as a build dependency due to the way the diff is
built and applied (I didn't have bison installed, and had to scratch my
head for a while on that one).
The procedure I followed (and the one I'd like the port to emulate) was
fetch (including patch)
install FreeBSD patches from existing port (make patch)
install hier patchset
I followed this procedure for both the client and the server, since they are
distinct FreeBSD ports (even though they are both built from the same
Would it be possible to do all this as a slave port of the existing
postgresql80? Would it be better/easier to duplicate the existing port and
make changes on top of it?
What would be the best way to apply the patchset within the ports framework?
As written, the diff needs to be applied from the work directory rather
than the base of the source distribution directory, so I can't just drop it
in the port's files directory (can I?).
Third, what's the protocol for updating the CONFLICTS of other affected
And finally, what would be a good naming convention? I've considered
postresql_hier-server with postgresql_hier80-server as the directory name.
Please CC me on replies, as I'm not subscribed to ports at .
More information about the freebsd-ports