Thread: A Sparc/Linux patch (for 7.1), and a Linux rc.d/init.d script....
Just a few random bits and pieces that might be useful to someone
else. They are:
postgres-7-sparc.patch -> This is the same one I posted earlier to
hackers and ports, forgot to post it to patches. This fixes the resultmap
for sparc-linux so that all regression tests pass.
postgresql -> This is a Linux distribution independent (or so I
hope) init.d/rc.d script that makes use of pg_ctl. There is currently a
few in ./contrib/linux of the pgsql source tree, but they are RedHat
specific. This one is simple and self contained. Might be worth adding to
the other scripts.
pg_ctl.patch -> Minor patch required by postgresql script above.
It basically just allows you to specify the -o option (postmaster options)
more than once and all of them will be concatenated together. Makes it
easier to do '-o -F -o -i', then to try and shell escape quotes in a shell
script. Should be harmless, and might be handy.
Anyway, just wanted to post them in case some one was interested in them.
TTYL.
---------------------------------------------------------------------------
| "For to me to live is Christ, and to die is gain." |
| --- Philippians 1:21 (KJV) |
---------------------------------------------------------------------------
| Ryan Kirkpatrick | Boulder, Colorado | http://www.rkirkpat.net/ |
---------------------------------------------------------------------------
Attachment
> Just a few random bits and pieces that might be useful to someone > else. They are: > > postgres-7-sparc.patch -> This is the same one I posted earlier to > hackers and ports, forgot to post it to patches. This fixes the resultmap > for sparc-linux so that all regression tests pass. Already applied. > > postgresql -> This is a Linux distribution independent (or so I > hope) init.d/rc.d script that makes use of pg_ctl. There is currently a > few in ./contrib/linux of the pgsql source tree, but they are RedHat > specific. This one is simple and self contained. Might be worth adding to > the other scripts. Added to /contrib as init.d. > > pg_ctl.patch -> Minor patch required by postgresql script above. > It basically just allows you to specify the -o option (postmaster options) > more than once and all of them will be concatenated together. Makes it > easier to do '-o -F -o -i', then to try and shell escape quotes in a shell > script. Should be harmless, and might be handy. This doesn't seem like a good idea. It makes -o handling different for different utilities. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
On Tue, 30 Jan 2001, Bruce Momjian wrote:
> > postgres-7-sparc.patch -> This is the same one I posted earlier to
> > hackers and ports, forgot to post it to patches. This fixes the resultmap
> > for sparc-linux so that all regression tests pass.
>
> Already applied.
Great! Just never saw a confirmation (may have missed it) of my
first post. Also verified it is in beta4, and all regression
tests now pass on Sparc/Linux. :)
> > postgresql -> This is a Linux distribution independent (or so I
> > hope) init.d/rc.d script that makes use of pg_ctl. There is currently a
> > few in ./contrib/linux of the pgsql source tree, but they are RedHat
> > specific. This one is simple and self contained. Might be worth adding to
> > the other scripts.
>
> Added to /contrib as init.d.
Please replace with the one attached to this email message. The
previous version depended on the below patch, this one does not. It is
also a bit cleaner and has a few more helpful comments.
> > pg_ctl.patch -> Minor patch required by postgresql script above.
> > It basically just allows you to specify the -o option (postmaster options)
> > more than once and all of them will be concatenated together. Makes it
> > easier to do '-o -F -o -i', then to try and shell escape quotes in a shell
> > script. Should be harmless, and might be handy.
>
> This doesn't seem like a good idea. It makes -o handling different for
> different utilities.
Hmm... Didn't know other utils used that option. Maybe use the
'--' option for pg_ctl passing postmaster options, i.e. 'pg_ctl start --
-F -i'. Of course that is a bit more major of a change to the code that I
will leave as an exercise to others. With the revised version of the
init.d script attached, the pg_ctl patch is immaterial.
Thanks and TTYL.
---------------------------------------------------------------------------
| "For to me to live is Christ, and to die is gain." |
| --- Philippians 1:21 (KJV) |
---------------------------------------------------------------------------
| Ryan Kirkpatrick | Boulder, Colorado | http://www.rkirkpat.net/ |
---------------------------------------------------------------------------
Attachment
> Great! Just never saw a confirmation (may have missed it) of my
> first post. Also verified it is in beta4, and all regression
> tests now pass on Sparc/Linux. :)
What version of Linux? I'm updating the ports listing...
- Thomas
Applied. > On Tue, 30 Jan 2001, Bruce Momjian wrote: > > > > postgres-7-sparc.patch -> This is the same one I posted earlier to > > > hackers and ports, forgot to post it to patches. This fixes the resultmap > > > for sparc-linux so that all regression tests pass. > > > > Already applied. > > Great! Just never saw a confirmation (may have missed it) of my > first post. Also verified it is in beta4, and all regression > tests now pass on Sparc/Linux. :) > > > > postgresql -> This is a Linux distribution independent (or so I > > > hope) init.d/rc.d script that makes use of pg_ctl. There is currently a > > > few in ./contrib/linux of the pgsql source tree, but they are RedHat > > > specific. This one is simple and self contained. Might be worth adding to > > > the other scripts. > > > > Added to /contrib as init.d. > > Please replace with the one attached to this email message. The > previous version depended on the below patch, this one does not. It is > also a bit cleaner and has a few more helpful comments. > > > > pg_ctl.patch -> Minor patch required by postgresql script above. > > > It basically just allows you to specify the -o option (postmaster options) > > > more than once and all of them will be concatenated together. Makes it > > > easier to do '-o -F -o -i', then to try and shell escape quotes in a shell > > > script. Should be harmless, and might be handy. > > > > This doesn't seem like a good idea. It makes -o handling different for > > different utilities. > > Hmm... Didn't know other utils used that option. Maybe use the > '--' option for pg_ctl passing postmaster options, i.e. 'pg_ctl start -- > -F -i'. Of course that is a bit more major of a change to the code that I > will leave as an exercise to others. With the revised version of the > init.d script attached, the pg_ctl patch is immaterial. > Thanks and TTYL. > > --------------------------------------------------------------------------- > | "For to me to live is Christ, and to die is gain." | > | --- Philippians 1:21 (KJV) | > --------------------------------------------------------------------------- > | Ryan Kirkpatrick | Boulder, Colorado | http://www.rkirkpat.net/ | > --------------------------------------------------------------------------- Content-Description: [ Attachment, skipping... ] -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
On Thu, 1 Feb 2001, Thomas Lockhart wrote:
> > Great! Just never saw a confirmation (may have missed it) of my
> > first post. Also verified it is in beta4, and all regression
> > tests now pass on Sparc/Linux. :)
>
> What version of Linux? I'm updating the ports listing...
Debian GNU/Linux 2.2, with 2.2.15 (stock kernel for this
distribution). For a bit more details, I tested it on a Sparc 20 w/64MB
of RAM, running the stock gcc 2.95.2 and glibc 2.1.3.
Is that sufficient? :)
---------------------------------------------------------------------------
| "For to me to live is Christ, and to die is gain." |
| --- Philippians 1:21 (KJV) |
---------------------------------------------------------------------------
| Ryan Kirkpatrick | Boulder, Colorado | http://www.rkirkpat.net/ |
---------------------------------------------------------------------------
Hello Developers, I have written a function to calculate the julian day from any gregorian day. You can include this code in the contrib directory or whatever place seems applicable in future releases of posgresql. See the attachment for code and examples. -- -- ---> doj@redaex.de
Attachment
> Is that sufficient? :)
Yes ;)
- Thomas
> I have written a function to calculate the julian day from any gregorian day.
> You can include this code in the contrib directory or whatever place seems
> applicable in future releases of posgresql.
Looks nice!
There is already a j2date()/date2j() subroutine pair in the backend, to
support all of the existing date/time arithmetic. Would you be willing
to use calls to that? Then we wouldn't have two sets of code to maintain
(not that JD calculations change very often ;)
It would likely be helpful to have a, say, "julian" argument to
date_part(), which I'd be happy to add in. There is already access to
Julian date using the to_char(date,'J') function call, and you can get a
numeric type return using
cast(to_char(date,'J') as int)
- Thomas
On Thu, 1 Feb 2001, Bruce Momjian wrote:
> Applied.
>
> > On Tue, 30 Jan 2001, Bruce Momjian wrote:
>
> > > > postgresql -> This is a Linux distribution independent (or so I
> > > > hope) init.d/rc.d script that makes use of pg_ctl. There is currently a
> > > > few in ./contrib/linux of the pgsql source tree, but they are RedHat
> > > > specific. This one is simple and self contained. Might be worth adding to
> > > > the other scripts.
> > >
> > > Added to /contrib as init.d.
> >
> > Please replace with the one attached to this email message. The
> > previous version depended on the below patch, this one does not. It is
> > also a bit cleaner and has a few more helpful comments.
Thanks for the quick response. Just as nit-pick the
./contrib/README lists ./contirb/init.d as a starting/stopping script as
for 'non-Linux' systems.... Uh... I meant it as non-distribution specific,
but still probably linux specific. Though it is so general that any unix
system that has bash (might even world under sh, never tested) that uses
init.d style scripts should work. Maybe state it as a 'generic unix
init.d script for starting/stopping pgsql....'? Thanks.
---------------------------------------------------------------------------
| "For to me to live is Christ, and to die is gain." |
| --- Philippians 1:21 (KJV) |
---------------------------------------------------------------------------
| Ryan Kirkpatrick | Boulder, Colorado | http://www.rkirkpat.net/ |
---------------------------------------------------------------------------
New text:
Init.d-style scripts for starting and stopping the PostgreSQL
server by Ryan Kirkpatrick <pgsql@rkirkpat.net
Thanks.
> On Thu, 1 Feb 2001, Bruce Momjian wrote:
>
> > Applied.
> >
> > > On Tue, 30 Jan 2001, Bruce Momjian wrote:
> >
> > > > > postgresql -> This is a Linux distribution independent (or so I
> > > > > hope) init.d/rc.d script that makes use of pg_ctl. There is currently a
> > > > > few in ./contrib/linux of the pgsql source tree, but they are RedHat
> > > > > specific. This one is simple and self contained. Might be worth adding to
> > > > > the other scripts.
> > > >
> > > > Added to /contrib as init.d.
> > >
> > > Please replace with the one attached to this email message. The
> > > previous version depended on the below patch, this one does not. It is
> > > also a bit cleaner and has a few more helpful comments.
>
> Thanks for the quick response. Just as nit-pick the
> ./contrib/README lists ./contirb/init.d as a starting/stopping script as
> for 'non-Linux' systems.... Uh... I meant it as non-distribution specific,
> but still probably linux specific. Though it is so general that any unix
> system that has bash (might even world under sh, never tested) that uses
> init.d style scripts should work. Maybe state it as a 'generic unix
> init.d script for starting/stopping pgsql....'? Thanks.
>
> ---------------------------------------------------------------------------
> | "For to me to live is Christ, and to die is gain." |
> | --- Philippians 1:21 (KJV) |
> ---------------------------------------------------------------------------
> | Ryan Kirkpatrick | Boulder, Colorado | http://www.rkirkpat.net/ |
> ---------------------------------------------------------------------------
>
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
On Fri, 2 Feb 2001, Thomas Lockhart wrote:
> > I have written a function to calculate the julian day from any gregorian day.
> > You can include this code in the contrib directory or whatever place seems
> > applicable in future releases of posgresql.
>
> Looks nice!
>
> There is already a j2date()/date2j() subroutine pair in the backend, to
> support all of the existing date/time arithmetic. Would you be willing
> to use calls to that? Then we wouldn't have two sets of code to maintain
> (not that JD calculations change very often ;)
>
> It would likely be helpful to have a, say, "julian" argument to
> date_part(), which I'd be happy to add in. There is already access to
> Julian date using the to_char(date,'J') function call, and you can get a
> numeric type return using
>
> cast(to_char(date,'J') as int)
... and vice versa:
test=# select to_timestamp('2451946', 'J');
to_timestamp
------------------------
2001-02-05 00:00:00+01
(1 row)
Karel