Re: [HACKERS] Broken hint bits (freeze)

2017-06-23 Thread Sergey Burladyan
Sergey Burladyan <eshkin...@gmail.com> writes: > 1. create master > 2. create standby from it > 3. create unlogged table and hash index like: > create unlogged table test (id int primary key, v text); > create index on test using hash (id); > 3. stop master > 4. prom

Re: [HACKERS] Broken hint bits (freeze)

2017-06-23 Thread Sergey Burladyan
for relation "public.test_id_idx" ("s/9.2/base/16384/16393" to "m/9.4/base/16422/16393"): No such file or directory Failure, exiting I touch this file (s/9.2/base/16384/16393) and rerun pg_upgrade from scratch and it complete successfully. -- Sergey Burladyan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Broken hint bits (freeze)

2017-06-20 Thread Sergey Burladyan
Bruce Momjian <br...@momjian.us> writes: > On Tue, Jun 20, 2017 at 06:42:58PM +0300, Sergey Burladyan wrote: > > If file at standby in old data directory is different from same file at > > master, but it have same size, it will be hardlinked into new data > > di

Re: [HACKERS] Broken hint bits (freeze)

2017-06-20 Thread Sergey Burladyan
in/pg_xlog/ | awk '/4ED0A00AE/,/xxx/ { print }' | wc -l 2456 === See https://www.postgresql.org/docs/9.2/static/wal-configuration.html > they are recycled (renamed to become the next segments in the numbered > sequence) -- Sergey Burladyan -- Sent via pgsql-hackers mailin

Re: [HACKERS] Broken hint bits (freeze)

2017-06-20 Thread Sergey Burladyan
Bruce Momjian <br...@momjian.us> writes: > On Tue, Jun 20, 2017 at 01:10:26PM +0300, Sergey Burladyan wrote: > > Bruce Momjian <br...@momjian.us> writes: > > > > Uh, as I understand it the rsync is going to copy the missing WAL file > > > > from the

Re: [HACKERS] Broken hint bits (freeze)

2017-06-20 Thread Sergey Burladyan
Amit Kapila <amit.kapil...@gmail.com> writes: > On Tue, Jun 20, 2017 at 3:40 PM, Sergey Burladyan <eshkin...@gmail.com> wrote: > > Bruce Momjian <br...@momjian.us> writes: > > > >> On Mon, Jun 19, 2017 at 10:59:19PM -0400, Bruce Momjian wrote: >

Re: [HACKERS] Broken hint bits (freeze)

2017-06-20 Thread Sergey Burladyan
Bruce Momjian <br...@momjian.us> writes: > On Mon, Jun 19, 2017 at 10:59:19PM -0400, Bruce Momjian wrote: > > On Tue, Jun 20, 2017 at 03:50:29AM +0300, Sergey Burladyan wrote: > > > 20 июн. 2017 г. 1:21 пользователь "Bruce Momjian" <br...@momjian.us> &g

Re: [HACKERS] Broken hint bits (freeze)

2017-06-19 Thread Sergey Burladyan
20 июн. 2017 г. 1:21 пользователь "Bruce Momjian" написал: We are saying that Log-Shipping should match "Latest checkpoint location", but the WAL for that will not be sent to the standby, so it will not match, but that is OK since the only thing in the non-shipped WAL file is

Re: [HACKERS] Broken hint bits (freeze)

2017-06-16 Thread Sergey Burladyan
Bruce Momjian <br...@momjian.us> writes: > On Fri, Jun 16, 2017 at 04:33:16AM +0300, Sergey Burladyan wrote: > > Bruce Momjian <br...@momjian.us> writes: > > > ! > > > ! Also, if upgrading standby servers, change wal_level > > &g

Re: [HACKERS] Broken hint bits (freeze)

