[GENERAL] do the files in pg_xlog differ in master and slave?

is it? If the pg_xlog files are copied, would it cause the timeline xx of the primary does not match recovery target timeline yy error? Why? Thanks! -- Kent Tong IT author and consultant, child educator

Re: [GENERAL] shared data for different applications

Hi Alban, Thanks a lot for your useful info! I think most companies have ended up at that point just by the progress of time. They have several different databases (often from different vendors even) that they need to aggregate their information from. So, is this the result of lack of

[GENERAL] shared data for different applications

Hi, Let's say that there is some data that should be logically shared by many applications in the company, such as some core information about its customers (name, address, contact info). In principle, such data should be stored in a DB for sharing. But then if a certain application needs to

[GENERAL] shared data for different applications

Hi, Let's say that there is some data that should be logically shared by many applications in the company, such as some core information about its customers (name, address, contact info). In principle, such data should be stored in a DB for sharing. But then if a certain application needs to

[GENERAL] changing the locale of the DB cluster

Hi, I know that it is impossible to change the locale. But can I pg_dump all the databases, run initdb again using the desired locale, and then pg_restore? - -- Kent Tong Wicket tutorials freely available at http://www.agileskills2.org/EWDW Axis2 tutorials freely available at http

[GENERAL] how to specify the locale that psql uses

but it doesn't seem to work on the Windows port of PostgreSQL. Thanks for any help! - -- Kent Tong Wicket tutorials freely available at http://www.agileskills2.org/EWDW Axis2 tutorials freely available at http://www.agileskills2.org/DWSAA -- View this message in context: http://www.nabble.com/how

Re: [GENERAL] how to specify the locale that psql uses

Reg Me Please wrote: psql --help ? which option you're referring to? I tried --locale but it had no effect. - -- Kent Tong Wicket tutorials freely available at http://www.agileskills2.org/EWDW Axis2 tutorials freely available at http://www.agileskills2.org/DWSAA -- View

Re: [GENERAL] how to specify the locale that psql uses

that determines the text prompts it outputs. - -- Kent Tong Wicket tutorials freely available at http://www.agileskills2.org/EWDW Axis2 tutorials freely available at http://www.agileskills2.org/DWSAA -- View this message in context: http://www.nabble.com/how-to-specify-the-locale-that-psql-uses

Re: [GENERAL] how to specify the locale that psql uses

posting for help and it didn't apply to the issue. - -- Kent Tong Wicket tutorials freely available at http://www.agileskills2.org/EWDW Axis2 tutorials freely available at http://www.agileskills2.org/DWSAA -- View this message in context: http://www.nabble.com/how-to-specify-the-locale

[GENERAL] postgresql's MVCC implementation

in advance! - -- Kent Tong Wicket tutorials freely available at http://www.agileskills2.org/EWDW Axis2 tutorials freely available at http://www.agileskills2.org/DWSAA -- View this message in context: http://www.nabble.com/postgresql%27s-MVCC-implementation-tp18302020p18302020.html Sent from

Re: [GENERAL] postgresql's MVCC implementation

. If it is the case, why? Is MVCC not well defined? Could say Oracle or MS SQL implement it differently? - -- Kent Tong Wicket tutorials freely available at http://www.agileskills2.org/EWDW Axis2 tutorials freely available at http://www.agileskills2.org/DWSAA -- View this message in context: http

Re: [GENERAL] postgresql's MVCC implementation

/docs/8.3/interactive/transaction-iso.html and wondering if there is any more detailed description. Thanks! - -- Kent Tong Wicket tutorials freely available at http://www.agileskills2.org/EWDW Axis2 tutorials freely available at http://www.agileskills2.org/DWSAA -- View this message in context

[GENERAL] logging of transaction related events

Hi, Is it possible to log events related to transactions, in particular, about blocking? For example: INFO: transaction 123 is blocked waiting for locked held by transaction 456. Thanks! - -- Kent Tong Wicket tutorials freely available at http://www.agileskills2.org/EWDW -- View

[GENERAL] what could be blocking an insertion?

with the serializable isolation level. A day or so later the problem was gone. Any idea? I need to prevent it from happening again. Thanks! - -- Kent Tong Wicket tutorials freely available at http://www.agileskills2.org/EWDW -- View this message in context: http://www.nabble.com/what-could

[GENERAL] time out in blocking

to get this time out effect? Thanks in advance! -- Kent Tong, M.Sc., MCSE, MCP+I FREE advice to enhance your business with IT FREE catalogue of IT products in the Macau market Go to http://www.cpttm.org.mo/itob NOW!