[GENERAL] Hot standby 9.2.1 PANIC: WAL contains references to invalid pages

2014-04-18 Thread Vishalakshi Navaneethakrishnan
Hi Team, For last 2 days we are facing issue with replication. WARNING: page 21 of relation base/1193555/19384612 does not exist CONTEXT: xlog redo insert: rel 1663/1193555/19384612; tid 21/1 PANIC: WAL contains references to invalid pages CONTEXT: xlog redo insert: rel 1663/1193555/19384612;

Re: [GENERAL] Arduino SQL Connector

2014-04-18 Thread Tomas Vondra
Steve, please stop top-posting, especially if others bottom-post. It turns the messages a hard to follow mess. I took the liberty to reshuffle the parts a bit. On 18 Duben 2014, 6:09, Steve Spence wrote: > > On Fri, Apr 18, 2014 at 12:02 AM, Jan Wieck wrote: >> On 04/17/14 20:01, Steve Spence wro

Re: [GENERAL] Arduino SQL Connector

2014-04-18 Thread David Rysdam
Steve Spence writes: > Need a Team lead on this, and I'll collaborate as much as I can on the > Arduino / Networking side. I don't understand why there is so much blowback to the idea that you can just use the existing code. Why exactly wouldn't it work? It compiles on that architecture already.

Re: [GENERAL] Arduino SQL Connector

2014-04-18 Thread David Rysdam
Steve Spence writes: > The Arduino is very good at compiling includes written in C/C++. just > need a .h and .ccp file with the correct syntax, but very compact. It > used to be part of the fun making programs fit in 4-16k back in the > day. And what happened when you tried the suggestions you go

Re: [GENERAL] Arduino SQL Connector

2014-04-18 Thread David Rysdam
Steve Spence writes: > It's actually quite freeing, not complicating. I can put the values > right into the fields I need them to be in (or get values from the > database I need to control the Arduino), without going through a > intermediate process. If you have a serial process I can look at that

Re: [GENERAL] Cluster recovery - FATAL: database files are incompatible with server. Different PG_CONTROL_VERSION for cluster and server.

2014-04-18 Thread Guillaume Drolet
Thanks for the doc on pg_resetxlog. Will try it next week when I'm back from Easter holiday, first backuping $PGDATA. Most of my databases are stored in a default tablespace I defined on a different disk than that of my PG installation (and $PGDATA): could I just reinstall PG and then re-link it w

Re: [GENERAL] Cluster recovery - FATAL: database files are incompatible with server. Different PG_CONTROL_VERSION for cluster and server.

2014-04-18 Thread Guillaume Drolet
No the new test cluster isn't running anymore: I deleted it right after I deleted my main one. Re the error messages: I was calling pg_ctl with the option -D 2014-04-18 8:44 GMT-04:00 droletguillaume : > > > > Sent from Samsung Mobile > > > Original message > From: Adrian Klave

[GENERAL] Could use some advice on search architecture

2014-04-18 Thread Ron Pasch
Hello, I'm contemplating what architecture I should use to make searching as fast as possible given the information available and the search requirements. Let me give some background first; - The database contains products of can potentially have a lot of them (up to about 3 to 5 million) -

Re: [GENERAL] Cluster recovery - FATAL: database files are incompatible with server. Different PG_CONTROL_VERSION for cluster and server.

2014-04-18 Thread Adrian Klaver
On 04/18/2014 06:25 AM, Guillaume Drolet wrote: Thanks for the doc on pg_resetxlog. Will try it next week when I'm back from Easter holiday, first backuping $PGDATA. Most of my databases are stored in a default tablespace I defined on a different disk than that of my PG installation (and $PGDATA

Re: [GENERAL] Arduino SQL Connector

2014-04-18 Thread Jan Wieck
On 04/18/14 10:31, Steve Spence wrote: Not a thing in that document about the Arduino. Just how to install Postgres on a Raspberry Pi. My Postgres is on a hosted server at a ISP. You intend to have thousands of Arduino devices, incapable of doing any sort of encryption or other means of secure

Re: [GENERAL] Arduino SQL Connector

2014-04-18 Thread Adrian Klaver
On 04/18/2014 07:53 AM, Jan Wieck wrote: On 04/18/14 10:31, Steve Spence wrote: Not a thing in that document about the Arduino. Just how to install Postgres on a Raspberry Pi. My Postgres is on a hosted server at a ISP. You intend to have thousands of Arduino devices, incapable of doing any so

Re: [GENERAL] Could use some advice on search architecture

2014-04-18 Thread Susan Cassidy
First, I would not restrict color to 30 colors, if anything like furniture or clothing, etc. is involved. Colors are very important to consumers, and exact colors are important. I would re-think my color selections. Make sure you have indexes on all the appropriate columns, of course. Susan O

Re: [GENERAL] Arduino SQL Connector

2014-04-18 Thread Tomas Vondra
On 18 Duben 2014, 18:11, Edson Richter wrote: > Is Arduino capable of running Java apps? > If so, you can use the excellent high quality PgSQL JDBC driver. > Java interfacing with native libraries is not difficult, JNI are pretty > well know and documented (and long lived already). > > Just my 2c (

Re: [GENERAL] Arduino SQL Connector

2014-04-18 Thread Tomas Vondra
On 18 Duben 2014, 17:01, Adrian Klaver wrote: > On 04/18/2014 07:53 AM, Jan Wieck wrote: >> On 04/18/14 10:31, Steve Spence wrote: >>> Not a thing in that document about the Arduino. Just how to install >>> Postgres on a Raspberry Pi. My Postgres is on a hosted server at a ISP. >> >> You intend to

Re: [GENERAL] Re: any way for a transaction to "see" inserts done earlier in the transaction?

2014-04-18 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Vincent Veyron wrote: > I suppose you use DBD::Pg, whose current default isolation > transaction level is ``Serializable'' Just to set the record straight for the archives, DBD::Pg makes no changes at all to the isolation level. The only wa

Re: [GENERAL] Could use some advice on search architecture

2014-04-18 Thread Andy Colson
On 4/18/2014 8:59 AM, Ron Pasch wrote: Hello, I'm contemplating what architecture I should use to make searching as fast as possible given the information available and the search requirements. Let me give some background first; - The database contains products of can potentially have a lot of

Re: [GENERAL] pg_upgrade & tablespaces

2014-04-18 Thread Bruce Momjian
On Thu, Apr 17, 2014 at 02:45:59PM -0400, Joseph Kregloh wrote: > > This will be fixed in the next 9.3 minor release by throwing ane error > for non-existent tablespace directories. > > > > Awesome! I have already upgraded my dev, stage, preprod, and production > environments to 9.3. Ho