[GENERAL] pg_stats_repoter error message

I tried installing pgstatsinfo and pgstatsrepoter. Whatever i try to give in pg_stats_reporter.ini I get a error message, particularly whatever i give in repository database, i get an error. . Have anyone installed these monitoring tool.

Re: [GENERAL] error on online backup using pg_basebackup tool

On Thu, Sep 3, 2015 at 7:20 AM, Martín Marqués wrote: > El 03/09/15 a las 00:54, Gerdan Rezende dos Santos escribió: > > > > > > In other server with same configuration the proccess not complete too! > > Add --verbose to the pg_basebackup execution and send over the

Re: [GENERAL] how to investigate GIN fast updates and cleanup cycles?

I wanted to follow up and report we altered the index in question and turned off fastupdate and we have not seen the issue I originally reported since. Just for the record I did: ALTER INDEX my_index SET (fastupdate=off); SET vacuum_cost_delay=0; VACUUM VERBOSE my_table_with_that_index; We

Re: [GENERAL] error on online backup using pg_basebackup tool

On Thu, Sep 3, 2015 at 5:01 PM, Martín Marqués wrote: > 2015-09-03 16:48 GMT-03:00 Gerdan Rezende dos Santos : > > On Thu, Sep 3, 2015 at 7:20 AM, Martín Marqués > > wrote: > >> > >> El 03/09/15 a las 00:54, Gerdan Rezende dos

Re: [GENERAL] error on online backup using pg_basebackup tool

Hi Gerdan, 2015-09-03 17:41 GMT-03:00 Gerdan Rezende dos Santos : > > This problem, I found in my client ... > Why are you putting in PGDATA table ? He can not say to me > The solution then is to continue using the start_backup , rsync and > stop_backup. ;( Or use repmgr. ;)

Re: [GENERAL] error on online backup using pg_basebackup tool

Hi Gerdan, 2015-09-03 18:06 GMT-03:00 Gerdan Rezende dos Santos : > > Matín, the client have a BART from EDB. > EDB BART only use pg_basebackup. > Its my problem. AFAIK BART is a backup & recovery tool, and I thought you were trying to spin new standbys, which is why I

Re: [GENERAL] error on online backup using pg_basebackup tool

2015-09-03 16:48 GMT-03:00 Gerdan Rezende dos Santos : > On Thu, Sep 3, 2015 at 7:20 AM, Martín Marqués > wrote: >> >> El 03/09/15 a las 00:54, Gerdan Rezende dos Santos escribió: >> > >> > >> > In other server with same configuration the proccess not

Re: [GENERAL] error on online backup using pg_basebackup tool

On Thu, Sep 3, 2015 at 5:53 PM, Martín Marqués wrote: > Hi Gerdan, > > 2015-09-03 17:41 GMT-03:00 Gerdan Rezende dos Santos : > > > > This problem, I found in my client ... > > Why are you putting in PGDATA table ? He can not say to me > > The solution

Re: [GENERAL] error on online backup using pg_basebackup tool

On Thu, Sep 3, 2015 at 4:41 PM, Gerdan Rezende dos Santos wrote: > On Thu, Sep 3, 2015 at 5:01 PM, Martín Marqués > wrote: > >> 2015-09-03 16:48 GMT-03:00 Gerdan Rezende dos Santos : >> > On Thu, Sep 3, 2015 at 7:20 AM, Martín Marqués

[GENERAL] Postgresql C extension and SIGSEGV

Hi, We are planning to add a C extension ( https://github.com/petropavel13/pg_rrule) to our shared postgresql cluster, and wondering what are the risk? (looking for the worst case scenario here) If there is a SIGSEGV, SIGBUS, SIGABRT ..., is the whole server stopping, or just the request?

[GENERAL] pg_basebackup problem for Streaming replication

Dear Experts, One problem, I am facing that when I am using *pg_basebackup* (on Standby Server) it’s copying only some files and directories not all like pg_notify folder etc. That’s why when I am restarting the database on "Standby Server" after "pg_basebackup" then it’s showing an error below.

Re: [GENERAL] get first and last row in one sql as two columns

On Wed, Sep 02, 2015 at 07:14:40PM -0400, Tom Smith wrote: > Hi: > > I need to get the first and last tow in one sql like below > > select first(col1), last(col1) from table order by col1 Have you tried the window functions [1] last_value and first_value? You could use something like: SELECT

Re: [GENERAL] error on online backup using pg_basebackup tool

El 03/09/15 a las 00:54, Gerdan Rezende dos Santos escribió: > > > In other server with same configuration the proccess not complete too! Add --verbose to the pg_basebackup execution and send over the output error message. I find your procedure confusing, and I'd recommend you *not* to put

Re: [GENERAL] get first and last row in one sql as two columns

Hi: The window function works for me (with adding limit 1 in the end to output only one row needed instead of many duplicate rows). thanks very much. On Thu, Sep 3, 2015 at 6:51 AM, Dickson S. Guedes wrote: > On Wed, Sep 02, 2015 at 07:14:40PM -0400, Tom Smith wrote: >

[GENERAL] Installation of BDR from source

This doc: http://bdr-project.org/docs/stable/installation-source.html at section: 3.3.3. Installation of BDR from source needs to have a "make install" added here: cd /path/to/bdr-plugin-source/ PATH=/path/to/install:"$PATH" ./configure make -j4 -s all -- Sent via pgsql-general

Re: [GENERAL] get first and last row in one sql as two columns

Tom Smith schrieb am 03.09.2015 um 14:11: >> >> SELECT first_value(col1) over (order by col1), >>last_value(col1) over (order by col1) >> FROM table; >> > The window function works for me (with adding limit 1 in the end to output > only one row > needed instead of many

Re: [GENERAL] bdr admin role

Please show your connection strings, and the contents of bdr.bdr_nodes and bdr.bdr_connections. On 3 September 2015 at 05:00, Ray Stell wrote: > This doc specifies to initdb with the admin user "postgres," > http://bdr-project.org/docs/stable/quickstart-instances.html > but if I

Re: [GENERAL] Installation of BDR from source

On 3 September 2015 at 21:18, Ray Stell wrote: > This doc: http://bdr-project.org/docs/stable/installation-source.html > > at section: 3.3.3. Installation of BDR from source > > needs to have a "make install" added here: > > cd /path/to/bdr-plugin-source/ >