[HACKERS] User defined data types in Logical Replication

Hi, We are getting the bellow error while trying use Logical Replication with user defined data types in a C program (when call elog function). ERROR: XX000: cache lookup failed for type X # X is remote type's oid It occurs in worker.c:slot_store_error_callback function when

Re: [HACKERS] [ANNOUNCE] PostgreSQL 10 Beta 1 Released!

> From: Bruce Momjian [mailto:br...@momjian.us] > Sent: Saturday, May 20, 2017 1:11 AM > On Fri, May 19, 2017 at 04:10:09AM +0000, Huong Dangminh wrote: > > Hi, > > > > > * 10 Beta Release Notes: > > > https://www.postgresql.org/docs/devel/static/rele

Re: [HACKERS] [ANNOUNCE] PostgreSQL 10 Beta 1 Released!

Hi, > * 10 Beta Release Notes: > https://www.postgresql.org/docs/devel/static/release-10.html Just a minute thing, but changing of hot_standby default value is not fully noted in release-10.sgml. Please find the attached patch. --- Thanks and best regards, Dang Minh Huong NEC Solution

Re: [HACKERS] [PostgreSQL 10] default of hot_standby should be "on"?

> >>> I would refrain from doing that, having some parameters listed in the > >>> tests makes the intention behind those perl routines clear. > > > > Hmm, you've got a point. But when we changed the default values > > related to replication we dropped some explicitly settings from the > >

Re: [HACKERS] [PostgreSQL 10] default of hot_standby should be "on"?

> On Thu, Apr 27, 2017 at 11:48 AM, Masahiko Sawada > wrote: > > Thank you for updating the patch. Also maybe we can update line in > > PostgresNode.pm where hot_standby is set to on explicitly. > > I would refrain from doing that, having some parameters listed in the >

Re: [HACKERS] [PostgreSQL 10] default of hot_standby should be "on"?

Thanks all for your comments. > Magnus Hagander writes: > > +1. I definitely think we should do it, and 10 would be the time to do > it. > > Agreed. It's mainly a historical accident that the default is what it > is, > I think. > > > I wonder if we should also consider

[HACKERS] [PostgreSQL 10] default of hot_standby should be "on"?

Hi, Default for hot_standby parameter should be "on" from PostgreSQL 10? In PostgreSQL 10, -w option is default for [pg_ctl start]. So in order to start standby we have to setting hot_standby to "on" or start standby with -W option. Change hot_standby to "on" will fix this inconvenience.

[HACKERS] Failed with build PostgreSQL in Windows ("--with-perl" option)

Hi, We have trying to build PostgreSQL in Windows Environment. When build with options "--with-perl" (by setting config.pl file), Builder not found "perl\d+.lib" file in "C:\Perl\lib\CORE\" folder, so it ended with the messages bellow. "could not identify perl library version: at

[HACKERS] backpatch for REL9_4_STABLE of commit 40482e606733675eb9e5b2f7221186cf81352da1

Hi, I think this fixed is also required for REL9_4_STABLE. Please confirm the attached patch. Thanks and best regards, Dang Minh Huong NEC Solution Innovators, Ltd. http://www.nec-solutioninnovators.co.jp/en/ ecpg.9.4.patch Description: ecpg.9.4.patch -- Sent via pgsql-hackers mailing list

[HACKERS] Window2012R2: initdb error: "The current directory is invalid."

Hi all, I have failed in execute initdb in "c:\Windows\Temp\dir" folder as reproduce logs below. The OS's messages "The current directory is invalid." was returned. I think it is a specification of Window2012R2 (because i could not reproduce In Windows 7) but not PostgreSQL's problem. But is