Hi All, Is there any way to automate the archive deletion process. Any script or command in HA setup using pgpool
Thanks in advance Best Regards, *Rajni Baliyan | Database - Consultant* *ASHNIK PTE. LTD.*101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533 M : +65 83858518 T: +65 6438 3504 | www.ashnik.com www.facebook.com/ashnikbiz | www.twitter.com/ashnikbiz [image: email patch] This email may contain confidential, privileged or copyright material and is solely for the use of the intended recipient(s). On Fri, Jan 31, 2014 at 11:22 AM, Bruce Momjian <br...@momjian.us> wrote: > On Fri, Jul 26, 2013 at 06:28:05PM -0400, Tom Lane wrote: > > Our documentation appears not to disclose this fine point, but a look > > at the SQL-MED standard says it's operating per spec. The standard also > > says that ADD is an error if the option is already defined, which is a > > bit more defensible, but still not exactly what I'd call user-friendly. > > And the error we issue for that case is pretty misleading too: > > > > regression=# ALTER SERVER cuda_db10 OPTIONS (use_remote_estimate 'true') > ; > > ALTER SERVER > > regression=# ALTER SERVER cuda_db10 OPTIONS (use_remote_estimate > 'false') ; > > ERROR: option "use_remote_estimate" provided more than once > > > > I think we could do with both more documentation, and better error > > messages for these cases. In the SET-where-you-should-use-ADD case, > > perhaps > > > > ERROR: option "use_remote_estimate" has not been set > > HINT: Use ADD not SET to define an option that wasn't already set. > > > > In the ADD-where-you-should-use-SET case, perhaps > > > > ERROR: option "use_remote_estimate" is already set > > HINT: Use SET not ADD to change an option's value. > > > > The "provided more than once" wording would be appropriate if the same > > option is specified more than once in the command text, but I'm not sure > > that it's worth the trouble to detect that case. > > Where are on this? > > -- > Bruce Momjian <br...@momjian.us> http://momjian.us > EnterpriseDB http://enterprisedb.com > > + Everyone has their own god. + > > > -- > Sent via pgsql-general mailing list (pgsql-gene...@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
<<image002.jpg>>
