Grzegorz Jaśkiewicz wrote:
On Wed, Mar 11, 2009 at 3:03 PM, Joshua D. Drake <jd@xxxxxxxxxxxxxxxxx> wrote:
Any chance of something like this being done in the future?
I am going to go out on a limb here and say, "no".
That would probably be possible, by placing all indicies in a separate
directory in data, but....
I could simply use the system catalog to determine which files to backup
and which to ignore. I suppose I would prefer to backup all unique
indexes, and perhaps all system indexes. It's the proliferation of
large indexes that serve only to enhance select performance that I would
want to ignore.
So like JD said, if you don't want to dump indicies - just use pg_dump...
If pg_dump were an acceptable backup tool, we wouldn't need PITR, would
we? We used pg_dump for years. There's a very good reason we no longer
do. That suggestion is silly.
-Glen
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