2017-06-16 Thread Sergey Burladyan
Bruce Momjian <br...@momjian.us> writes: > On Fri, Jun 16, 2017 at 08:10:13PM +0530, Amit Kapila wrote: > > On Fri, Jun 16, 2017 at 7:03 AM, Sergey Burladyan <eshkin...@gmail.com> > > wrote: > > > Bruce Momjian <br...@momjian.us> writes: > > >

Re: [HACKERS] Broken hint bits (freeze)

2017-06-15 Thread Sergey Burladyan
he master server 2017-06-16 01:22:14 GMT HINT: Either set wal_level to "replica" on the master, or turn off hot_standby here. 2017-06-16 01:22:14 GMT LOG: startup process (PID 27916) exited with exit code 1 = PS: Thank you for answer, Bruce! -- Sergey Burladyan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Broken hint bits (freeze)

2017-06-07 Thread Sergey Burladyan
Vladimir Borodin <r...@simply.name> writes: > > 6 июня 2017 г., в 23:30, Sergey Burladyan <eshkin...@gmail.com> написал(а): > > > > Dmitriy Sarafannikov <dsarafanni...@yandex.ru> writes: > > > >> Starting and stopping master after running pg_u

Re: [HACKERS] Broken hint bits (freeze)

2017-06-06 Thread Sergey Burladyan
gresql.org/docs/9.6/static/pgupgrade.html > f. Start and stop the new master cluster > In the new master cluster, change wal_level to replica in the postgresql.conf > file and then start and stop the cluster. and there is no any suggestion to disable autovacuum for it. -- Sergey Burlad

[HACKERS] Questions about upgrade standby with rsync

2017-06-02 Thread Sergey Burladyan
017-06-01 16:09:32 MSK ReadRecord: record with zero len at 0/1280 This WAL file is only at master pg_xlog, and not in WAL archive. And my second question, this algorithm with rsync described only starting from pg 9.5, is it possible to use it for upgrade from pg 9.2 to pg 9.4? Thanks! --

[HACKERS] pg_upgrade and epoch

2014-04-22 Thread Sergey Burladyan
://lists.pgfoundry.org/pipermail/skytools-users/2014-April/001812.html -- Sergey Burladyan

Re: [HACKERS] pg_upgrade and epoch

2014-04-22 Thread Sergey Burladyan
/postgresql/9.3/bin -k /usr/lib/postgresql/9.3/bin/postgres -D d9.3 -p 5433 -k`pwd`/s psql -At -h localhost -p 5433 -c 'select txid_current()' postgres 756 34359739064 switched to 756 after upgrade -- Sergey Burladyan

Re: [HACKERS] [BUGS] BUG #9223: plperlu result memory leak

2014-03-15 Thread Sergey Burladyan
to repo. -- Sergey Burladyan

Re: [HACKERS] [BUGS] BUG #9223: plperlu result memory leak

2014-02-26 Thread Sergey Burladyan
Alex Hunsaker bada...@gmail.com writes: On Tue, Feb 25, 2014 at 6:56 AM, Sergey Burladyan eshkin...@gmail.com wrote: It looks like I found the problem, Perl use reference count and something that is called Mortal for memory management. As I understand it, mortal is free after

Re: [HACKERS] [BUGS] BUG #9223: plperlu result memory leak

2014-02-25 Thread Sergey Burladyan
Hello, All! eshkin...@gmail.com writes: create function perl_test(IN data text, OUT v1 text, OUT v2 integer, OUT v3 integer, OUT v4 json, OUT v5 json) returns record as $BODY$ use strict; use warnings; my $res-{'v1'} = 'content'; return $res; $BODY$ language plperlu volatile

Re: [HACKERS] Draft release notes for 9.3.2

2013-12-02 Thread Sergey Burladyan
! Is it possible to fix my surname in changelog? -Sergey Burladyn +Sergey Burladyan it is not a problem if it is impossible :-) Thanks! -- Sergey Burladyan

Re: [HACKERS] Recovery target 'immediate'

