Re: [GENERAL] streaming replication and archive_status

2017-04-17 Thread Jeff Janes
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? >> >> # pg_xlog/archive_status/ | wc -l >> >> 75217 >> >> Is possib

Re: [GENERAL] streaming replication and archive_status

2017-04-17 Thread Luciano Mittmann
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

2017-04-17 Thread Luciano Mittmann
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; distance=145

Re: [GENERAL] streaming replication and archive_status

2017-04-17 Thread 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? > > # pg_xlog/archive_status/ | wc -l > > 75217 > > Is possible to clean this .done files or just don't need to worry

[GENERAL] streaming replication and archive_status

2017-04-17 Thread Luciano Mittmann
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. T

Re: [GENERAL] Clone PostgreSQL schema

2017-04-17 Thread Melvin Davidson
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 your help! I did some testing, but views in the new >>> schema still

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

2017-04-17 Thread Ron Ben
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 fuctionalit

Re: [GENERAL] Clone PostgreSQL schema

2017-04-17 Thread Melvin Davidson
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. >> >> Regards, Reinhard >> >> Am 17.04.2017 04:53 sc

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

2017-04-17 Thread Devrim Gündüz
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 Engine

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

2017-04-17 Thread Karsten Hilbert
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. This