On Tuesday 11 December 2001 10:05 am, Thomas Lockhart wrote:
> > Isn't it easier to just use symlinks?
> Maybe. Sometimes. In some cases. But even in those cases, easier is not
> always better.
> We've had "the symlink discussion" from time to time in the past. Some
> folks are very comfortable with symlinks as part of the PostgreSQL
> design model. But I'm *very* uncomfortable with symlinks in that role.
I most assuredly agree with Thomas and Mark on this issue. While some are
very comfortable with symlinks in this role, I for one am not. I would like
postgresql.conf to not live in PGDATA. I would like postgresql.conf to not
get overwritten if I have to re-initdb. I would, in fact, like to be able to
put several postgresql.conf's, named differently, too, in /etc/pgsql for
consistency with things such as BIND, xinetd, sendmail, and virtually any
other reasonable daemon.
Suppose I host three databases on one box. One database is for a client
named varitor, one is for ramifordistat, and one is for wgcr. I would love
to have a /etc/pgsql with the three files varitor.conf, ramifordistat.conf,
and wgcr.conf. Each config file would be able to specify the datadir (just
like a webserver's config file specifies a pageroot, or BIND's named.conf
specifies its datadir), as well as other unique config data such as IP
address and/or port to bind to. Then, postmaster could be started on these
three config files with, perhaps, 'postmaster
--config-file=/etc/pgsql/wgcr.conf' and postmaster loads, with the right
configuration, without specifying a datadir.
To me, this is the natural way to do things. Further, it is easily scripted,
as well as easily packaged. And the vast majority of other daemons do it
this way.
And allowing this way is not the same thing as trying to prevent it from
being the existing way -- they can coexist.
I just think, Peter, that you're being a mite rigid on this one.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11