[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 pg

[GENERAL] pg_dump, shemas, backup strategy

2010-07-23 Thread Michael A. Peters
ping out a n00b. ----- 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

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 permissio

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

Re: [GENERAL] pg_dump, shemas, backup strategy

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

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-g

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.com

Re: [GENERAL] pg_dump, shemas, backup strategy

2010-07-25 Thread Michael A. Peters
> 25.Tem.2010 tarihinde 00:23 saatinde, "Michael A. Peters" > > ş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 reb

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

2010-07-26 Thread Michael A. Peters
format. I use it for some 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 th

Re: [GENERAL] MySQL versus Postgres

2010-08-09 Thread Michael A. Peters
en I have used stuff created by them, very frequently their code is clearly crap and insecure and even I can see 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