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

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 cent

[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 acc

[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 acc

[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

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

I've read the chapter you quoted before 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:

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

ing to the locale on the client 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-

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

[GENERAL] how to specify the locale that psql uses

ot; 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

Re: [GENERAL] postgresql's MVCC implementation

SQL. I've read http://www.postgresql.org/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

Re: [GENERAL] postgresql's MVCC implementation

as if they were when the transaction started. 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.

[GENERAL] postgresql's MVCC implementation

l. Any idea? Thanks 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-tp18302020p1830

[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 this

[GENERAL] what could be blocking an insertion?

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-be

[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!