[BUGS] BUG #6756: primary_conninfo is ignored if restore_command is set..

[ghazel]

The following bug has been logged on the website:

Bug reference:  6756
Logged by:  Greg Hazel
Email address:  gha...@gmail.com
PostgreSQL version: 9.1.4
Operating system:   Amazon Linux
Description:

Trying to get a slave to stream updates from a master, I had both:

restore_command = 'pg_standby /data/pgsql9/archive %f %p %r 2>>standby.log'


and:

primary_conninfo = 'host=10.x.y.z port=5432 user=postgres' 

This configuration never streamed from the master, even after restarts,
waiting hours, etc. After all that, I removed restore_command and restarted,
and the slave started streaming immediately.

This seems to contradict many guides and the documentation I've found.


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] BUG #7620: array_to_json doesn't support heterogeneous arrays

[ghazel]

The following bug has been logged on the website:

Bug reference:  7620
Logged by:  Greg Hazel
Email address:  gha...@gmail.com
PostgreSQL version: 9.2.1
Operating system:   Amazon Linux
Description:

array_to_json(ARRAY['foo', 100, true]) complains because arrays can't have
mixed types, but json arrays can.

So, it's not possible to form a heterogeneous json array, when this is often
desired.




-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs