[GENERAL] receive and transmit streaming replication at same time
Hello List, a lot of recherche and no answer so far. So my question to you: Is it possible to set up ONE PostgreSQL 9 to serve as a streaming replication provider (Master) and receiver (client) at the same time? Can i configure both to * accept 'insert into ...' stream that changes out (usual master) AND * catch streaming from another streaming ? My application: * Two servers acquire measurements at the same time into one table. * No risk of conflicts! * No need of standby skills (for now). Thanks, Bastian -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] SET TIMEZONE doesn't affect to SELECT statement
Title: SET TIMEZONE doesn't affect to SELECT statement Hello; by tutorial I have tried the example: set timezone to 'Europe/London'; select '2008-01-01 12:00:00 GMT+2'::timestamptz; Result: 2008-01-01 15:00:00 set timezone to 'Europe/Moscow'; select '2008-01-01 12:00:00 GMT+2'::timestamptz; Result: 2008-01-01 15:00:00 Why is the result identical ? Is something wrong ? Thanks for suggestion.
[GENERAL] Query for order of tables
Hello;How can I query the pg catalogue to produce a list of tables in order of dependency?Cheers.
[GENERAL] Re: Time Formats
Well I finaly got around to trying the to_char function. And I am having difficulty getting it to do what I want elegantly. Here is the situation... I am tracking the time that an event occurs in a column of type time. (seperate column for date). I want to display the time of the event in a fool proof HH:MM (AM | PM) format. As far as I can tell the to_char() function is not overloaded for the time type just timestamp. How do I format a column of type time to HH:MM AM | PM ? I belive the now() function returns a timestamp. but I need a strict time datatype example. Thanks again Jeff Post University of Wisconsin - Milwaukee