Re: pg_dump, shemas, backup strategy

> Michael A. Peters wrote:
>> I already maintain my own php RPMs because RHEL php is too old (I need
>> the DOMDocument stuff) so maybe I need to add Postgresql to that.
>>
>
> Note that you don't even have to build them yourself; the set at
> https://public.commandprompt.com/projects/pgcore/wiki/ are a
> straightforward drop-in replacement for the ones that RedHat provides.
> Subscribe to that yum repo just for the postgresql* packages and you can
> easily run 8.3 or 8.4 instead of the system 8.1. You might need to
> recompile your custom PHP against that afterwards, but you shouldn't
> have to build the database itself completely from source. And you'll
> still get security updates and bug fix point upgrades from that yum
> repo, continuing after the ones for 8.1 slow down.

It looks like I might need to.
I did the transition on my test machine and everything seems to be working
well from the shell except it won't connect from php.

I'm going out for week so I'll mess with it when I get back. Could be
something else trivial too.

-----
Michael A. Peters

http://www.shastaherps.org/