Search Postgresql Archives

Re: Easy upgrade on Cpanel *without* downtime

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 8/26/08, Phoenix Kiula <phoenix.kiula@xxxxxxxxx> wrote:
> On 8/26/08, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote:
>  >
>  >  Slony replication lets postgresql accomplish this, which is really
>  >  quite impressive.  We just upgraded from an 8.1 server to an 8.3
>  >  server via slony, and it went smooth as silk.  db downtime was
>  >  measured in seconds.
>
>
>
>
> Thanks for this Scott. Sounds promising. But where can I find the
>  instructions to install Slony, then install new PG 8.3.3, then start
>  it with similar CONF settings and stuff, then setup the master and
>  slave (which I am not familiar with), and then switch master and slave
>  when everything is working?
>
>  To others who keep telling us that "PG is complex and if you want it
>  to be less so then contribute" -- well, sorry I am not that technical.
>  If the intended target audience of PG is only super-techsavvy folk who
>  can write C++ patches for every little functionality they need, then
>  perhaps I chose the wrong DB? I doubt it.
>
>  It would be really nice if the PG official community can have some
>  simple instructions to make a seamless upgrade, if no simpler patches
>  exist. At the very least the instructions will help us plentiful folk
>  who do NOT use PG in the exalted "enterprise" setting, but to run busy
>  websites. This is how MySQL became big too, by being convenient and
>  reliable (until recently anyway), but I see no point in that
>  discussion.
>
>  Anyhow, it would be really nice to have simple instructions. Searching
>  on Google for words like "Slony Postgresql upgrade" or "install slony
>  with postgresql 8.3" returns stuff that makes a lot of presumptions!
>
>  I have a CentOS 4 with Cpanel/WHM running. PG is in the usual place:
>
>   > whereis pgsql
>  pgsql: /usr/lib/pgsql /usr/include/pgsql /usr/share/pgsq
>
>  Now how can I install Slony so that it install PGSQL and allows me to
>  continue working with Apache/PHP for my website? I am reading this --
>  http://slony.info/documentation/installation.html -- but while it
>  textually mentions the stuff in the writeup, I don't see full
>  instructions to install Slony, then new PGSQL, then switching, and so
>  on.
>
>  So many thanks for any help anyone can provide! Or point me to some
>  resource that exists but is hiding from Google.
>



See, this is where I get confused. I want to upgrade from 8.2.3 to
8.3.3. The recommendation is to try Slony. So I download Slony and try
to configure it. The configure command gives me this:


----
checking for correct version of PostgreSQL... "error"
configure: error: Your version of PostgreSQL (8.2) is lower
	    than the required 8.3.  Slony-I needs functionality included in
	    a newer  version.
----


Well, if Slony needs a newer version, then how can it be used to upgrade?!


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux