Re: [GENERAL] streaming replication and archive_status

2017-04-17 17:08 GMT-03:00 Jeff Janes : > On Mon, Apr 17, 2017 at 12:22 PM, Luciano Mittmann > wrote: > >> Hi All, >> >> anyone knows why there are so many files in the directory >> pg_xlog/archive_status/ in replication server? >> >> #

Re: [GENERAL] streaming replication and archive_status

Version 9.6.2 Checkpoint on primary server: [ 2017-04-17 17:23:25 BRT] @ LOG: checkpoint complete: wrote 19436 buffers (2.4%); 0 transaction log file(s) added, 2 removed, 7 recycled; write=149.506 s, sync=0.310 s, total=149.958 s; sync files=370, longest=0.012 s, average=0.000 s; distance=133971

Re: [GENERAL] streaming replication and archive_status

Hi Jeff, checkpoint message on standby node: [ 2017-04-17 17:21:56 BRT] @ LOG: restartpoint complete: wrote 21475 buffers (2.6%); 0 transaction log file(s) added, 0 removed, 0 recycled; write=149.816 s, sync=0.064 s, total=149.890 s; sync files=314, longest=0.002 s, average=0.000 s;

Re: [GENERAL] streaming replication and archive_status

On Mon, Apr 17, 2017 at 12:22 PM, Luciano Mittmann wrote: > Hi All, > > anyone knows why there are so many files in the directory > pg_xlog/archive_status/ in replication server? > > # pg_xlog/archive_status/ | wc -l > > 75217 > > Is possible to clean this .done files or just

[GENERAL] streaming replication and archive_status

Hi All, anyone knows why there are so many files in the directory pg_xlog/archive_status/ in replication server? # pg_xlog/archive_status/ | wc -l 75217 Is possible to clean this .done files or just don't need to worry ? It's not occurs on primary or standalone servers, just on replication.

Re: [GENERAL] Clone PostgreSQL schema

On Mon, Apr 17, 2017 at 11:02 AM, Melvin Davidson wrote: > > > On Mon, Apr 17, 2017 at 9:42 AM, Melvin Davidson > wrote: > >> >> On Mon, Apr 17, 2017 at 2:20 AM, R. Reiterer >> wrote: >> >>> Hi Melvin, >>> >>> thanks again for

Re: [GENERAL] Nice to have features: Percentage function

Hi, I know I can solve my issue localy but I think that percentage manipulation is commonly used by many users and while it's true that each one can create his own solution localy it would be nice if postgresql would have build in functions for that.   percentagee manipulation is a core

Re: [GENERAL] Clone PostgreSQL schema

On Mon, Apr 17, 2017 at 9:42 AM, Melvin Davidson wrote: > > On Mon, Apr 17, 2017 at 2:20 AM, R. Reiterer wrote: > >> Hi Melvin, >> >> thanks again for your help! I did some testing, but views in the new >> schema still refer to the old schema. >> >>

Re: [GENERAL] Error During PostGIS Build From Source on Linux

Hi, On Wed, 2017-04-12 at 16:10 -0700, John R Pierce wrote: > if you install those packages from the yum repository, doesn't postgis  > include raster support? It does. Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified

Re: [GENERAL] How to add columns to view with dependencies

On Sun, Apr 16, 2017 at 08:02:54PM -0700, Guyren Howe wrote: > I can imagine ways of sort-of dealing with this. I might > maintain a SQL file with views to create in a suitable order, > Then I could drop all views, edit the definition of one, then > run the file, but this is awfully tedious.