Martin, I would like to run my history by you. I was using postgresql-7.4 before I switched to ubuntu (I am a refugee from RedHat). After I upgraded my workstation to the latest and greatest from ubuntu and installed the postgresql client, I got messages that the version 8 client does not work right with the version 7 server. So when the data drive on my postgresql-7.4 server died, it seemed like an ideal time to set up a new postgresql-8 server and migrate the data over (yes, I was fully backed up, and you have to migrate the data anyway when you upgrade postgresql).
As of Wednesday, my new postgresql-8 server is now working. (My almost three week gap with no working database server was mostly the fault of factors other than less than ideal installation instructions.) > > So it seems the installation instructions one can > > easily find don't work > > Well, they do work. I disagree. If you follow the instructions on the postgresql.org site, the server cannot start. I had to figure out from error messages to find server.crt, server.key and root.crt, and that I had to copy them to the data directory, etc. For my money, the instructions on postgresql.org site do not work on an install from the ubuntu 6.06 server CD. You are assuming that one must set up a new cluster, but (according to the pg_createcluster man page), "The default cluster that is created on installation of a server package is main." I want to use main -- I do not want to set up a different cluster (such as "testing" and the other examples on the man page do not register for me). I am not aware of any problem with using main (other than there are no working installation instructions). My new postgresql-8 server is using main and it seems to be working OK. So if there is no problem with using the main cluster, there should be installation instructions for doing that. That would be the simple server installation. Setting up additional clusters is a more advanced installation, and those instructions could be separate from the simple install. > So far I deliberately don't put the initdb > programs into the > $PATH, but pg_* tools are in the path. Would it have > helped you if > there was an initdb in the path which told you about > the distro tools? The postgresql.org instructions put the full path on initdb, so I do not think that putting pg_* tools in the path will be a clue to most administrators. (Because the postgresql.org instructions put the full path on initdb, it never occurred to me to examine what was in the path.) Perhaps the objective should be make the postgresql.org instructions work using the main cluster without having to figure out how to get the server started. I think the vast majority of administrators will know to ignore the part about compiling the source, but I think the rest of the instructions here should work: http://www.postgresql.org/docs/8.0/interactive/installation.html What do you think? Thanks, Rick --- Martin Pitt <[EMAIL PROTECTED]> wrote: > Hi Rick, > > Rick Graves [2007-11-01 21:28 -0000]: > > So it seems the installation instructions one can > > easily find don't work > > Well, they do work. If you stay on upstream's path, > then things will > work, but then of course you cannot expect the > distro integration bits > to work (like automatic startup in the init scripts, > upgrading, > logging into the proper places, default > configuration for log > rotation, etc.). > > > Should I file another bug on inadequate > installation > > instructions? > > You can do, or we just retitle this one (which is > preferable, I > think). > > > It seems adequate instructions are lacking, and if > > that is the case, I would be willing to pitch in > and > > write better ones if arrangements could be made to > get > > the instructions in front of people actually when > they > > install postgresql on ubuntu and/or Debian. > > I'd be absolutely happy to improve this. The > question is, where to do > it? So far I deliberately don't put the initdb > programs into the > $PATH, but pg_* tools are in the path. Would it have > helped you if > there was an initdb in the path which told you about > the distro tools? > > We could also patch the upstream initdb itself to > point out > pg_createcluster maybe. > > Pitti > > -- > no warning about decoy conf files > https://bugs.launchpad.net/bugs/138793 > You received this bug notification because you are a > direct subscriber > of the bug. > -- no warning about decoy conf files https://bugs.launchpad.net/bugs/138793 You received this bug notification because you are a member of Ubuntu Bugs, which is the bug contact for Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
