[GENERAL] Hot standby problems: consistent state not reached, no connection to master server.

2015-04-12 Thread Ilya Ashchepkov
Hello. I'm setting up hot standby slave. It recovers from wal archive files, but I can't connect to it: $ psql psql: FATAL: the database system is starting up On master: # select name,setting from pg_settings where name like 'wal_level'; name| setting ---+- wal_leve

[GENERAL] Re: Hot standby problems: consistent state not reached, no connection to master server.

2015-04-12 Thread Ilya Ashchepkov
On Sun, 12 Apr 2015 08:10:48 -0700 Adrian Klaver wrote: > On 04/12/2015 07:47 AM, Ilya Ashchepkov wrote: > > Hello. > > > > I'm setting up hot standby slave. > > It recovers from wal archive files, but I can't connect to it: > > $ psql > >

[GENERAL] Re: Hot standby problems: consistent state not reached, no connection to master server.

2015-04-13 Thread Ilya Ashchepkov
On Sun, 12 Apr 2015 17:30:44 -0700 Adrian Klaver wrote: > On 04/12/2015 08:25 AM, Ilya Ashchepkov wrote: > > On Sun, 12 Apr 2015 08:10:48 -0700 > > Adrian Klaver wrote: > > > >> On 04/12/2015 07:47 AM, Ilya Ashchepkov wrote: > >>> Hello. > >>

[GENERAL] Re: Hot standby problems: consistent state not reached, no connection to master server.

2015-04-13 Thread Ilya Ashchepkov
On Mon, 13 Apr 2015 10:06:05 -0700 Adrian Klaver wrote: > On 04/13/2015 09:42 AM, Ilya Ashchepkov wrote: > > On Sun, 12 Apr 2015 17:30:44 -0700 > > Adrian Klaver wrote: > > > > >>>> > >>> > >>> Oh! I missed this! Thank you! >

[GENERAL] Re: Hot standby problems: consistent state not reached, no connection to master server.

2015-04-13 Thread Ilya Ashchepkov
On Mon, 13 Apr 2015 12:24:11 -0700 Adrian Klaver wrote: > On 04/13/2015 11:25 AM, Ilya Ashchepkov wrote: > > On Mon, 13 Apr 2015 10:06:05 -0700 > > Adrian Klaver wrote: > > > >> On 04/13/2015 09:42 AM, Ilya Ashchepkov wrote: > >>> On Sun, 12 Apr 2015

[GENERAL] Re: Hot standby problems: consistent state not reached, no connection to master server.

2015-04-14 Thread Ilya Ashchepkov
On Mon, 13 Apr 2015 22:05:40 +0200 Guillaume Lelarge wrote: Thank you! > Le 12 avr. 2015 16:50, "Ilya Ashchepkov" a écrit : > > > > Hello. > > > > I'm setting up hot standby slave. > > It recovers from wal archive files, but I can't con

[GENERAL] Re: Hot standby problems: consistent state not reached, no connection to master server.

2015-04-14 Thread Ilya Ashchepkov
On Tue, 14 Apr 2015 07:08:50 -0700 Adrian Klaver wrote: > On 04/13/2015 01:05 PM, Guillaume Lelarge wrote: > > Le 12 avr. 2015 16:50, "Ilya Ashchepkov" > <mailto:koc...@gmail.com>> a écrit : > > > > > > > restore_command = '/usr/li

[GENERAL] Re: Hot standby problems: consistent state not reached, no connection to master server.

2015-04-14 Thread Ilya Ashchepkov
On Tue, 14 Apr 2015 10:34:29 + Sameer Kumar wrote: Problem solved, thanks for attention. > On Tue, 14 Apr 2015 11:59 Ilya Ashchepkov wrote: > > On Mon, 13 Apr 2015 12:24:11 -0700 > Adrian Klaver wrote: > > > On 04/13/2015 11:25 AM, Ilya Ashchepkov wrote: > >

Re: [GENERAL] Function runtime increases after 5 calls in the same session.

2014-10-21 Thread Ilya Ashchepkov
Marti Raudsepp Wrote in message: > Hi > > On Tue, Oct 21, 2014 at 12:53 PM, Ilya I. Ashchepkov wrote: >> I wrote a function and during testing it I came across the strange >> behaviour. >> Function runtime is about 200ms first 5 times, 6th and futher calls takes >> ~22000 ms. >> I simplified my

Re: [GENERAL] Function runtime increases after 5 calls in the same session.

2014-10-22 Thread Ilya Ashchepkov
Tom Lane Wrote in message: > Marti Raudsepp writes: >> On Tue, Oct 21, 2014 at 12:53 PM, Ilya I. Ashchepkov >> wrote: >>> I wrote a function and during testing it I came across the strange >>> behaviour. >>> Function runtime is about 200ms first 5 times, 6th and futher calls takes >>> ~22000 ms

[GENERAL] justify_interval: days in year

2014-11-10 Thread Ilya Ashchepkov
Hello! Is this correct? $ select justify_interval(t-f-i) ,t-f-i from ( select timestamp '2014-1-1' as f, timestamp '2015-1-1' as t, interval '06:49:00' as i ) S; justify_interval| ?column? + 1 year 4 days 17:1

Re: [GENERAL] justify_interval: days in year

2014-11-10 Thread Ilya Ashchepkov
On Mon, 10 Nov 2014 14:14:15 +0100 Francisco Olarte wrote: > On Mon, Nov 10, 2014 at 10:07 AM, Ilya Ashchepkov > wrote: > > > Is this correct? > > $ select > > justify_interval(t-f-i) > > ,t-f-i > > from > > ( > > select > >

Re: [GENERAL] PG94RC1- plv8 functions - problem with input parameter length

2014-12-01 Thread Ilya Ashchepkov
On Fri, 28 Nov 2014 16:56:01 +0100 Misa Simic wrote: > Hi all, Hello, on Debian Sid and all works fine. postgresql-9.4: Installed: 9.4~rc1-1.pgdg+1 from http://apt.postgresql.org/ plv8js from https://code.google.com/p/plv8js/ > > We have found a strange problem with plv8 functions in PG94RC1