Search Postgresql Archives

Re: pg_dump, shemas, backup strategy

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

 



> Tom Lane wrote:
>> Please note also that Red Hat has been shipping PG 8.4 for RHEL5 for
>> awhile --- it's the postgresql84-* package set.  I would hope CentOS
>> has copied that by now.
>>
>
> They have, as of CentOS's 5.5 back in May, and I keep forgetting its
> there.  I'm not sure whether I like the trade-offs that come from using
> that packaging in every case yet though.  The dependency issues with
> httpd are particularly weird:
> http://wiki.centos.org/Manuals/ReleaseNotes/CentOS5.5 (last item in
> "Known Issues").  I personally would rather just replace the system
> database with the newer version directly as the PGDG yums do, but you're
> right that some might prefer to use the system one instead.

I went with the upstream postgresql RPMs. They provided a compat package
for CentOS stuff that links against older client libs, so it works out
nicely.

The reason I went with CentOS for server when I first started my project
was because I wanted a system that had long term vendor maintenance and
kept things stable rather than bleeding edge, a system that required
minimal package maintenance on my part. The postgresql yum repo allows
that.

Since PostgreSQL has a 5 year commitment to support, even though it isn't
vendor packaging I can pretty much guarantee that I'll have upgraded the
server before that time limit expires, and even if they don't provide RPMs
for that long, I can maintain the src.rpm for 8.4 series myself if I need
to (which I hope I don't).

The library version was not the issue with my php connection problem,
though building against newer client libs was probably a good idea anyway.
Still looking at it (yes I checked and double checked pg_hba.conf), I'll
figure it out.


-----
Michael A. Peters

http://www.shastaherps.org/

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[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