Re: [DOCS] Reg Date/Time function

2017-08-01 Thread Sandeep Segu
Thank you Steve for the information. Thanks, Sandeep Segu. On Tue, Aug 1, 2017 at 2:04 PM, Steve Crawford < [email protected]> wrote: > Per the docs, justify_days is to "Adjust interval so 30-day time periods > are represented as months" so 360 days = 12 months = 1 year so 365 days

Re: [DOCS] Use of term Master/Slave

2017-08-01 Thread Mike Toews
On 1 August 2017 at 09:13, wrote: > Wondering why PostgreSQL still uses the terms master and slave when there > are other terms like primary/secondary that can be used in the same manner. Another alternative I've seen in different fields is "manager" and "agent". -- Sent via pgsql-docs mailin

Re: [DOCS] Reg Date/Time function

2017-08-01 Thread Mike Toews
On 1 August 2017 at 12:30, wrote: > Hi, > I am going through PostgreSQL, for the first day. And it was great till > now. > One quick question/doubt regarding the function > "justify_days(interval)" > > select justify_days(interval '365 days'); > > this statement returns 1 year 5 days, whereas I

Re: [DOCS] Use of term Master/Slave

2017-08-01 Thread Jonathan Katz
> On Aug 1, 2017, at 3:59 PM, Stephen Frost wrote: > > Alvaro, all, > > * Alvaro Herrera ([email protected]) wrote: >> Simon Riggs wrote: >>> On 31 July 2017 at 22:13, wrote: The following documentation comment has been logged on the website: Page: https://www.postgresq

Re: [DOCS] Use of term Master/Slave

2017-08-01 Thread Stephen Frost
Alvaro, all, * Alvaro Herrera ([email protected]) wrote: > Simon Riggs wrote: > > On 31 July 2017 at 22:13, wrote: > > > The following documentation comment has been logged on the website: > > > > > > Page: https://www.postgresql.org/docs/9.6/static/release-9-6.html > > > Description: > >

Re: [DOCS] Use of term Master/Slave

2017-08-01 Thread Alvaro Herrera
Simon Riggs wrote: > On 31 July 2017 at 22:13, wrote: > > The following documentation comment has been logged on the website: > > > > Page: https://www.postgresql.org/docs/9.6/static/release-9-6.html > > Description: > > > > Wondering why PostgreSQL still uses the terms master and slave when ther

Re: [DOCS] Use of term Master/Slave

2017-08-01 Thread Joshua D. Drake
On 08/01/2017 12:41 PM, Simon Riggs wrote: On 31 July 2017 at 22:13, wrote: The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.6/static/release-9-6.html Description: Wondering why PostgreSQL still uses the terms master and slave when t

Re: [DOCS] Use of term Master/Slave

2017-08-01 Thread Simon Riggs
On 31 July 2017 at 22:13, wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/9.6/static/release-9-6.html > Description: > > Wondering why PostgreSQL still uses the terms master and slave when there > are other terms like primary/

Re: [DOCS] Reg Date/Time function

2017-08-01 Thread Steve Crawford
Per the docs, justify_days is to "Adjust interval so 30-day time periods are represented as months" so 360 days = 12 months = 1 year so 365 days is 1-year 5-days. There are all sorts of oddities and special assumptions regarding date/time calculations made even more complicated by the need to sup

Re: [DOCS] Use of term Master/Slave

2017-08-01 Thread Andres Freund
Hi, On 2017-07-31 21:13:48 +, [email protected] wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/9.6/static/release-9-6.html > Description: > > Wondering why PostgreSQL still uses the terms master and slave when the

[DOCS] "data" not "datums"

2017-08-01 Thread mahsh . baheti
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.4/static/datatype-json.html Description: In the section https://www.postgresql.org/docs/9.4/static/datatype-json.html Sub-section: 8.14.2. Designing JSON documents effectively Original t

[DOCS] Reg Date/Time function

2017-08-01 Thread segu . sandeep
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/8.2/static/functions-datetime.html Description: Hi, I am going through PostgreSQL, for the first day. And it was great till now. One quick question/doubt regarding the function "justify_day

[DOCS] Use of term Master/Slave

2017-08-01 Thread sabrina . iqbal
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.6/static/release-9-6.html Description: Wondering why PostgreSQL still uses the terms master and slave when there are other terms like primary/secondary that can be used in the same manner.

Re: [DOCS] Confused about a statement in WAL configs

2017-08-01 Thread David G. Johnston
On Tue, Aug 1, 2017 at 7:23 AM, Jeremy Finzel wrote: > > I *think* I follow now: before the checkpoint, the dirty data pages had > already been written to the WAL files, but not necessarily flushed to > disk. The checkpoint flushes them all to disk as well. > ​Yes, that it correct. David J.​

Re: [DOCS] Confused about a statement in WAL configs

2017-08-01 Thread Jeremy Finzel
On Mon, Jul 31, 2017 at 10:04 AM, David G. Johnston < [email protected]> wrote: > On Mon, Jul 31, 2017 at 6:16 AM, wrote: > >> The following documentation comment has been logged on the website: >> >> Page: https://www.postgresql.org/docs/9.6/static/wal-configuration.html >> Description: