Re: [GENERAL] pg_dump 8.4.9 failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux

Douglas Stetner wrote: > Looking for confirmation there is an issue with pg_dump failing after upgrade > to openssl-1.0.1e- > 30.el6_6.11.x86_64 on redhat linux. > > -bash-4.1$ pg_dump -V > pg_dump (PostgreSQL) 8.4.9 > > -bash-4.1$ pg_dump -h localhost -C Hogwarts -a -t mafs -f zz > pg_dump: Dum

Re: [GENERAL] pg_xlog on a hot_stanby slave

On 16/06/2015 22:28, Guillaume Lelarge wrote: 2015-06-16 15:55 GMT+02:00 Xavier 12 >: I don't think so. There is no archive_command and the master doesn't ship its wal here. But how can I check that ? What's the complete path to the directory on the sal

Re: [GENERAL] pg_xlog on a hot_stanby slave

On 17/06/2015 02:44, Venkata Balaji N wrote: On Tue, Jun 16, 2015 at 6:55 PM, Xavier 12 > wrote: Hi everyone, Questions about pg_xlogs again... I have two Postgresql 9.1 servers in a master/slave stream replication (hot_standby). Psql01 (master)

Re: [GENERAL] pg_xlog on a hot_stanby slave

On 17/06/2015 03:17, Sameer Kumar wrote: On Tue, 16 Jun 2015 16:55 Xavier 12 > wrote: Hi everyone, Questions about pg_xlogs again... I have two Postgresql 9.1 servers in a master/slave stream replication (hot_standby). Psql01 (master) is back

[GENERAL] Test for char errors

I downloaded psotgresql-9.4.4 source code and build it on Centos 6.5 x64 edition. Then I run 'make test' and it reported that 'All 145 tests passed'. But the expected output and actual output of test 'char' are not same. The expected output of in 'src/test/regress/expected/char.out' is: SELECT ''

Re: [GENERAL] Test for char errors

On Wed, Jun 17, 2015 at 5:15 PM, 夏高 wrote: > I don't know why the files are not the same but tests all passed. Helps are > appreciated, thanks! Some tests have multiple expected outputs. In the case of char, there is not only char.out, but as well char_1.out and char_2.out. In your case char_1.out

Re: [GENERAL] serialization failure why?

Indeed Bill, if drop the foreign key constraint on stuff_ext table there are no failures at all... But, since I can't remove the foreign key, how can I tell postgres that he can "trust" it then? Because it's obvious (for the code reader at least), that the other transaction will not be respons

Re: [GENERAL] serialization failure why?

Filipe Pina wrote: > if drop the foreign key constraint on stuff_ext table there are > no failures at all… It is my recollection that we were excluding the queries used to enforce referential integrity constraints from the conflict tracking, so I am surprised you are seeing this. What is the ex

Re: [GENERAL] Momentary Delay

2015-06-15 18:19 GMT-03:00 Bill Moran : > On Mon, 15 Jun 2015 17:48:54 -0300 > Anderson Valadares wrote: > > > 2015-06-12 19:56 GMT-03:00 Bill Moran : > > > > > Please do not remove the mailing list from replies. See below. > > > > > > On Fri, 12 Jun 2015 09:21:19 -0300 > > > Anderson Valadares

Re: [GENERAL] serialization failure why?

Hi Kevin, I have installed: PostgreSQL 9.3.7 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu 4.8.2-19ubuntu1) 4.8.2, 64-bit But as you mentioned it should have been fixed in later versions, I've upgraded to 9.4: PostgreSQL 9.4.4 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu 4.8.2

[GENERAL] pg_dump 8.4.9 failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux

Hi all, Looking for confirmation there is an issue with pg_dump failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux. -bash-4.1$ pg_dump -V pg_dump (PostgreSQL) 8.4.9 -bash-4.1$ pg_dump -h localhost -C Hogwarts -a -t mafs -f zz pg_dump: Dumping the contents of table "mafs

Re: [GENERAL] serialization failure why?

Indeed Bill, if drop the foreign key constraint on stuff_ext table I get 0 failures... But, since I can't remove the foreign key, how can I tell postgres that he can "trust" it then? Because it's obvious (for the code reader at least), that the other transaction will not be responsible for cre

Re: [GENERAL] pg_dump 8.4.9 failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux

Douglas Stetner writes: > Looking for confirmation there is an issue with pg_dump failing after > upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux. Quick thought --- did you restart the Postgres service after upgrading openssl? If not, your server is still using the old library ver

[GENERAL] Index Advice in PG

Hi list, I am happy to announce the new release of pg_idx_advisor version 0.1.2. This is a PostgreSQL extension which allows a user to get index advice from the DB optimizer. It's the first "stable" release so please don't go running this on your production environment :) But, I'd greatly apprecia

[GENERAL] pg_class.reltuples VS pg_stat_all_tables.n_live_tup for estimation of table

Hello, Does anyone which is a more accurate estimate of a table's live rows: pg_class.reltuples ( http://www.postgresql.org/docs/current/static/catalog-pg-class.html) OR pg_stat_all_tables.n_live_tup ( http://www.postgresql.org/docs/current/static/monitoring-stats.html#PG-STAT-ALL-TABLES-VIEW)? In

Re: [GENERAL] pg_class.reltuples VS pg_stat_all_tables.n_live_tup for estimation of table

William Dunn writes: > Does anyone which is a more accurate estimate of a table's live > rows: pg_class.reltuples ( > http://www.postgresql.org/docs/current/static/catalog-pg-class.html) > OR pg_stat_all_tables.n_live_tup ( > http://www.postgresql.org/docs/current/static/monitoring-stats.html#PG-S

Re: [GENERAL] pg_class.reltuples VS pg_stat_all_tables.n_live_tup for estimation of table

Thanks so much Tom! *Will J. Dunn* *willjdunn.com * On Wed, Jun 17, 2015 at 3:48 PM, Tom Lane wrote: > William Dunn writes: > > Does anyone which is a more accurate estimate of a table's live > > rows: pg_class.reltuples ( > > http://www.postgresql.org/docs/current/static

[GENERAL] writable cte triggers reverse order

hi there! for me case listed below looks like something goes wrong (at least very strange) pg 9.2.10 * schema: base_table ==> inheritance_with_before_trigger ==> child_table ==> audit_after_trigger ==> child_table_log * init sql: create schema tmp; --create extension hstore; -- inheritance par

Re: [GENERAL] Momentary Delay

On Wed, 17 Jun 2015 10:33:37 -0300 Anderson Valadares wrote: > 2015-06-15 18:19 GMT-03:00 Bill Moran : > > > On Mon, 15 Jun 2015 17:48:54 -0300 > > Anderson Valadares wrote: > > > > > 2015-06-12 19:56 GMT-03:00 Bill Moran : > > > > > > > Please do not remove the mailing list from replies. See b

Re: [GENERAL] pg_xlog on a hot_stanby slave

On Wed, 17 Jun 2015 15:24 Xavier 12 wrote: On 17/06/2015 03:17, Sameer Kumar wrote: On Tue, 16 Jun 2015 16:55 Xavier 12 wrote: Hi everyone, Questions about pg_xlogs again... I have two Postgresql 9.1 servers in a master/slave stream replication (hot_standby). Psql01 (master) is backuped w