Re: postgresql-8.01 and 8.1 ready
Jason Tishler schrieb: On Fri, Sep 23, 2005 at 11:37:46AM +0200, Corinna Vinschen wrote: On Sep 23 10:30, Gerrit P. Haase wrote: Reini Urban wrote: Gerrit P. Haase schrieb: Reini Urban wrote: Installing as service is quite hard without sysbash, [snip] So it is not possible to run this as service? No, now you have two options to run it as service: cygrunsrv and pg_ctl. What is the problem with the method used in postgres 7? Nothing. >>>What is sysbash? Not yet a package unfortunately. http://sources.redhat.com/ml/cygwin/2004-08/msg01177.html [snip] Good questions. Ideally I'd assume that the new postgresql just works as a replacement for the old postgresql so that existing service installations using cygrunsrv are not suddenly broken. postgresql-8.x work with various types of service registrations and start methods: * The native one is via pg_ctl (new). * My new init.d script is to mimic the old and wellknown behaviour using cygrunsvr (as before). * And then you can always start postmaster as before, without service and without pg_ctl. Important changes from 7.x to 8.x: * admin binaries in /usr/sbin, and not in /usr/bin anymore. (similar to debian) * native windows service functions added to pg_ctl * contrib binaries in /usr/lib/postgresql/bin I recommend to set PGDATA to /usr/share/postgresql/data-8.0. PGDATA is versioned and you can easily have multiple PGDATA dirs. I have data-7.4, data-8.0 and data-8.1 To be specific, why doesn't the following (excerpt) from my PostgreSQL 7.x README work for 8.x? $ cygserver-config $ net user postgres $password /add /fullname:postgres /comment:'PostgreSQL user account' /homedir:"$(cygpath -w /home/postgres)" $ mkpasswd -l -u postgres >>/etc/passwd $ cmd /c secpol.msc # grant postgres "Log on as a service" user right $ cygrunsrv --install postmaster --path /usr/bin/postmaster --args "-D /var/postgresql/data -i" --dep cygserver --termsig INT --user postgres --shutdown Because 8.x put postmaster into /usr/sbin I haven't checked --termsig INT though. -- Reini
Re: libming and ploticus
Andrew Schulman schrieb: I'm considering packaging ploticus for Cygwin. Ploticus can output images in many formats, including SWF, but SWF requires libming, which isn't currently in Cygwin. I found this thread from Reini Urban, about packaging libming for Cygwin: http://www.cygwin.com/ml/cygwin-apps/2004-09/msg00315.html Reini, do you still intend to package libming for Cygwin? (Or is anyone else interested?) I could take a hack at it myself, but that old thread suggests that there are a lot of packaging considerations that you had already worked on. For ploticus, libming isn't essential at all, but it would be nice to include the SWF output capability. For that, all I would need is libming.so, plus the header files to build ploticus. I have both ploticus and libming at my repository. I use it very often for phpwiki. libming is very unstable but okay as static lib, ploticus very stable. I don't really want to propose ploticus, because pl.exe is already given to SWI-Prolog, so I'm happy using it internally. http://cygwin.com/cgi-bin2/package-grep.cgi?grep=pl.exe And I don't really want to change the name to ploticus.exe The problems with other attempts to package ploticus was the bad location of the required prefabs and the samples. /usr/bin/pl.exe /usr/lib/libploticus.a /usr/share/doc/Cygwin/ploticus-2.30-2.README /usr/share/doc/ploticus-2.30-2/Copyright /usr/share/doc/ploticus-2.30-2/FreeType2 /usr/share/doc/ploticus-2.30-2/GPL.txt /usr/share/doc/ploticus-2.30-2/README /usr/share/doc/ploticus-2.30-2/stock.htm /usr/share/doc/ploticus-2.30-2/volunteers.htm /usr/share/doc/ploticus-2.30-2/gallery/* (samples from pl230gal) /usr/share/doc/ploticus-2.30-2/index.html /usr/share/doc/ploticus-2.30-2/doc/* (website from pl230docs) /usr/share/fonts/fdb/Bitstream Vera Sans Mono-B-I.fdb (for SWF) /usr/share/fonts/fdb/Bitstream Vera Sans Mono-B.fdb /usr/share/fonts/fdb/Bitstream Vera Sans Mono-I.fdb /usr/share/fonts/fdb/Bitstream Vera Sans Mono.fdb /usr/share/fonts/fdb/Bitstream Vera Sans-B-I.fdb /usr/share/fonts/fdb/Bitstream Vera Sans-B.fdb /usr/share/fonts/fdb/Bitstream Vera Sans-I.fdb /usr/share/fonts/fdb/Bitstream Vera Sans.fdb (the default) /usr/share/fonts/fdb/Bitstream Vera Serif-B.fdb /usr/share/fonts/fdb/Bitstream Vera Serif.fdb /usr/share/ploticus/README /usr/share/ploticus/*.pl (prefab ploticus scripts, not perl!) /usr/share/ploticus/GraphPopups.js (additional SVG javascript hooks) /usr/share/ploticus/ViewBox.js /usr/share/ploticus/pltestsuite/* I would be happy if you would like to propose it, but not so happy if you leave out the prefabs, docs, samples and testsuite. I forgot if Bitstream Vera is in any other package yet. package-grep doesn't find it. Should be so. Maybe like this? /usr/bin/ploticus.exe postinstall.sh: test -f /usr/bin/pl || ln -s /usr/bin/ploticus /usr/bin/pl -- Reini
Re: postgresql-8.01 and 8.1 ready
Reini, On Sat, Sep 24, 2005 at 03:07:05PM +0200, Reini Urban wrote: > >To be specific, why doesn't the following (excerpt) from my > >PostgreSQL 7.x README work for 8.x? > > > >$ cygserver-config > >$ net user postgres $password /add /fullname:postgres > >/comment:'PostgreSQL user account' /homedir:"$(cygpath -w > >/home/postgres)" > >$ mkpasswd -l -u postgres >>/etc/passwd > >$ cmd /c secpol.msc # grant postgres "Log on as a service" user right > >$ cygrunsrv --install postmaster --path /usr/bin/postmaster --args "-D > >/var/postgresql/data -i" --dep cygserver --termsig INT --user postgres > >--shutdown > > Because 8.x put postmaster into /usr/sbin With the the minor change to postmaster's path, does the above still work? > I haven't checked --termsig INT though. I would expect the above to still work too. But, you should verify to make sure of clean database shutdown semantics when the machine is shutdown. Thanks, Jason -- PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
