[Pkg-postgresql-private] Replacing cluster_ports by something better

[Martin Pitt]

--cmJC7u66zC7hs+87
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Hi!

Oliver Elphick [2005-01-25  6:24 +0000]:
> > > > Proposal:
> > > > ---------
> > > >=20
> > > > If we support just one cluster per major version, we rely on the
> > > > existence of /etc/postgresql/$MAJOR_VERSION/, in the case of several
> > > > clusters we rely on /etc/postgresql/$CLUSTERNAME/. This directory
> > > > contains all configuration files.
> >=20
> > So this should be modified to:
> >=20
> > For cluster $CLUSTER we rely on the existance of
> > /etc/postgresql/$VERSION/$CLUSTER, which contains the following files:
> >=20
> >  pg_hba.conf, pg_ident.conf postgresql.conf
> >  status
> >  pgdata (symlink to e. g. /var/lib/postgresql/$VERSION/$CLUSTER)
> >=20
> > > > cluster_ports will be dropped entirely; instead, the relevant data
> > > > (STATUS and CLUSTERPATH) is put into a new conffile
> > > > /etc/postgresql/$CLUSTER/status and a symlink
> > > > /etc/postgresql/$CLUSTER/pgdata which points to the actual data
> > > > directory.
> >=20
> > I would still like to do this.
>=20
> OK.  I think that would work.  But policy requires the real files to be
> under /etc and the symlinks in the data directory  (section 10.7.2).

Maybe I expressed myself wrong. The configuration files are linked as
usual (real files in /etc/, symlinks in $PGDATA). However, there is
one symlink "pgdata" in /etc/postgresql/$version/$cluster which points
to the real data directory (like
/var/lib/postgresql/$version/$cluster). All operations are done
through this symlink; this allows to move around the data directory
with just adapting the symlink and nothing else.

Martin

--=20
Martin Pitt                       http://www.piware.de
Ubuntu Developer            http://www.ubuntulinux.org
Debian GNU/Linux Developer       http://www.debian.org

--cmJC7u66zC7hs+87
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFB9hg3DecnbV4Fd/IRAhFcAJ9yB1ZjSgvjSVhOFphpV1IjgNqWaACglobj
HlCTTqugVW6x9UoNWB15lxM=
=WaUN
-----END PGP SIGNATURE-----

--cmJC7u66zC7hs+87--