Re: [GENERAL] warnings about invalid search_path

2012-08-08 Thread Samba
Thanks Scott, I'll try that out; I hope this would solve my problem... Regards, Samba On Tue, Aug 7, 2012 at 8:30 PM, Scott Marlowe scott.marl...@gmail.comwrote: On Tue, Aug 7, 2012 at 7:15 AM, Samba saas...@gmail.com wrote

Re: [GENERAL] warnings about invalid search_path

2012-08-07 Thread Samba
schema(s) into search_path for a database irrespective of the user logging-in? Thanks and Regards, Samba === On Tue, Aug 7, 2012 at 4:53 PM, Gabriele Bartolini gabriele.bartol...@2ndquadrant.it wrote: Hi Samba

Re: [GENERAL] warnings about invalid search_path

2012-08-07 Thread Samba
logging-in? Thanks and Regards, Samba --- On Tue, Aug 7, 2012 at 7:50 PM, Albe Laurenz laurenz.a...@wien.gv.atwrote: Samba wrote: I'm seeing some weired errors

Re: [GENERAL] select current_setting('transaction_isolation')

2012-06-02 Thread Samba
and is ensuring that the every query run on the database is actually running under that particular transaction isolation level. Regards, Samba On Wed, May 30, 2012 at 5:35 AM, David Kerr d...@mr-paradox.net wrote: Howdy, I recently did

Re: [GENERAL] Disable Streaming Replication without restarting either master or slave

2012-06-01 Thread Samba
] Regards, Samba On Wed, May 30, 2012 at 12:07 AM, Fujii Masao masao.fu...@gmail.com wrote: On Wed, May 30, 2012 at 2:38 AM, Michael Nolan htf...@gmail.com wrote: -- Forwarded message -- From: Michael Nolan htf

[GENERAL] Disable Streaming Replication without restarting either master or slave

2012-05-29 Thread Samba
the application becomes usable, it would be great if there is a way we can disable replication [for maintenance reasons like applying patches or upgrades, etc]. Thanks and Regards, Samba

Re: [GENERAL] Global Named Prepared Statements

2012-05-21 Thread Samba
will take it up with the JDBC Driver team. Thanks and Regards, Samba = On Tue, May 15, 2012 at 6:46 PM, Merlin Moncure mmonc...@gmail.com wrote: On Tue, May 15, 2012 at 1:21 AM, Martijn van Oosterhout klep...@svana.org wrote: On Tue, May 15

[GENERAL] Global Named Prepared Statements

2012-05-14 Thread Samba
posting it to general mailing list; if folks feel that it ought to go to hackers list, then please guide me so. Thanks and Regards, Samba http://bugs.mysql.com/bug.php?id=38732

Re: [GENERAL] Issue with rsync based incremental backup : postgres: startup process waiting for 0000000100000001000000D2

2012-05-09 Thread Samba
backup server with Primary; echo Leaving the backup server running in the failed state for further debugging exit 1; fi; exit 0; I hope this would help others in need... Thanks and Regards, Samba

[GENERAL] Issue with rsync based incremental backup : postgres: startup process waiting for 0000000100000001000000D2

2012-05-03 Thread Samba
of the actual data directory. Thanks and Regards, Samba

Re: [GENERAL] Indexing MS/Open Office and PDF documents

2012-03-15 Thread Samba
Word documents can be processed by Abiword into any msword document into html, latex, postscript, text formats with very simple commands; i guess it also exposes some api which can be integrated into document parsers/indexers. Spreadsheets can be processed by utilizing *ExcelFormat *library

Re: [GENERAL] Call for Google Summer of Code (GSoC) 2012: Project ideas?

2012-03-13 Thread Samba
? will it not eliminate this dilemma about the boundaries of compression? perhaps a periodic auto vacuum like compressor daemon can take up the job of recompression to have the compression-hints updated as per the latest data present in the file/page at that instant. Regards, Samba

Re: [GENERAL] Measuring replication lag time

2012-02-24 Thread Samba
Comparing pg_controldata output on prod and standby might help you with this. We do use this approach and it is pretty reliable and gives time lag up to the granularity of checkpoint_timeout. On Thu, Feb 23, 2012 at 11:51 AM, Stuart Bishop stu...@stuartbishop.netwrote: On Thu, Feb 23,

