[ADMIN] pg_database_size() and actual disk space usage

2012-03-29 Thread Alexander Fortin
Hi folks, I'm analyizing why our /var/lib/postgresql partition got a quick bump in usage (from 32GB to 41GB) few days ago, even if, according to data from monitoring software, database size kept increasing with no bump at all. So I'm using "SELECT pg_database_size('mydb')" but I can't find much d

Re: [ADMIN] pg_database_size() and actual disk space usage

2012-03-29 Thread Raghavendra
On Thu, Mar 29, 2012 at 3:06 PM, Alexander Fortin < alexander.for...@gmail.com> wrote: > Hi folks, > > I'm analyizing why our /var/lib/postgresql partition got a quick bump in > usage (from 32GB to 41GB) few days ago, even if, according to data from > monitoring software, database size kept increa

Re: [ADMIN] pg_database_size() and actual disk space usage

2012-03-29 Thread Alexander Fortin
On 3/29/12 11:41 AM, Raghavendra wrote: > Can you also tell what replication is in place ? Sure thing, it's Postgresql 9.1.2, master + two replicas in streaming replication hot standby -- Alexander Fortin http://about.me/alexanderfortin/ -- Sent via pgsql-admin mailing list (pgsql-adm

Re: [ADMIN] pg_database_size() and actual disk space usage

2012-03-29 Thread Bernhard Schrader
On 03/29/2012 12:41 PM, Alexander Fortin wrote: On 3/29/12 11:41 AM, Raghavendra wrote: Can you also tell what replication is in place ? Sure thing, it's Postgresql 9.1.2, master + two replicas in streaming replication hot standby Hi, which filesystem do you use, and which kernel is runnin

Re: [ADMIN] about encoding

2012-03-29 Thread Kevin Grittner
superman0920 wrote: > i want to insert a report to postgresql,the report contain > something Chinese characters and the postgresql is utf-8. > > the response from db is this: > ERROR: invalid byte sequence for encoding "UTF8": 0xb1 That's not a valid byte sequence for a character under the

[ADMIN] custom conflict resolution information request

2012-03-29 Thread amador alvarez
Hi there, I am trying to find any kind of information or examples to deal with custom conflict resolution on swap syncs in a master-master replication. Any clue will be very wellcome, Thanks in advance, Amador A. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make chan