[GENERAL] Was: BUG #13883: Very Important Facility

On 1/25/16, d...@nym.hush.com wrote: > Vitaly > > Thanks for the response. With 35 million users I am glad Joomla now > supports postgreSQL. There are 10s of thousands of extensions but > support there is lacking. Unfortunately experience of Python with refactoring internal API

Re: [GENERAL] request for comment re "contributor-covenant.org"

Mr. Harkness, First, the discussion you reference is now materially over. Second, you are not an administrator of this, or any other PostgreSQL mailing list of which I am aware. As such, you are in no position to dictate what is, or is not, acceptable on this list and will get someone "banned";

Re: [GENERAL] Tutorial on How to Compile PostgreSQL 9.5 for Windows 64bit

On 1/25/2016 10:51 PM, Thomas Kellerer wrote: Very helpful, thanks. Great, thank you for the feedback. Is there any tutorial on how to compile extensions for Windows? There are many interesting extensions where no Windows binaries are available, so it would be really helpful if I could

Re: [GENERAL] How to transfer from place to plase without backup/restore

It can done through cloud based services like using drop box or google drive. Happy Rose Day They have worked like a charm for me.. Happy Chocolate Day I think there are

Re: [GENERAL] request for comment re "contributor-covenant.org"

Hi Josh, I simply wrote in first person with the intention to catalyse thought about what could and or should and or should not be in such a "covenant". In no way was the email any statement of authority and I had hoped to make that clear, evidently not. Evidently it was not clear enough despite

Re: [GENERAL] Tutorial on How to Compile PostgreSQL 9.5 for Windows 64bit

Igal @ Lucee.org schrieb am 25.01.2016 um 19:46: > I have posted a video tutorial on How to Compile PostgreSQL 9.5 for Windows > 64bit > https://www.youtube.com/watch?v=-BJmuZT5IPE > > It was quite difficult for me to figure it out, so hopefully it will make > life easier for > the next guy (or

Re: [GENERAL] ERROR: check constraint - PostgreSQL 9.2

On 1/24/16, Christophe Pettus wrote: > > On Jan 24, 2016, at 9:01 PM, Charles Clavadetscher > wrote: > >> What is the point of having a check constraint that is not checked? > > Well, it *is* checked going into the future; it's just not checked at

Re: [GENERAL] ERROR: check constraint - PostgreSQL 9.2

Hello Vitaly > -Original Message- > From: Vitaly Burovoy [mailto:vitaly.buro...@gmail.com] > Sent: Montag, 25. Januar 2016 14:25 > To: Christophe Pettus ; clavadetsc...@swisspug.org > Cc: Postgres General > Subject: Re: [GENERAL] ERROR:

Re: [GENERAL] Tutorial on How to Compile PostgreSQL 9.5 for Windows 64bit

On 01/25/2016 10:49 AM, Joshua Berkus wrote: - Original Message - Hi Everybody, I have posted a video tutorial on How to Compile PostgreSQL 9.5 for Windows 64bit https://www.youtube.com/watch?v=-BJmuZT5IPE It was quite difficult for me to figure it out, so hopefully it will make

Re: [GENERAL] Tutorial on How to Compile PostgreSQL 9.5 for Windows 64bit

- Original Message - > Hi Everybody, > > I have posted a video tutorial on How to Compile PostgreSQL 9.5 for > Windows 64bit > https://www.youtube.com/watch?v=-BJmuZT5IPE > > It was quite difficult for me to figure it out, so hopefully it will > make life easier for > the next guy (or

Re: [GENERAL] CoC [Final v2]

Hello, This thread is deprecated. The CoC Final Draft has been submitted to -core for final modification, acceptance or decline. Sincerely, Joshua D. Drake -- Command Prompt, Inc. http://the.postgres.company/ +1-503-667-4564 PostgreSQL Centered full

Re: [GENERAL] A motion

Hello, This thread is deprecated. The CoC Final Draft has been submitted to -core for final modification, acceptance or decline. Sincerely, Joshua D. Drake -- Command Prompt, Inc. http://the.postgres.company/ +1-503-667-4564 PostgreSQL Centered full

Re: [GENERAL] CoC [Final v2]

>> Participation does not need to be limited to copy-editing. Of all the >> ways to develop a community CoC, we're engaged in just about the worst >> possible one right now. > > so what would be a better way of developing this ? Of interesting note, the Ruby community is currently considering

Re: [GENERAL] long transfer time for binary data

