Re: [GENERAL] Major upgrade of PostgreSQL and MySQL

2013-10-06 Thread Patrick Dung
Noted and thanks. I can see that it should be updated in the devel manual page: http://www.postgresql.org/docs/devel/static/pgupgrade.html Thanks, Patrick From: Bruce Momjian To: Patrick Dung Cc: Stephen Frost ; "pgsql-general@postgresql.org" ; Ivan Voras

[GENERAL] C-language stored function and float4 type

2013-10-06 Thread whiplash
Hello! I have C-language stored function like this: #include #include #ifdef PG_MODULE_MAGIC PG_MODULE_MAGIC; #endif PG_FUNCTION_INFO_V1(testfunc); Datum testfunc(PG_FUNCTION_ARGS) { float4 x = PG_GETARG_FLOAT4(0); float4 y = PG_GETARG_FLOAT4(1); PG_RETURN_FLOAT4(x + y); }

[GENERAL] Why there are no max_wal_receivers

2013-10-06 Thread 高健
Hello : I found that for PG9.2.4, there is parameter max_wal_senders, But there is no parameter of max_wal_receivers. Is that to say, that If max_wal_senders are 3. Then 3 wal_senders will be activated , And then on the standby server, there will be 3 "receivers" for counter-part ? Th

Re: [GENERAL] Why there are no max_wal_receivers

2013-10-06 Thread Amit Langote
Hi, On Mon, Oct 7, 2013 at 12:02 PM, 高健 wrote: > Hello : > > > I found that for PG9.2.4, there is parameter max_wal_senders, > > But there is no parameter of max_wal_receivers. > > max_wal_senders is the maximum number of WAL sender processes that a primary server can create in response to reque