Re: [ADMIN] Best Replication Tool

Hi, probably pgpool-II is worth trying. A new version has been released two days ago http://pgfoundry.org/projects/pgpool hth ..:GERD:.. On Monday 08 February 2010 23:38:54 Rosser Schwarz wrote: > On Sun, Feb 7, 2010 at 8:22 PM, Kiswono Prayogo wrote: > > Hi, i'm really new to postgresql

[ADMIN] upgrade via rpm

Hello, we're planning an upgrade from Postgres 8.3.1 to latest 8.3.5 via rpm (Opensuse 10.3 - 64bit). Is it really that simple ? 1.) stop cluster (e.g. pg_ctl stop) 2.) perform the upgrade (rpm -Uvh *.rpm) 3.) start the cluster (pg_ctl start) thanks in advanceGERD. -- Sent via pgsql

Re: [ADMIN] ]To estimate the size of db

Hi Duan, perhaps you can go the way via some system functions like: ## list tables and their size SELECTrelname AS table_name, pg_size_pretty(pg_relation_size(oid)) AS table_sz, pg_size_pretty(pg_total_relation_size(oid)) AS total_sz FROM pg_c