Re: [GENERAL] pg_multixact issues

Καλημέρα Κυριάκο We have been running 9.3.4 as our test system for quite some years, and 9.3.10 on production for a month or so (little less than 1T size, WAL changes worth of 2-5GB/day, about 250K xations/day) we never experienced any problems with data/pg_multixact. In our 9.3.4 : % pg_contr

Re: [GENERAL] ERROR: missing FROM-clause entry for table

The call_schedule table looks like this id| integer | not null default nextval('call_schedule_id_seq'::regclass) account_id| integer | not null user_id | integer | not null call_type_id | integer

Re: [GENERAL] Transaction ID not logged if no explicit transaction used

El 10/02/16 a las 20:11, Adrian Klaver escribió: >> >> So, my question is: Is this a bug, or a feature? I recall being able to >> log xids on DDLs but can't find the correct settings now. > > Maybe?: > > %v Virtual transaction ID (backendID/localXID) AFAICS that value won't help if I need th

Re: [GENERAL] Test CMake build

Alban Hertroys wrote: I was under the impression that the FreeBSD port already uses cmake? I tested on a 32-bit FreeBSD. All tests passed. -- Yury Zhuravlev Postgres Professional: http://www.postgrespro.com The Russian Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@po

[GENERAL] memory problem with refresh materialized view

Hi I have a new postgresql 9.5.0 installation on a new virtual server debian 8.3 x64 with 4gb RAM, I have compiled postgresql from source. When I import a dump with materialized views I see that postgres process takes about all 4 Gb and then I have this error fork: Cannot allocate memory Can a

Re: [GENERAL] Test CMake build

Andy Colson wrote: the end of CMakeFiles/CMakeError.log shows: Many thanks! I think I understand what the problem is. I will try to fix soon. I write as a corrected. -- Yury Zhuravlev Postgres Professional: http://www.postgrespro.com The Russian Postgres Company -- Sent via pgsql-general m

[GENERAL] Unrecognized configuration parameter in bdr 0.9.3

Hi, I am following http://bdr-project.org/docs/stable/index.html for setting up multimaster replication. *First Master box* *cat postgresql.conf* # Allow two other peer nodes, plus one for init_replica max_replication_slots = 3 # Two peer nodes, plus two slots for pg_basebackup max_wal_senders

Re: [GENERAL] PostgreSQL vs Firebird SQL

Le 10/02/2016 18:08, John R Pierce a écrit : On 2/10/2016 8:51 AM, Pierre Chevalier Géologue wrote: PPS: how should I behave on this list: should I systematically "reply to all", or just "reply" to the list? I'm used to a number of mailing lists where a simple "reply" automatically replies to t

Re: [GENERAL] PostgreSQL vs Firebird SQL

Le 10/02/2016 19:49, Adrian Klaver a écrit : Go here: https://mail.postgresql.org/mj/mj_wwwusr/domain=postgresql.org?func=lists-long-full&extra=pgsql-general And in settings check: eliminatecc Select this if you do not want two copies when someone sends a message both to you and to the li

Re: [GENERAL] PostgreSQL vs Firebird SQL

On Tue, Feb 9, 2016 at 10:10 PM, ioan ghip wrote: > I have a Firebird SQL database running on one of my servers which has about > 50k inserts, about 100k updates and about 30k deletes every day. There are > about 4 million records in 24 tables. I have a bunch of stored procedures, > triggers, even

Re: [GENERAL] Test CMake build

Yury Zhuravlev wrote: I will try to fix soon. I write as a corrected. You can try again. Thanks! -- Yury Zhuravlev Postgres Professional: http://www.postgrespro.com The Russian Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subs

Re: [GENERAL] PostgreSQL vs Firebird SQL

On 02/11/2016 05:42 AM, Pierre Chevalier Géologue wrote: Le 10/02/2016 19:49, Adrian Klaver a écrit : Go here: https://mail.postgresql.org/mj/mj_wwwusr/domain=postgresql.org?func=lists-long-full&extra=pgsql-general And in settings check: eliminatecc Select this if you do not want two co

