Re: [ADMIN] How do i compare 2 postgresql instanses ?

2008-07-08 Thread Michael Nacos
Hello there. Simple counts can certainly prove two databases are not the same version. But what if you actually want to look at the data? I have been thinking about row checksums, would you say this would be a reasonable way of verifying two databases are equivalent? I have many other things on my

Re: [ADMIN] How do i compare 2 postgresql instanses ?

2008-07-08 Thread Michael Nacos
Thanks Kevin... I am working on something different right now but I'll soon have to give it a go, one way or the other... Michael On Tue, Jul 8, 2008 at 3:28 PM, Kevin Grittner <[EMAIL PROTECTED]> wrote: > > Our home-grown replication technique does synchronization checks > during idle time. It

[ADMIN] pgBee - a Postgresql Bulk Updater in Java

2008-09-16 Thread Michael Nacos
"pgBee is a set of Java classes I wrote for automating bulk updates of Postgresql databases on Linux servers. It requires Java (doh!) and Ant (as a build/execute front-end), it is cronnable and performs very well, especially in multi-threaded mode, which takes full advantage of multi-core CPUs in m

[ADMIN] load-testing postgresql servers with Tsung

2008-12-05 Thread Michael Nacos
Hi postgresql admins! I have just finished writing a Tsung tutorial on load-testing Postgresql servers (assessing their load-capacity). Please have a look at the following posts: http://freeyourtech.wordpress.com/2008/07/11/load-testing-a-postgresql-server-with-tsung/ http://freeyourtech.wordpre