This is a heads up about some changes I'm considering for the PostgreSQL
7.0 RPMS. If the RPMs do not interest you, or you are not involved in
supporting PostgreSQL in the RPM form, then feel free to hit delete.

I wanted to get feedback from the group before I made any changes -- 7.0
is
slated to go beta Feb 15, and I plan on having RPM's available within a
few hours of the official beta release.  I already have feedback from my
contact at RedHat -- and it is complete agreement with the changes I am
proposing.

First, 7.0 has changed many small things about the operation of the
system, including a new procedural language (plperl), a reorganized
regression test suite, and a new 'pg_ctl' command to start and stop the
postmaster.

As a result, I will be having to make some minor changes; and there is
one major change I want to make.

1.)	I want to move the actual database directory from /var/lib/pgsql to
/var/lib/pgsql/data -- this will give the ability to store backups and
other scratch data in /var/lib/pgsql without disturbing the main
database, in an FHS-compliant manner (the current regression tests AND
upgrade scripts are not in compliance with the FHS in terms of their
packaging, unfortunately -- I want to rectify this). This of course will
require sufficient documentation -- and I will provide functionality to
use an existing data structure in /var/lib/pgsql instead, until the user
moves it (new installations will default the initdb to
/var/lib/pgsql/data).

2.)	I will be enabling logs and logrotate functionality in the next
release.

3.)	/etc/rc.d/init.d/postgresql will be rewritten to use the pg_ctl
command, instead of doing the start/stop manually.

4.)	The new plperl language will go in postgresql-perl.

5.)	I am considering splitting out pgaccess and the tk client from
postgresql-tcl to postgresql-tk -- I have had several requests from
users of servers that are using the tcl client and the pltcl language
who do not have X11 installed, a current requirement for the
installation of postgresql-tcl.

6.)	And, of course, an update to version 7.0. This will involve
extensive testing for Alpha, Sparc, and MIPS support -- I am hoping that
Ryan Kirkpatrick and Uncle George can get the Alpha patches in order for
7.0, as I don't believe Tom had time to do the fmgr rewrite like he
wanted. I am also hoping that a number of people with MIPS, ARM, Alpha,
and Sparc (both 32 and 64) will volunteer to beta test 7.0.

The initial builds will be done for Intel only -- until I get patches
and/or confirmation of build on other architectures from those who are
able to test those.

If you have additional suggestions for improving the RPM distribution,
please e-mail them to me.

TIA for your feedback.

--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

Mon, 07 Feb 2000 12:12:22 -0500
Lamar Owen <lamar.owen@wgcr.org>
PostgreSQL 7 RPMs coming soon
Lamar,

I got report from bulgarian user who had problem with locale under
MANDRAKE caused by 'su -l postgres ...' I'll forward it to you.
Incorrectly configured i18n (LC_ALL) could  override (?) locale
settings even if LC_CTYPE, LC_COLLATE explicitly specified in
startup script. I think you could check if all locale environment
are consistent with each other.

	Oleg
On Mon, 7 Feb 2000, Lamar Owen wrote:

> Date: Mon, 07 Feb 2000 12:12:22 -0500
> From: Lamar Owen <lamar.owen@wgcr.org>
> To: pgsql-hackers@postgreSQL.org
> Subject: [HACKERS] PostgreSQL 7 RPMs coming soon
> 
> This is a heads up about some changes I'm considering for the PostgreSQL
> 7.0 RPMS. If the RPMs do not interest you, or you are not involved in
> supporting PostgreSQL in the RPM form, then feel free to hit delete.
> 
> I wanted to get feedback from the group before I made any changes -- 7.0
> is
> slated to go beta Feb 15, and I plan on having RPM's available within a
> few hours of the official beta release.  I already have feedback from my
> contact at RedHat -- and it is complete agreement with the changes I am
> proposing.
> 
> First, 7.0 has changed many small things about the operation of the
> system, including a new procedural language (plperl), a reorganized
> regression test suite, and a new 'pg_ctl' command to start and stop the
> postmaster.
> 
> As a result, I will be having to make some minor changes; and there is
> one major change I want to make.
> 
> 1.)	I want to move the actual database directory from /var/lib/pgsql to
> /var/lib/pgsql/data -- this will give the ability to store backups and
> other scratch data in /var/lib/pgsql without disturbing the main
> database, in an FHS-compliant manner (the current regression tests AND
> upgrade scripts are not in compliance with the FHS in terms of their
> packaging, unfortunately -- I want to rectify this). This of course will
> require sufficient documentation -- and I will provide functionality to
> use an existing data structure in /var/lib/pgsql instead, until the user
> moves it (new installations will default the initdb to
> /var/lib/pgsql/data).
> 
> 2.)	I will be enabling logs and logrotate functionality in the next
> release.
> 
> 3.)	/etc/rc.d/init.d/postgresql will be rewritten to use the pg_ctl
> command, instead of doing the start/stop manually.
> 
> 4.)	The new plperl language will go in postgresql-perl.
> 
> 5.)	I am considering splitting out pgaccess and the tk client from
> postgresql-tcl to postgresql-tk -- I have had several requests from
> users of servers that are using the tcl client and the pltcl language
> who do not have X11 installed, a current requirement for the
> installation of postgresql-tcl.
> 
> 6.)	And, of course, an update to version 7.0. This will involve
> extensive testing for Alpha, Sparc, and MIPS support -- I am hoping that
> Ryan Kirkpatrick and Uncle George can get the Alpha patches in order for
> 7.0, as I don't believe Tom had time to do the fmgr rewrite like he
> wanted. I am also hoping that a number of people with MIPS, ARM, Alpha,
> and Sparc (both 32 and 64) will volunteer to beta test 7.0.
> 
> The initial builds will be done for Intel only -- until I get patches
> and/or confirmation of build on other architectures from those who are
> able to test those.
> 
> If you have additional suggestions for improving the RPM distribution,
> please e-mail them to me.
> 
> TIA for your feedback.
> 
> --
> Lamar Owen
> WGCR Internet Radio
> 1 Peter 4:11
> 
> ************
> 

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83