[GENERAL] PosgreSQL Security Architecture

All; I'm working to secure a PosgreSQL database according to a DoD security guide. It has many very generic requirements that get more toward the internal architecture of the system that wouldn't be apparent to the average admin. I was hoping someone might have some insight to the following requir

Re: [GENERAL] PosgreSQL Security Architecture

On 02/11/2016 08:30 AM, Lesley Kimmel wrote: All; I'm working to secure a PosgreSQL database according to a DoD security guide. It has many very generic requirements that get more toward the internal architecture of the system that wouldn't be apparent to the average admin. I was hoping someone

Re: [GENERAL] Test CMake build

On 2/11/2016 9:49 AM, Yury Zhuravlev wrote: Yury Zhuravlev wrote: I will try to fix soon. I write as a corrected. You can try again. Thanks! That seems better: -- Found Readline: /usr/include -- Found Curses: /usr/lib64/libcurses.so Is this bad? -- Check size of int64 -- Check size of int

Re: [GENERAL] fast refresh materialized view

We would like to contribute to the PostgreSQL community. What can you recommend us? Thank you. TS. Nguyễn Trần Quốc Vinh --- Chủ nhiệm khoa Tin học Trường ĐH Sư phạm - ĐH Đà Nẵng Website: http://it.ued.vn ; http://www.ued.vn

Re: [GENERAL] Test CMake build

On 2/11/2016 10:44 AM, Andy Colson wrote: On 2/11/2016 9:49 AM, Yury Zhuravlev wrote: Yury Zhuravlev wrote: I will try to fix soon. I write as a corrected. You can try again. Thanks! That seems better: -- Found Readline: /usr/include -- Found Curses: /usr/lib64/libcurses.so Is this bad?

Re: [GENERAL] Test CMake build

On 2/10/2016 12:09 PM, Yury Zhuravlev wrote: Hello all. Please test build Postgres using cmake. If you are of course interested. Still not everything is ready but most of the work. Assembly instructions as does the repository is on github: https://github.com/stalkerg/postgres_cmake The compilati

Re: [GENERAL] Test CMake build

Andy Colson wrote: Is this bad? -- Check size of int64 -- Check size of int64 - failed -- Check size of uint64 -- Check size of uint64 - failed -- Check size of int8 -- Check size of int8 - failed This is normal behavior for linux. -- Yury Zhuravlev Postgres Professional: http://www.postgres

Re: [GENERAL] Test CMake build

Yury Zhuravlev writes: > Andy Colson wrote: >> Is this bad? >> -- Check size of int64 >> -- Check size of int64 - failed >> -- Check size of uint64 >> -- Check size of uint64 - failed >> -- Check size of int8 >> -- Check size of int8 - failed > This is normal behavior for linux. Really? That s

Re: [GENERAL] Test CMake build

I used to use "make install-strip", is that not a thing anymore? I think it's plans for the near future. Please create issue in GitHub. /home/andy/projects/postgres_cmake/build/src/timezone//zic: Cannot create directory /usr/local/pg99: Permission denied I will fix it. sh: /usr/local/pg99/bi

Re: [GENERAL] Test CMake build

Tom Lane wrote: Really? That sure seems misleading as can be, and not something we'd want to be part of a new user's very first impression of Postgres. In configure we have similar messages: checking for int8... no checking for uint8... no checking for int64... no checking for uint64... no

Re: [GENERAL] fast refresh materialized view

Похоже на то, что вы понимаете по-русски ! Сообщество примет вашу работу только под лицензией BSD. Если что непонятно, пишите мне. С Уважением, Олег On Thu, Feb 11, 2016 at 7:56 PM, Nguyễn Trần Quốc Vinh wrote: > We would like to contribute to the PostgreSQL community. What can you > recommend

Re: [GENERAL] Test CMake build

Yury Zhuravlev writes: > Tom Lane wrote: >> Really? That sure seems misleading as can be, and not something we'd >> want to be part of a new user's very first impression of Postgres. > In configure we have similar messages: > checking for int8... no > checking for uint8... no > checking for int6

Re: [GENERAL] ERROR: missing FROM-clause entry for table

