Re: [GENERAL] warnings about invalid "search_path"

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 wrote: > On Tue, Aug 7, 2012 at 7:15 AM, Samba wrote: > > Thanks Gabriele for

Re: [GENERAL] warnings about invalid "search_path"

whichever user logging-in"? Thanks and Regards, Samba --- On Tue, Aug 7, 2012 at 7:50 PM, Albe Laurenz wrote: > Samba wrote: > > I'm seeing some

Re: [GENERAL] warnings about invalid "search_path"

path for a database irrespective of whichever user logs in to the database?" Could you explain how to add "schema(s) into search_path for a database irrespective of the user logging-in? Thanks and Regards, Samba =

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

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 wrote: > Howdy, > > I recen

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

] Regards, Samba On Wed, May 30, 2012 at 12:07 AM, Fujii Masao wrote: > On Wed, May 30, 2012 at 2:38 AM, Michael Nolan wrote: > > > > > > -- Forwarded message -- > > From: Michael Nolan > > D

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

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

hen i will take it up with the JDBC Driver team. Thanks and Regards, Samba = On Tue, May 15, 2012 at 6:46 PM, Merlin Moncure wrote: > On Tue, May 15, 2012 at 1:21 AM, Martijn van Oosterhout > wrote: > > On Tue, May 15, 2012 at 05:38:

[GENERAL] Global Named Prepared Statements

in postgres or not hence 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

test data from > Primary"; > #On BACKUP_SERVER > $SSH "service postgresql stop" > echo "Stopped the backup server in good state; it will get updated in the > next scheduled incremental backup" > else > echo "FAILED to sync backup server with Primary

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

logs which may be growing many times the size of the actual data directory. Thanks and Regards, Samba

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

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 http:/

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

other file? 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

> 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 wrote: > On Thu, Feb 23, 2012 at 2:58 AM, Greg

[GENERAL] Streaming Replication Over SSL

ection to master and fetching the XLOG contents over SSL. I tried 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

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

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] How to restore the table space tar files created by pg_basebackup?

of leaving it to be base.tar.gz file. Thanks and Regards, Samba

Re: [GENERAL] equivalent to "replication_timeout" on standby server

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

uld some one explain me 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

calls that help achieving this? Thanks and Regards, Samba

Re: [GENERAL] Backup Database Question

what about pg_rman ? - On Fri, Oct 7, 2011 at 1:20 AM, Raymond O'Donnell wrote: > On 06/10/2011 20:18, Carlos Mennens wrote: > > O

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

patch. 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 av

[GENERAL] Streaming Replication: Observations, Questions and Comments

ter on account difference in xlog location). Some of the above might be because of wrong configuration, while some 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

give their identity (employer info) but not necessary though. Thanks and Regards, Samba

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

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

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

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[][] := '{{sa

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

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

Re: [GENERAL] Stalled post to pgsql-general

REPOST! On Wed, Dec 1, 2010 at 8:34 PM, wrote: > Your message to pgsql-general has been delayed, and requires the approval > of the moderators, for the following reason(s): > > The author (Samba ) > is not a member of any of the restrict_post groups. > > If you do not w