Mon, 7 Feb 2000 22:12:31 +0300 (GMT)
Oleg Bartunov <oleg@sai.msu.su>
Re: [HACKERS] PostgreSQL 7 RPMs coming soon
On 2000-02-07, Lamar Owen mentioned:

> 1.)	I want to move the actual database directory from /var/lib/pgsql to
> /var/lib/pgsql/data -- this will give the ability to store backups and
> other scratch data in /var/lib/pgsql without disturbing the main
> database, in an FHS-compliant manner (the current regression tests AND
> upgrade scripts are not in compliance with the FHS in terms of their
> packaging, unfortunately -- I want to rectify this). This of course will
> require sufficient documentation -- and I will provide functionality to
> use an existing data structure in /var/lib/pgsql instead, until the user
> moves it (new installations will default the initdb to
> /var/lib/pgsql/data).

What exactly is FHS and what do they say? I am vaguely phantasizing about
doing a little work on the build process for the next release; is that
something that could be addressed?


-- 
Peter Eisentraut                  Sernanders vï¿½g 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden


Tue, 8 Feb 2000 00:09:07 +0100 (CET)
Peter Eisentraut <peter_e@gmx.net>
Re: [HACKERS] PostgreSQL 7 RPMs coming soon
Peter Eisentraut wrote:
> > database, in an FHS-compliant manner (the current regression tests AND
> > upgrade scripts are not in compliance with the FHS in terms of their
[snip]
 
> What exactly is FHS and what do they say? I am vaguely phantasizing about
> doing a little work on the build process for the next release; is that
> something that could be addressed?

FHS 2.0 is the Filesystem Hierarchy Standard, successor to the Linux
FileSystem Standard (FSSTND).  You may find the full document at
http://www.pathname.com/fhs/

Currently, in order to get PostgreSQL into RPM form requires a number of
mungifications -- the current prefix parameter is set to /usr, which
puts binaries and shared libs in the right place -- but everything else
is moved into place manually.  It is a rather kludgy build script (ask
Thomas, he knows).  To look at the build script (in RPM parlance, a
'spec file'), load up
http://www.ramifordistat.net/postgres/unpacked/non-beta/postgresql-6.5.3-3.spec 
(one line; it'll probably wrap on your e-mail client).

--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

Mon, 07 Feb 2000 18:15:28 -0500
Lamar Owen <lamar.owen@wgcr.org>
Re: [HACKERS] PostgreSQL 7 RPMs coming soon
Yes, this seems very much like the stuff I've been thinking about. I'll
bring it up when the next devel cycle has started.

On Mon, 7 Feb 2000, Lamar Owen wrote:

> Peter Eisentraut wrote:
> > > database, in an FHS-compliant manner (the current regression tests AND
> > > upgrade scripts are not in compliance with the FHS in terms of their
> [snip]
>  
> > What exactly is FHS and what do they say? I am vaguely phantasizing about
> > doing a little work on the build process for the next release; is that
> > something that could be addressed?
> 
> FHS 2.0 is the Filesystem Hierarchy Standard, successor to the Linux
> FileSystem Standard (FSSTND).  You may find the full document at
> http://www.pathname.com/fhs/
> 
> Currently, in order to get PostgreSQL into RPM form requires a number of
> mungifications -- the current prefix parameter is set to /usr, which
> puts binaries and shared libs in the right place -- but everything else
> is moved into place manually.  It is a rather kludgy build script (ask
> Thomas, he knows).  To look at the build script (in RPM parlance, a
> 'spec file'), load up
> http://www.ramifordistat.net/postgres/unpacked/non-beta/postgresql-6.5.3-3.spec 
> (one line; it'll probably wrap on your e-mail client).
> 
> --
> Lamar Owen
> WGCR Internet Radio
> 1 Peter 4:11
> 
> 

-- 
Peter Eisentraut                  Sernanders vaeg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden


Tue, 8 Feb 2000 12:32:23 +0100 (MET)
Peter Eisentraut <e99re41@DoCS.UU.SE>
Re: [HACKERS] PostgreSQL 7 RPMs coming soon