On 2/11/2016 2:15 AM, bigkev wrote: ... This stores the start_time, which is the date and time a series of calls begins. The duration defines how long this event(call) will go for, and the end_time defines when the schedule will stop. I need to generate a calendar eg: 1 year with intervals of 1 d

Re: [GENERAL] Test CMake build

On четверг, 11 февраля 2016 г. 22:37:12 MSK, Tom Lane wrote: Hm, well, configure does not use the word "failed" to describe expected cases. Well, it does not confuse CMake users. (MySQL, KDE) Just the other tradition, I do not see the problem here. :) -- Yury Zhuravlev Postgres Professional: h

Re: [GENERAL] Transaction ID not logged if no explicit transaction used

El 10/02/16 a las 21:46, Tom Lane escribió: > > Think you're outta luck on that. If we logged the duration before > commit, it would be entirely misleading for short commands, because > the time needed to commit wouldn't be included. So we log it after, > when there's no longer any active transa

Re: [GENERAL] Transaction ID not logged if no explicit transaction used

Martín Marqués wrote: > El 10/02/16 a las 21:46, Tom Lane escribió: > > We could maybe fix this by redefining %x as "the current or most recent > > xid", so that it'd still be valid for messages issued post-commit. > > But I'm afraid that would add about as many bad behaviors as it would > > remov

Re: [GENERAL] Transaction ID not logged if no explicit transaction used

Alvaro Herrera writes: > Martín Marqués wrote: >> This really gives little use for recovery_target_xid. :( > Hmm, you can still use pg_xlogdump to figure it out from the actual WAL, > which has the correct XIDs. It's obviously a worse solution though from > the user's POV, because it's hard to f

[GENERAL] XMLEXISTS on legacy XML with malformed xmlns

Hi! I've some (about 1M records) containing legacy XML I would like to parse and apply XMLEXISTS. This is the query: select * from xmllog where xpath_exists(('//MyDocument[@DocNum = ''000411828'']'::text), xmlparse(document cdataout)); This is the error: ERRO: could not parse XML documen

Re: [GENERAL] Unrecognized configuration parameter in bdr 0.9.3

On 11 February 2016 at 20:16, Kaushal Shriyan wrote: > Hi, > > I am following http://bdr-project.org/docs/stable/index.html for setting > up multimaster replication. > Are you sure that's the documentation you were using? You seem to have settings that only applied to the older 0.7.x versions:

Re: [GENERAL] fast refresh materialized view

On Fri, Feb 12, 2016 at 1:56 AM, Nguyễn Trần Quốc Vinh wrote: > We would like to contribute to the PostgreSQL community. What can you > recommend us? If you are planning to send patches for integration into core Postgres, this code needs to be available under a license that is compatible with the

Re: [GENERAL] fast refresh materialized view

On Fri, Feb 12, 2016 at 4:29 AM, Oleg Bartunov wrote: > Похоже на то, что вы понимаете по-русски ! I don't. My bad. -- Michael -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] 9.4 -> 9.5 dump size reduction

Hello, I recently upgraded a server from 9.4 to 9.5 (Debian) via pg_upgradecluster. The upgrade finished well, and so far the databases in the upgraded cluster seem in good form. However, I noticed a dramatic reduction in the size of the dump created by the new server. One of the databases was 3

Re: [GENERAL] 9.4 -> 9.5 dump size reduction

Seb writes: > I recently upgraded a server from 9.4 to 9.5 (Debian) via > pg_upgradecluster. The upgrade finished well, and so far the databases > in the upgraded cluster seem in good form. However, I noticed a > dramatic reduction in the size of the dump created by the new server. > One of the

Re: [GENERAL] XMLEXISTS on legacy XML with malformed xmlns

2016-02-12 1:53 GMT+01:00 Edson Richter : > Hi! > > I've some (about 1M records) containing legacy XML I would like to parse > and apply XMLEXISTS. > > This is the query: > > select * from xmllog > where xpath_exists(('//MyDocument[@DocNum = ''000411828'']'::text), > xmlparse(document cdataout));