On Tue, 2008-04-15 at 19:49 +0200, Martin Pitt wrote: 
> Hi,
> 
> Ross Boylan [2008-04-15  9:01 -0700]:
> > I don't see them there for any of the clusters.  It looks as if
> > pg_createcluster moves them to /etc.
> 
> Ah, so that cluster was created with pg_createcluster as well.
> 
> > I did dig the ones under my old /etc up, copy them to /var/lib/...., and
> > pg_createcluster then ran successfully.
> 
> Right. In that case, merely copying both /etc and /var/lib/ would have
> sufficed. 
You mean without running pg_createcluster?  It looked to me as if there
was other setup it was doing. 
> I thought you wanted to integrate an initdb-created cluster.
Since the database was created with pg_createcluster, I guess initdb
ran--but not solo. 
> 
> So, what's the bug here actually?
I had the impression, perhaps wrongly, that pg_createcluster would
integrate a cluster based on the data part of it (i.e., the stuff
under /var/lib) only.  If it's supposed to do that, it's not quite
working.  If it isn't supposed to do that, it might be a useful feature
to add.

Here's the part of the man page I focused on:
"If the data directory already exists, it is integrated into the
postgresql-common structure by moving the configuration file and setting
the data_directory option."
Looking at it now, I guess it means moving the configuration file from
the data directory, but that seems an odd place to expect to find a
configuration file.


In fact, I thought that making your own /etc entries was discouraged,
since "Given a major PostgreSQL version (like "7.4" or "8.0") and a
cluster name, it creates the necessary configuration files
in /etc/postgresql/version/name/; in particular these are
postgresql.conf, pg_ident.conf, pg_hba.conf, a postgresql-common
specific configuration file start.conf ..."
(I don't think start.conf was in the list of files moved, at least in
the code snipped I quoted in an earlier message).

A minimalist approach might be to make the man page a bit clearer about
this.

Ross




-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Reply via email to