Johannes wrote: > \lo_export 12345 /dev/null is completed in 0.86 seconds. If it's an 11MB file through a 100Mbits/s network, that's pretty much the best that can be expected. I would think the above is the baseline against which the other methods should be compared. > I sa my images

Re: [GENERAL] A motion

On Mon, Jan 25, 2016 at 1:08 PM, Melvin Davidson wrote: > Although it has been previously disregarded, I would like to second the > motion that all further discussion regarding the CoC go to it's own list. > > Consider this. > 1. The Coc will eventually apply to ALL

Re: [GENERAL] CoC [Final v2]

On 1/25/2016 8:39 AM, Brian Dunavant wrote: Of interesting note, the Ruby community is currently considering switching to a CoC inspired directly from this draft of a Postgres CoC. The extremely long conversation can be viewed at: https://redmine.ruby-lang.org/issues/12004 again, people

[GENERAL] help:error while running postgres after installing postgresql server from source code

I was trying to install postgresql from source code on ubuntu.I followed all the instructions and installed all the packages.I was also able to create database cluster but when I executed this command 'postgres -D /usr/local/pgsql/data' I got this $ postgres -D /usr/local/pgsql/data > The

Re: [GENERAL] TABLESAMPLE usage

Yeah. I am looking for fastest possible method that Postgresql would use its internal data structure knowledge to walk through the timestamp index and resturns every "nth" row On Mon, Jan 25, 2016 at 5:56 AM, Simon Riggs wrote: > On 25 January 2016 at 09:44, Matija Lesar

Re: [GENERAL] help:error while running postgres after installing postgresql server from source code

On Sat, Jan 23, 2016 at 6:42 PM, Shubham Barai wrote: > > I was trying to install postgresql from source code on ubuntu.I followed all the instructions and installed all the packages.I was also able to create database cluster but when I executed this command 'postgres -D

[GENERAL] Tutorial on How to Compile PostgreSQL 9.5 for Windows 64bit

Hi Everybody, I have posted a video tutorial on How to Compile PostgreSQL 9.5 for Windows 64bit https://www.youtube.com/watch?v=-BJmuZT5IPE It was quite difficult for me to figure it out, so hopefully it will make life easier for the next guy (or gal). -- Igal Sapir Lucee Core Developer

Re: [GENERAL] A motion

On 1/25/2016 12:55 AM, Albe Laurenz wrote: Regina Obe wrote: At this point I feel we should: ... While I personally feel that a code of conduct does not need to be an explicit document and is something that "happens" through the way people on the lists behave and the way the core team and

Re: [GENERAL] long transfer time for binary data

Am 25.01.2016 um 19:59 schrieb Daniel Verite: > Johannes wrote: > >> \lo_export 12345 /dev/null is completed in 0.86 seconds. > > If it's an 11MB file through a 100Mbits/s network, that's > pretty much the best that can be expected. > > I would think the above is the baseline against

Re: [GENERAL] CoC [Final v2]

Just to respond to Josh's previous question: Yes, I ike the current code of conduct. Much prefer to the alternatives offered aimed at "feeling safe" (for the reason that keeping the peace in a culturally diverse community will not allow people that luxury all the time). I am not convinced we

Re: [GENERAL] A motion

Although it has been previously disregarded, I would like to second the motion that all further discussion regarding the CoC go to it's own list. Consider this. 1. The Coc will eventually apply to ALL PostgreSQL mail lists. 2. There will be a need to have additions and revisions to the Coc. 3. As

Re: [GENERAL] Tutorial on How to Compile PostgreSQL 9.5 for Windows 64bit

On Tue, Jan 26, 2016 at 3:56 AM, Joshua D. Drake wrote: > On 01/25/2016 10:49 AM, Joshua Berkus wrote: >> >> >> >> - Original Message - >>> >>> Hi Everybody, >>> >>> I have posted a video tutorial on How to Compile PostgreSQL 9.5 for >>> Windows 64bit >>>

Re: [GENERAL] Tutorial on How to Compile PostgreSQL 9.5 for Windows 64bit

On 01/25/2016 05:29 PM, Michael Paquier wrote: On Tue, Jan 26, 2016 at 3:56 AM, Joshua D. Drake wrote: On 01/25/2016 10:49 AM, Joshua Berkus wrote: - Original Message - Hi Everybody, I have posted a video tutorial on How to Compile PostgreSQL 9.5 for

