[GENERAL] CentOS 6 - www.pgrpms.org - SELinux

2011-09-02 Thread Michael A. Peters
I'm setting up a new server for a CMS I have written (er, partially, needs work) that uses PostgreSQL as a backend. All my existing CentOS 5 servers, I use pgrpms for PostgreSQL. I would like to do the same with CentOS 6 but I also want to keep SELinux enabled on this box. Do the RPM's in

Re: [GENERAL] MySQL versus Postgres

2010-08-09 Thread Michael A. Peters
that, so unless I really want to pay the big bucks, it's better for me to do it myself and cheat sheets really help. - Michael A. Peters http://www.shastaherps.org/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Data dumps to files - best methods?

2010-07-26 Thread Michael A. Peters
stuff I don't need in a relational database, I can just import the xml into DOMDocument and operate on it that way. You can probably use the libxml2 facilities of your favorite scripting language (php,perl,python,ruby) to dump the database into whatever kind of XML they want. - Michael

Re: [GENERAL] pg_dump, shemas, backup strategy

2010-07-25 Thread Michael A. Peters
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

Re: [GENERAL] pg_dump, shemas, backup strategy

2010-07-25 Thread Michael A. Peters
25.Tem.2010 tarihinde 00:23 saatinde, Michael A. Peters mpet...@shastaherps.org şunları yazdı: OK. I already maintain my own php RPMs because RHEL php is too old (I need the DOMDocument stuff) IIRC, Centosplus repo has already Dom stuff. I basically just rebuild the src.rpm from

Re: [GENERAL] pg_dump, shemas, backup strategy

2010-07-24 Thread Michael A. Peters
On 24 Jul 2010, at 24:20, Michael A. Peters wrote: *snip* Schema's in Postgres are similar to different databases in MySQL. They allow you to organise your tables in groups of tables belonging to similar functionality, for example. They have their own permissions too, which is nice if you

Re: [GENERAL] pg_dump, shemas, backup strategy

2010-07-24 Thread Michael A. Peters
Michael A. Peters wrote: I run CentOS 5.x and I do not like to upgrade vendor supplied packages. My version of pg_dump is from postgresql-8.1.21-1.el5_5.1 - I'm assuming the 8.1.21 is the important part. That's a bad policy with PostgreSQL. I guarantee you that the problems you

Re: [GENERAL] pg_dump, shemas, backup strategy

2010-07-24 Thread Michael A. Peters
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

Re: [GENERAL] pg_dump, shemas, backup strategy

2010-07-24 Thread Michael A. Peters
The library version was not the issue with my php connection problem I needed to grant connect. I guess that must be new? Anyway I knew it was likely something simple. - Michael A. Peters http://www.shastaherps.org/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

[GENERAL] pg_dump, shemas, backup strategy

2010-07-23 Thread Michael A. Peters
. - Michael A. Peters http://www.shastaherps.org/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general