[GENERAL] out-of-order XID insertion in KnownAssignedXids

ld be helpful. Thank you for your support, Fredrik

Re: [GENERAL] out-of-order XID insertion in KnownAssignedXids

o recover, since we have been focused on how to avoid the situation altogether I am not certain which xlog file it is having difficulties with? Best regards, Fredrik On October 18, 2016 at 8:49:29 pm +02:00, Andres Freund wrote: > Hi, > > On 2016-10-18 14:57:52 +0200, wrote: >

Re: [GENERAL] out-of-order XID insertion in KnownAssignedXids

scenarios, where one of them is a fairly old RHEL installation. We also have centos versions that are much more updated. Best regards, and thank you all again, Fredrik On 20 October 2016 at 22:38:26 +02:00, Andres Freund wrote: > On 2016-10-20 22:37:15 +0900, Michael Paquier wrote: > &g

[GENERAL] "missing chunk number XX for toast value YY in pg_toast ..." after pg_basebackup.

Hi All, we are running postgresql 9.1.15 on Debian. we are, basically, running a postgresql cluster with two nodes. We are using synchronous streaming replication to make sure that the slave is always fully in sync (using a recovery.conf that points out the master). The slave is mainly used to

[GENERAL] Re: "missing chunk number XX for toast value YY in pg_toast ..." after pg_basebackup.

HI All, i would really appreciate any help I can get on this issue. basically, a pg_basebackup + streaming attach, led to a database that we could not read from afterwards. Beset regards, Fredrik PS please advise if this is better posted on another list.

Re: [GENERAL] Re: "missing chunk number XX for toast value YY in pg_toast ..." after pg_basebackup.

DBNAME LOG: could not receive data from client: Connection reset by peer 2016-02-22 02:37:41 GMT 2648 DBNAME LOG: unexpected EOF on client connection Best regards, Fredrik Huitfeldt On 7 March 2016 16:35:29 +01:00, Adrian Klaver wrote: > On 03/06/2016 10:18 PM, wrote: > > > HI All, &

Re: [GENERAL] Re: "missing chunk number XX for toast value YY in pg_toast ..." after pg_basebackup.

s because stats collector is not responding 2016-02-22 02:13:52 GMT 30908 LOG: using stale statistics instead of current ones because stats collector is not responding There are lots of these mesages within the timeframe. There seems to be a couple of them every 2-4 hours. > > > >

Re: [GENERAL] Re: "missing chunk number XX for toast value YY in pg_toast ..." after pg_basebackup.

of > > current ones because stats collector is not responding > > 2016-02-22 02:13:52 GMT 30908 LOG: using stale statistics instead of > > current ones because stats collector is not responding > > > > There are lots of these mesages within the timeframe. There seems

[GENERAL] Streaming replication, master recycling

database corruption: <http://hlinnaka.iki.fi/presentations/NordicPGDay2015-pg_rewind.pdf> I am mainly seeking understanding of if and why this approach is a bad idea. Thanks, Fredrik Huitfeldt

Re: [GENERAL] Streaming replication, master recycling

er the headline: "Naive approach". thank you for your support, Fredrik On 11 May 2016 at 12:47:13 +02:00, Venkata Balaji N wrote: > > > On Wed, May 11, 2016 at 2:31 PM, <> wrote: > > > Hi All, > > > > we are currently using streaming replication on

[GENERAL] out-of-order XID insertion in KnownAssignedXids (on 9.5.3)

be helpful. Thank you for your support, Fredrik

[GENERAL] Database connections seemingly hanging

, Fredrik

Re: [GENERAL] Database connections seemingly hanging

4 netstat -p on 10.216.73.204: http://pastebin.com/tPz8gwRG Kind regards, Fredrik & friends Tom Lane 2013/01/10 05:30 To fredrik.huitfeldtmad...@schneider-electric.com cc pgsql-general@postgresql.org, pgpool-gene...@pgpool.net Subject Re: [GENERAL] Database connections seemingly hanging f

Re: [pgpool-general: 1315] Re: [GENERAL] Database connections seemingly hanging

would aid you in providing us with this kind of feedback? Kind regards, Fredrik & Friends Tatsuo Ishii 2013/01/16 07:54 To fredrik.huitfeldtmad...@schneider-electric.com cc t...@sss.pgh.pa.us, nag...@sraoss.co.jp, pgsql-general@postgresql.org, pgpool-gene...@pgpool.net Subject Re: [pg

[GENERAL] What will happen to PostgreSQL server (on Linux) if CMOS battery dies?

all in these conditions. Best regards, Fredrik Israelsson _ Beställ bläck före 19 för leverans nästa vardag http://www.inkclub.com/msn8

[GENERAL] PostgreSQL on system with root as only user

Hi! I am about to install PostgreSQL on a minimal Linux system, where root is the only user that is allowed to exist. I would prefer to use a binary installer. Is it possible to install PostgreSQL without the postgres user? /Fredrik ---(end of broadcast

Re: [GENERAL] PostgreSQL on system with root as only user

Well, no actual "design decision" is made yet. Just testing... ...actually, in embedded, minimalistic environments, I don't think it's unusual to have one and only one user. /Fredrik -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: den 30 a

[GENERAL] Storing a chain

vant examples, documentation or advice on how to solve this. -- Johan Fredrik Øhman ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

[GENERAL] Storing a chain

vant examples, documentation or advice on how to solve this. -- Johan Fredrik Øhman ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match