2013-04-21 Thread Sergey Burladyan
into pg_xlog and remove recovery.conf. It seems that we're missing a setting, something like recovery_target = 'immediate', which would mean stop as soon as consistency is reached. Or am I missing some trick? This will be helpful :) -- Sergey Burladyan

Re: [HACKERS] Patch for BUG #6480, psql incorrect indent for inherited tables names with UTF-8 NLS

2012-02-25 Thread Sergey Burladyan
Alvaro Herrera alvhe...@commandprompt.com writes: I'm sorry, but the releases are already tagged :-( So they will contain the buggy output for a while yet. Ah, I see, ok, wait next! :) -- Sergey Burladyan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

[HACKERS] Patch for BUG #6480, psql incorrect indent for inherited tables names with UTF-8 NLS

2012-02-24 Thread Sergey Burladyan
will be with Russian translation again (thank you, Alexander!) and this tiny bug is slightly annoying. From aaa828e05691ca58067d74cea43dabe8863ccdf7 Mon Sep 17 00:00:00 2001 From: Sergey Burladyan eshkin...@gmail.com Date: Thu, 23 Feb 2012 04:09:10 +0400 Subject: [PATCH] Fix NLS text width and pg_wcswidth

[HACKERS] FreeBSD 8.0 i386, plpythonu, threaded Python not supported on this platform

2010-10-13 Thread Sergey Burladyan
whether Python is compiled with thread support... yes configure: error: threaded Python not supported on this platform --8---cut here---end---8--- Where can I find a description of this problem? Is any chance to fix it? -- Sergey Burladyan -- Sent via pgsql

[HACKERS] UTF8 regexp and char classes still does not work

2010-09-28 Thread Sergey Burladyan
and it call pg_wc_isalpha like this: for (i = 0; i = UCHAR_MAX; i++) { if (pg_wc_isalpha((chr) i)) addchr(cv, (chr) i); } UCHAR_MAX is 255 I do not understand fully this algorithm of regular expressions, but i think cclass function also need fix. -- Sergey Burladyan -- Sent via pgsql

Re: [HACKERS] UTF8 regexp and char classes still does not work

2010-09-28 Thread Sergey Burladyan
| f| t -- Sergey Burladyan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] git.postgresql.org vs. REL8_1_STABLE

2009-11-13 Thread Sergey Burladyan
'TIDBitmap' ../../../../src/include/nodes/execnodes.h:959: error: expected specifier-qualifier-list before 'TIDBitmap' make[4]: *** [indexvalid.o] Error 1 postgresql-8.1.18.tar.bz2 from www.postgresql.org/ compiled successful. -- Sergey Burladyan -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] 8.4, One-Time Filter and subquery ( ... FROM function() union all ... )

2009-07-07 Thread Sergey Burladyan
..0.011 rows=0 loops=1) One-Time Filter: false Total runtime: 0.179 ms (3 rows) Thank you, Tom ! -- Sergey Burladyan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] 8.4, One-Time Filter and subquery ( ... FROM function() union all ... )

2009-07-07 Thread Sergey Burladyan
--- Seq Scan on t (cost=0.00..17030.00 rows=1 width=4) (actual time=449.651..449.651 rows=0 loops=1) Filter: ((i = 10) AND (i = 1)) Total runtime: 449.726 ms -- Sergey Burladyan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] 8.4, One-Time Filter and subquery ( ... FROM function() union all ... )

2009-07-07 Thread Sergey Burladyan
Tom Lane t...@sss.pgh.pa.us writes: Sergey Burladyan eshkin...@gmail.com writes: Oh, now problem with simple query: 8.4.0 from Debian explain analyze select i from t where i = 10 and i = 1; QUERY PLAN

[HACKERS] 8.4, One-Time Filter and subquery ( ... FROM function() union all ... )

2009-07-05 Thread Sergey Burladyan
=0 loops=1) One-Time Filter: false Total runtime: 0.048 ms Is this expected behavior ? Can 8.4 optimize first query like 8.3 ? Thinks ! ps: no response in pgsql-performance so i try ask in pgsql-hackers -- Sergey Burladyan -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] 8.4, One-Time Filter and subquery ( ... FROM function() union all ... )