Re: [GENERAL] Tutorial on How to Compile PostgreSQL 9.5 for Windows 64bit

On Tue, Jan 26, 2016 at 10:34 AM, Joshua D. Drake wrote: > On 01/25/2016 05:29 PM, Michael Paquier wrote: >> >> On Tue, Jan 26, 2016 at 3:56 AM, Joshua D. Drake >> wrote: >>> >>> On 01/25/2016 10:49 AM, Joshua Berkus wrote:

Re: [GENERAL] request for comment re "contributor-covenant.org"

Zenaan, Thank you for providing your insight. However, our Core Committee is already considering a CoC and is in final stages of either modification, acceptance or decline. Sincerely, Joshua D. Drake -- Command Prompt, Inc. http://the.postgres.company/

[GENERAL] request for comment re "contributor-covenant.org"

Warning, some people may consider the following analysis to have one or two trigger words and or to be insensitive. DO NOT read it if you are emotionally sensitive or otherwise challenged in regards to robust communications and the rights of amateur humans to create social spaces of their

Re: [GENERAL] Performance options for CPU bound multi-SUM query

Matt wrote: > I have a warehousing case where data is bucketed by a key of an hourly > timestamp and 3 other columns. In addition there are 32 numeric columns. The > tables are partitioned on regular date ranges, and aggregated to the lowest > resolution usable. > > The

Re: [GENERAL] TABLESAMPLE usage

Thanks, the solution would work for fixed interval timestamp. But the data I am dealing with has irregular timestamp so can not be generated with exact steps. I would consider this a special case/method of random sampling, evenly distributed sampling according to the defined timestamp index. On

Re: [GENERAL] Performance options for CPU bound multi-SUM query

On 25 January 2016 at 15:45, Matt wrote: > I have a warehousing case where data is bucketed by a key of an hourly > timestamp and 3 other columns. In addition there are 32 numeric columns. The > tables are partitioned on regular date ranges, and aggregated to the lowest >

Re: [GENERAL] TABLESAMPLE usage

On 01/25/2016 05:09 AM, Tom Smith wrote: > Hello: > > I have a big table with that is always appended with new data with a unique > sequence id (always incremented, or timestamp as unique index) each row. > I'd like to sample, say 100 rows out of say 1000 rows evently across all > the rows, > so

Re: [GENERAL] A motion

Regina Obe wrote: > At this point I feel we should: > > a) Move this to pgsql-advocacy [...] > Or > > b) Start a new PostgreSQL mailing list - call it - pgsql-coc. -1 While I personally feel that a code of conduct does not need to be an explicit document and is something that "happens"

Re: [GENERAL] TABLESAMPLE usage

On 25 January 2016 at 09:55, Tom Smith wrote: > Thanks, the solution would work for fixed interval timestamp. > But the data I am dealing with has irregular timestamp so can not be > generated with exact steps. > > I would consider this a special case/method of random

Re: [GENERAL] TABLESAMPLE usage

On 01/25/2016 09:55 AM, Tom Smith wrote: > Thanks, the solution would work for fixed interval timestamp. > But the data I am dealing with has irregular timestamp so can not be > generated with exact steps. > > I would consider this a special case/method of random sampling, evenly > distributed

Re: [GENERAL] Possible to dump/load a database from within psql?

On 01/25/2016 02:16 AM, Brian Cardarella wrote: Is it possible, and if so how, to dump and then load a database to/from a file from within a psql connection? pg_dump -h $host -U $user $database|psql -U $user -h $host $database http://www.postgresql.org/docs/9.5/static/app-pgdump.html

[GENERAL] Possible to dump/load a database from within psql?

Is it possible, and if so how, to dump and then load a database to/from a file from within a psql connection? -- Brian Cardarella CEO of DockYard Visit us: http://dockyard.com Call us: (855) DOCK-YRD Follow me on Twitter: http://twitter.com/bcardarella Follow us on Twitter:

Re: [GENERAL] Possible to dump/load a database from within psql?

On 25/01/2016 10:16, Brian Cardarella wrote: > Is it possible, and if so how, to dump and then load a database to/from > a file from within a psql connection? You can use the COPY command to do a table at a time, but you'll get just the data - you won't get permissions etc. Ray. -- Raymond

Re: [GENERAL] TABLESAMPLE usage

On 25 January 2016 at 09:44, Matija Lesar wrote: > you can accomplish this with row_number() > > : > > WITH data_cte as ( > SELECT > id, > clock_timestamp() as