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]