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 rebuild the src.rpm from Fedora, which I th

Re: [GENERAL] pg_dump, shemas, backup strategy

2010-07-25 Thread Devrim GÜNDÜZ
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. -- Devrim GÜNDÜZ PostgreSQL DBA @ Akinon/Markafoni, Red Hat Certified Enginee

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

Re: [GENERAL] pg_dump, shemas, backup strategy

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

Re: [GENERAL] pg_dump, shemas, backup strategy

2010-07-24 Thread Greg Smith
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 trad

Re: [GENERAL] pg_dump, shemas, backup strategy

2010-07-24 Thread Tom Lane
Greg Smith writes: > 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 th

Re: [GENERAL] pg_dump, shemas, backup strategy

2010-07-24 Thread Greg Smith
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 st

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 problem

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 i

Re: [GENERAL] pg_dump, shemas, backup strategy

2010-07-24 Thread Greg Smith
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 will run in

Re: [GENERAL] pg_dump, shemas, backup strategy

2010-07-24 Thread Alban Hertroys
On 24 Jul 2010, at 24:20, Michael A. Peters wrote: > I've been using MySQL for years. I switched (er, mostly) to PostgreSQL > recently because I need to use PostGIS. It is all working now for the most > part, and PostGIS is absolutely wonderful. Welcome, I hope you like it here :) > I run CentOS

[GENERAL] pg_dump, shemas, backup strategy

2010-07-23 Thread Michael A. Peters
I've been using MySQL for years. I switched (er, mostly) to PostgreSQL recently because I need to use PostGIS. It is all working now for the most part, and PostGIS is absolutely wonderful. I run CentOS 5.x and I do not like to upgrade vendor supplied packages. My version of pg_dump is from postgre