Re: [GENERAL] How to restore the table space tar files created by pg_basebackup?

2011-12-01 Thread Samba
Hi Venkat, I verified that the tablespaces are located in actual directories and not any symbolic links. Another interesting thing is that the content in these additional tar.gz files is already present in the base.tar.gz file. Regards, Samba

[GENERAL] Streaming Replication Over SSL

2011-12-01 Thread Samba
intercepting the traffic using wireshark but could not find any hint to that effect; all it says is that the traffic is over tcp. Can someone suggest any way to confirm that this setting would really make streaming replication work of SSL? Thanks and Regards, Samba

[GENERAL] How to restore the table space tar files created by pg_basebackup?

2011-11-30 Thread Samba
it to be base.tar.gz file. Thanks and Regards, Samba

Re: [GENERAL] equivalent to replication_timeout on standby server

2011-11-04 Thread Samba
prolonged disconnect. It would be better if either master or slave or both the servers makes periodic checks to find if the other is reachable and resume the replication( if possible, or else log the message that a full sync may be required). Thanks and Regards, Samba

[GENERAL] equivalent to replication_timeout on standby server

2011-11-02 Thread Samba
if this is possible with postgres-9.1.1? Thanks and Regards, Samba

[GENERAL] Disable Streaming Replication == Stop WAL Sender on master and WAL receiver on Slave

2011-11-01 Thread Samba
that help achieving this? Thanks and Regards, Samba

Re: [GENERAL] Backup Database Question

2011-10-06 Thread Samba
what about pg_rman http://code.google.com/p/pg-rman? - On Fri, Oct 7, 2011 at 1:20 AM, Raymond O'Donnell r...@iol.ie wrote: On 06/10/2011 20:18, Carlos Mennens

Re: [GENERAL] Streaming Replication: Observations, Questions and Comments

2011-08-25 Thread Samba
. I hope my suggestion will be received in good spirit. Thanks and Regards, Samba PS: I have wrongly stated that master server had to be restarted in case of long disconnects, sorry that was not true. But I still feel that requiring restart of standby server to resume replication should be avoided

[GENERAL] Streaming Replication: Observations, Questions and Comments

2011-08-24 Thread Samba
may be give hints for future enhancements. I hope this will start a healthy discussion on the areas where streaming replication needs to be improved and strengthened. Thanks and Regards, Samba

[GENERAL] Statistics about Streaming Replication deployments in production

2011-07-28 Thread Samba
their identity (employer info) but not necessary though. Thanks and Regards, Samba

Re: [GENERAL] [REPOST] plpgsql : looping over multidimensional array : getting NULL for subdimension

2010-12-02 Thread Samba
Thank you Merlin for your answer, I tried that and is working as you said. But when I do other_array=some_array[1:2]; I'm getting the entire '{{samba,sarath,sreenivas},{samba,mukhesh,pavan}}'; not just the second subarray, i.e. '{{samba,mukhesh

Re: [GENERAL] Stalled post to pgsql-general

2010-12-01 Thread Samba
REPOST! On Wed, Dec 1, 2010 at 8:34 PM, pgsql-general-ow...@postgresql.org wrote: Your message to pgsql-general has been delayed, and requires the approval of the moderators, for the following reason(s): The author (Samba saas...@gmail.com) is not a member of any of the restrict_post

[GENERAL] [REPOST] plpgsql : looping over multidimensional array : getting NULL for subdimension

2010-12-01 Thread Samba
Hi all, I'm trying to loop over a multidimensional array and find if any of the elements in a sub-dimensional array are matching some known criteria but facing issue with NULL for the sub arrays. I have a data structure that looks like: *some_array VARCHAR[][] := '{{samba,sarath,sreenivas

[GENERAL] plpgsql : looping over multidimensional array : getting NULL for subdimension

2010-12-01 Thread Samba
Hi all, I'm trying to loop over a multidimensional array and find if any of the elements in a sub-dimensional array are matching some known criteria but facing issue with NULL for the sub arrays. I have a data structure that looks like: *some_array VARCHAR[][] := '{{samba,sarath