Since I first looked into the upcoming PostgreSQL integration into Solaris, I had a couple of issues with how this was done. Since at least one hasn't been dealt with yet, I'd like to raise them here:
* As I had already commented two months ago in the only message on the solarispackages-hackers at pgfoundry.org mailing list http://lists.pgfoundry.org/pipermail/solarispackages-hackers/2006-March/000000.html I have some issues with the directories selected for some pgsql components. To cite from that message: * Shipping many internal PostgreSQL modules directly in /usr/lib completely clutters this directory, which should be a no-no. I think only the libraries that represent an interface belong there. The modules rather belong into /usr/lib/pgsql, just like /usr/lib/dns. * The use of /var/lib/pgsql for the the data and backups directories seems wrong on Solaris: I can see no reason at all for having /var/lib; this seems to be an unfortunate Linuxism that shouldn't creep into the Solaris version. I think simply /var/pgsql would be more appropriate here. /var/pgsql would also be much more in line with /var/mysql. I'm pretty sure that I opened a bug on either bugs.opensolaris.org or the Solaris Express feedback site about this, but so far this hasn't turned up. My message above hasn't triggered any response either, although the third issue has been silently been fixed since. I'm willing to work on this, as I think this should be fixed before pgsql ships with S10 U2. I can hardly believe that such directory settings have passed ARC review, but if I understand things correctly, sfwnv isn't subject to that anyway? * Two other issues that might be interesting are 6412876 RFE: PostgresQL should support Kerberos authentication I'll try this as well, but currently this relies on the exposure of the krb5 API in snv_38, so it cannot easily backported to S10 until that fix gets there, too. * It might be interesting to investigate what kind of performance difference a 64-bit pgsql makes. This is probably something for the main pgsql site/mailing lists rather than sfwnv, though. * I noticed that currently, pgsql is statically linked against libreadline. It would probably be very useful to provide a dynamic libreadline, since several other programs could benefit as well, e.g. gdb. * Last but not least, it would be very desirable to have at the very least an init.d script for pgsql, but perferably convert it to an SMF service. There's an open CR for this, too: 6405382 No manifest/start method included in SUNWpostgr-server but I have no idea who the submitter is and how far this has progressed. Rainer ----------------------------------------------------------------------------- Rainer Orth, Faculty of Technology, Bielefeld University
