Lamar Owen wrote:
> This isn't the same environment, Bruce, that you got into back when it was 
> still Postgres95.  We are in the big leagues OS-wise, and we need to act like 
> it.  Assuming that we are a 'userspace' program (which is a misnomer anyway, 
> as _anything_ non-kernel is 'userspace') is not going to cut it anymore.  

So you are saying this isn't my grandma's database anymore.  :-)

Anyway, I think I have _a_ proposal that we can use to work toward a

First, a few conclusions:

        We can't use /var/run because we need the postmaster to create
        those, and it isn't root.

        Right now, the fact that we mix the config stuff with the
        data isn't ideal.  Someone mentioned:

                pg_dumpall > foo && rm -rf $PGDATA && initdb

        discards all the config files.

So, I propose we change a few things.  The good news is that this is
something only administrators deal with;  client apps don't deal with

OK, first, we keep and postmaster.opts in /data.  We
can't put them in /var/run, and /data seems like the best spot for them.

That leaves postgresql.conf, pg_hba.conf, and pg_ident.conf.  I
recommend moving them all, by default, into pgsql/etc.  I recommend we
add these to postgresql.conf:

        data_dir = ../data
        pg_hba_dir = ./
        pg_ident_dir = ./

Those paths are relative to postgresql.conf.

We then add a PGCONFIG variable and postmaster -C flag to point to the
config _directory_.  That way, if folks want to move all of this into
/etc, then easily do that.  This also pulls those files out of /data so
they are easier to back up.

We can also firm up stuff in 7.5 by removing PGDATA and -D, and perhaps
removing the other duplicate postmaster flags that have postgresql.conf

  Bruce Momjian                        |
  [EMAIL PROTECTED]               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Reply via email to