Re: [GENERAL] Replication fell out of sync

2015-03-02 Thread David Kerr
On Mon, Mar 02, 2015 at 04:06:02PM PDT, Adrian Klaver wrote: > On 03/02/2015 03:25 PM, David Kerr wrote: > >Howdy, > > > >I had an instance where a replica fell out of sync with the master. > > > >Now it's in in a state where it's unable to catch up because the master has > >already removed the WA

Re: [GENERAL] Replication fell out of sync

2015-03-02 Thread Adrian Klaver
On 03/02/2015 03:25 PM, David Kerr wrote: Howdy, I had an instance where a replica fell out of sync with the master. Now it's in in a state where it's unable to catch up because the master has already removed the WAL segment. (logs) Mar 2 23:10:13 db13 postgres[11099]: [3-1] user=,db=,host=

Re: [GENERAL] Replication fell out of sync

2015-03-02 Thread David Kerr
On Mon, Mar 02, 2015 at 03:33:22PM PDT, Joshua D. Drake wrote: > > On 03/02/2015 03:25 PM, David Kerr wrote: > > > >Howdy, > > > >I had an instance where a replica fell out of sync with the master. > > > >Now it's in in a state where it's unable to catch up because the master has > >already remov

Re: [GENERAL] Replication fell out of sync

2015-03-02 Thread Joshua D. Drake
On 03/02/2015 03:25 PM, David Kerr wrote: Howdy, I had an instance where a replica fell out of sync with the master. Now it's in in a state where it's unable to catch up because the master has already removed the WAL segment. (logs) Mar 2 23:10:13 db13 postgres[11099]: [3-1] user=,db=,host

[GENERAL] Replication fell out of sync

2015-03-02 Thread David Kerr
Howdy, I had an instance where a replica fell out of sync with the master. Now it's in in a state where it's unable to catch up because the master has already removed the WAL segment. (logs) Mar 2 23:10:13 db13 postgres[11099]: [3-1] user=,db=,host= LOG: streaming replication successfully co

Re: [GENERAL] Application written in pure pgsql, good idea?

2015-03-02 Thread Merlin Moncure
On Sat, Feb 28, 2015 at 2:39 PM, inspector morse wrote: > > Is it a good idea to write a simple application (consisting of just data > entry interfaces) in pure pgsql? > > Basically, we would have each page has a stored function in postgresql that > is called by php+apache (the http get/post value

Re: [GENERAL] The slave suddenly stopped with such DB log : "will not overwrite a used ItemId" and "heap_insert_redo: failed to add tuple"

2015-03-02 Thread Adrian Klaver
On 03/02/2015 02:49 AM, hailong Li wrote: Hi, dear pgsql-general The details are as follows: *1. environment* *DB Master* $ cat /etc/issue CentOS release 6.5 (Final) Kernel \r on an \m $ uname -av Linux l-x1.xx.cnx 3.14.29-3.centos6.x86_64 #1 SMP Tue Jan 20 17:48:32 CST 2015 x86_64 x8

[GENERAL] Find similar records (compare tsvectors)

2015-03-02 Thread Patrick Dung
Hello, I had a database with articles or attachment stored in bytea format.I also had a trigger: it insert/update the tsv column when a record is added/updated.The tsv column had a GIN index.With this setting, I can do very fast keyword search on the tsv. Suppose I had a specific record (id=1000

Re: [GENERAL] Regarding "Point-in-time Recovery" feature

2015-03-02 Thread Ryan King
I have archiving enabled for PITR but it has been causing problems. So I changed the archive_command to ‘cd .’ to disable for now. However, I’m currently looking for a script/process that will rotate the logs every week or so, and also ensure archived wal files don’t pile up. I > On Feb 27, 2015

[GENERAL] The slave suddenly stopped with such DB log : "will not overwrite a used ItemId" and "heap_insert_redo: failed to add tuple"

2015-03-02 Thread hailong Li
Hi, dear pgsql-general The details are as follows: *1. environment* *DB Master* $ cat /etc/issue CentOS release 6.5 (Final) Kernel \r on an \m $ uname -av Linux l-x1.xx.cnx 3.14.29-3.centos6.x86_64 #1 SMP Tue Jan 20 17:48:32 CST 2015 x86_64 x86_64 x86_64 GNU/Linux $ psql -U postgres psql