Can take filesystem bkp of pg data folder when server is running

2018-01-22 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/static/backup-file.html Description: I am running postgresql 10 on mac and was experimenting on backup and restore features of PG 10 I certainly can take FS backup of the cluster with TAR

Re: overlapping ranges

2018-01-22 Thread Peter Eisentraut
On 1/20/18 17:39, Nick Farrell wrote: > Further down the page, that is contradicted, where there are numeric > ranges spaced every hundred, where it says that is disallowed because of > the ambiguity at the overlap point. That talks about the old way of doing partitioning, which works differently

Re: overlapping ranges

2018-01-22 Thread Pantelis Theodosiou
The CREATE TABLE page has this explanation, about FROM and TO in partitioning declarations: > When creating a range partition, the lower bound specified with FROM is an inclusive bound, whereas the upper bound specified with TO is an exclusive bound. That is, the values specified in the FROM list

Re: overlapping ranges

2018-01-22 Thread Nick Farrell
Further down the page, that is contradicted, where there are numeric ranges spaced every hundred, where it says that is disallowed because of the ambiguity at the overlap point. Either way, the documentation is inconsistent. On 21 Jan. 2018 9:26 am, "Peter Eisentraut" < peter.eisentr...@2ndquadran