[ADMIN] Segmentation fault ( after Shared Lock acquired, same table 4 times )

2012-04-02 Thread Jan Mussler
Dear all, yesterday evening we ran into some trouble on one of our databases running PostgreSQL 9.0.4, AMD Opteron Setup, ECC Memory, SAN Storage. This database has performed very well for month without any troubles with fsync on, full page writes on and streaming to our replica slaves. Then yes

Re: [ADMIN] about encoding

2012-04-02 Thread Steve Crawford
On 03/28/2012 08:00 PM, superman0920 wrote: > hello > 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 > how can i fix it ? > Remove the bad

Re: [ADMIN] Warnings in Standby Logs

2012-04-02 Thread masterchief
I see. Is there a more elegant way that I could shut down my standby server so that it would be in a more clean state? For example, when I first built the standby and began replication, I didn't get either of those record length messages. -- View this message in context: http://postgresql.10456

Re: [ADMIN] custom conflict resolution information request

2012-04-02 Thread Kevin Grittner
amador alvarez wrote: > 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. What are you using for replication? -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make cha

Re: [ADMIN] custom conflict resolution information request

2012-04-02 Thread amador alvarez
What are you using for replication? -Kevin Hi Kevin, I set up a master-master asynchronous replication of one database with bucardo 4.4.5 and testing right now 4.99.3. I know the standard settings when a conflict between same id rows comes up : source - the rows on the "source" database alw