2009-07-05 Thread Sergey Burladyan
Sergey Burladyan eshkin...@gmail.com writes: Thinks ! Th_a_nks ! :) -- Sergey Burladyan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Not quite a security hole in internal_in

2009-06-09 Thread Sergey Burladyan
,integer) utils_pg.gtrgm_compress(internal) utils_pg.gtrgm_decompress(internal) utils_pg.gtrgm_picksplit(internal,internal) utils_pg.gtrgm_union(bytea,internal) (19 rows) -- Sergey Burladyan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] Improving the ngettext() patch

2009-06-03 Thread Sergey Burladyan
, FUNC_MAX_ARGS), FUNC_MAX_ARGS))); It seems extremely far-fetched that FUNC_MAX_ARGS would ever be small enough that it would make any language's special cases kick in. Russian plural forms for 100, 101, 102 etc. is different, as for 0, 1, 2. -- Sergey

Re: [HACKERS] Solution of the file name problem of copy on windows.

2009-04-14 Thread Sergey Burladyan
Itagaki Takahiro itagaki.takah...@oss.ntt.co.jp writes: There are some issues: * Is it possible to determine the platform encoding? There is no platform encoding in linux. File name encoding depend on user locale, so different users can have different encoding of file name. -- Sergey

Re: XML only working in UTF-8 - Re: [HACKERS] 8.4 open items list

2009-04-07 Thread Sergey Burladyan
nodes and it values written correctly (it is UTF-8), except attribute value, this is strange, imho. xmltype * xmlelement(XmlExprState *xmlExpr, ExprContext *econtext) from xml.c not use xmlTextWriterStartDocument and return html entities in attribute values. -- Sergey Burladyan -- Sent via pgsql

Re: [HACKERS] gettext, plural form and translation

2009-03-30 Thread Sergey Burladyan
8.4 will be released ? Have i time for translate HEAD before release will be ? I try to find 8.4 release date but it is 1st March 2009 %) -- Sergey Burladyan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [HACKERS] gettext, plural form and translation

2009-03-20 Thread Sergey Burladyan
row) ! msgid_plural (%lu rows) ! msgstr[0] (%lu строка) ! msgstr[1] (%lu строки) ! msgstr[2] (%lu строк) #: startup.c:138 #, c-format -- Sergey Burladyan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [HACKERS] gettext, plural form and translation

2009-03-20 Thread Sergey Burladyan
Sergey Burladyan eshkin...@gmail.com writes: gettext-plural-ru-test.patch: - correct translation for 1 rows message hmmm... encoding is broken... i post it again in gzip gettext-plural-ru-test.patch.gz Description: gettext-plural-ru-test.patch -- Sergey Burladyan -- Sent via pgsql

[HACKERS] gettext, plural form and translation

2009-03-18 Thread Sergey Burladyan
this ? ps: i try to translate psql message (1 row)/(3 rows) but can't do this correctly without plural form support. need some work with source for implement it and xgettext params used for extract messages for http://babel.postgresql.org/ Thanks for comments ! -- Sergey Burladyan - -- Sent via

Re: [HACKERS] gettext, plural form and translation

2009-03-18 Thread Sergey Burladyan
Alvaro Herrera alvhe...@commandprompt.com writes: Sergey Burladyan escribió: gnu gettext have support for correct plural form translation (http://www.gnu.org/software/gettext/manual/html_node/Plural-forms.html), but postgresql does not use it. why not ? maybe it have some problem in some

Re: [HACKERS] gettext, plural form and translation

2009-03-18 Thread Sergey Burladyan
Alvaro Herrera alvhe...@commandprompt.com writes: Sergey Burladyan escribió: Alvaro Herrera alvhe...@commandprompt.com writes: Yes, the main reason is that it is not clear whether this is supported on all OS, or moreover that I believe it is not. So some allowances