[GENERAL] trigger Before or After

hi, in the pgsql documentation (http://www.postgresql.org/docs/9.1/static/sql-createtrigger.html) i haven't seen anything referring to: how is affected the data inserted in the new table by a trigger Before Insert compared with a trigger After Insert? and anything related to performance for exam

[GENERAL] Integrating PostgreSQL with Elasticsearch and Kibana

Hi All, I have source input which stores data in PostgreSQL database in JSON format. I want to perform the analytical operation on data present in PostgreSQL and visualize the results of operations. I have found one open source analytical tool called Kibana (integrated with elasticsearch) which

Re: [GENERAL] justify_interval: days in year

On Mon, 10 Nov 2014 14:14:15 +0100 Francisco Olarte wrote: > On Mon, Nov 10, 2014 at 10:07 AM, Ilya Ashchepkov > wrote: > > > Is this correct? > > $ select > > justify_interval(t-f-i) > > ,t-f-i > > from > > ( > > select > > timestamp '2014-1-1' as f, > > timestamp '2015-1

Re: [GENERAL] Concat bigint Array Values in a Function

Table A : 220 MB Table B : 120 KB Yeah figuring out how to write it in pure SQL. Thanks On Tue, Nov 11, 2014 at 6:15 AM, David G Johnston < david.g.johns...@gmail.com> wrote: > Vinay Gupta wrote > > Please let me know if there is any optimal way to finish this function in > > ~ > > 2-3 secs > >

Re: [GENERAL] Updating timezone setting

On 11/10/2014 02:04 PM, Keith Fiske wrote: Discovered that a client of ours had assumed their database was running in UTC, but turned out to be running in 'US/Eastern'. They had changed all their systems a while ago to run in UTC but didn't realize the database was independent of that. The postgr

Re: [GENERAL] Concat bigint Array Values in a Function

Vinay Gupta wrote > Please let me know if there is any optimal way to finish this function in > ~ > 2-3 secs If you can figure out how to write that in pure SQL you might have a chance. David J. -- View this message in context: http://postgresql.nabble.com/Concat-bigint-Array-Values-in-a-Fun

Re: [GENERAL] repmgr

On 11/10/2014 4:10 PM, Robin Ranjit Singh Chauhan wrote: I havent been able to find much about repmgr on postgres 9.3 Is repmgr still a significant value add given the newer replication features built in? repmgr is a management tool for setting up and controlling the built in replication fea

[GENERAL] repmgr

I havent been able to find much about repmgr on postgres 9.3 Is repmgr still a significant value add given the newer replication features built in? Thanks. =R -- Robin R Chauhan CEO, Pathway Intelligence Inc ro...@pathwayi.com Office: 778-588-6217 Ext. 201 Cell: 604-865-0517 http://pathwayi.com/

[GENERAL] Concat bigint Array Values in a Function

Hi, I need to optimise and aggregate array integer values in a function and i am doing this by below stored function : -- type def CREATE TYPE fun_type AS ( g_id integer, zip_id_list integer[], city_id_list integer[], state_id_list integer[], lat_long_id_li

[GENERAL] Updating timezone setting

Discovered that a client of ours had assumed their database was running in UTC, but turned out to be running in 'US/Eastern'. They had changed all their systems a while ago to run in UTC but didn't realize the database was independent of that. The postgresql.conf has timezone = 'US/Eastern' set i

Re: [GENERAL] SSL Certificates in Postgres 9.3 and Windows 7

Since we are testing...test using Nabble.com and the more->raw option... "begin quote" I also get this error message in my log file: "begin raw" "end raw" "end quote" Following the sentence above should be 4 lines of log file content... Sent using the Nabble.com interface Dave -- View thi

Re: [GENERAL] SSL Certificates in Postgres 9.3 and Windows 7

On Mon, Nov 10, 2014 at 8:53 PM, John R Pierce wrote: > On 11/10/2014 11:13 AM, Magnus Hagander wrote: >> >> Then it's more logical. Nabble simply did not include that when the >> email was posted. I would call that either a bug or at least a >> limitation in Nabble - I think only they can figure

Re: [GENERAL] SSL Certificates in Postgres 9.3 and Windows 7

On 11/10/2014 11:13 AM, Magnus Hagander wrote: Then it's more logical. Nabble simply did not include that when the email was posted. I would call that either a bug or at least a limitation in Nabble - I think only they can figure out what's wrong and if it's fixable. Until then, we'll have to rec

Re: [GENERAL] Centos 7 - anyone?

On 11/10/2014 10:45 AM, Edson Richter wrote: Hi! I've just received a new server, and I've the intention to install Centos7 and PostgreSQL 9.3.5. After installing the yum repo (as described in http://www.postgresql.org/download/linux/redhat/), I've installed everything I need with the command y

Re: [GENERAL] SSL Certificates in Postgres 9.3 and Windows 7

On Mon, Nov 10, 2014 at 1:45 AM, David Johnston wrote: > Yes, that is what I was referring to. The Nabble.com website showed them. > > http://postgresql.1045698.n5.nabble.com/SSL-Certificates-in-Postgres-9-3-and-Windows-7-td5826230.html Then it's more logical. Nabble simply did not include that

Re: [GENERAL] Centos 7 - anyone?

I've found this very useful: http://people.planetpostgresql.org/devrim/index.php?/archives/82-Running-more-than-one-9.4-9.3-instance-in-parallel-on-RHEL-7.html Atenciosamente, Edson Carlos Ericksson Richter On 10-11-2014 16:45, Edson Richter wrote: Hi! I've just received a new server, and

[GENERAL] Centos 7 - anyone?

Hi! I've just received a new server, and I've the intention to install Centos7 and PostgreSQL 9.3.5. After installing the yum repo (as described in http://www.postgresql.org/download/linux/redhat/), I've installed everything I need with the command yum install postgresql93 postgresql93-serve

Re: [GENERAL] Strange avg value size for index on expression in pg_stats

On Mon, 10 Nov 2014 09:39:23 -0500 Tom Lane wrote: > Jehan-Guillaume de Rorthais writes: > > While investigating about a wrong result with my btree bloat estimation > > query, I found a strange stat deviation between the average size of a value > > in its table and its average size in one index

Re: [GENERAL] Strange avg value size for index on expression in pg_stats

Jehan-Guillaume de Rorthais writes: > While investigating about a wrong result with my btree bloat estimation query, > I found a strange stat deviation between the average size of a value in its > table and its average size in one index on the "lower" expression. ANALYZE doesn't look at the physi

Re: [GENERAL] Strange result using pg_dump gzip or split.

On 11/10/2014 03:34 AM, Condor wrote: Hello, I found strange result when I use pg_dump described on postgresql site: http://www.postgresql.org/docs/9.3/static/backup-dump.html I have a database with 30 gb data and decide to archive it, postgresql is 9.3.5 x64_86, ext4 file system, kernel 3.14.

Re: [GENERAL] Strange result using pg_dump gzip or split.

Followup, second try. First of all, I'd like to apologize to the list for my previous message, I borked some finger gymnastics when switching tabs and sent and incomplete one. My fault. Sorry. Now what I tried to say was: I did not spot it at first, looking at http://www.gzip.org/zlib/rfc-gzip.h

Re: [GENERAL] Strange result using pg_dump gzip or split.

Hi Condor. Followup, I did not spot it at first, looking at http://www.gzip.org/zlib/rfc-gzip.html#file-format I see: On Mon, Nov 10, 2014 at 12:34 PM, Condor wrote: > > Hello, > > I found strange result when I use pg_dump described on postgresql site: > http://www.postgresql.org/docs/9.3/stati

Re: [GENERAL] Strange result using pg_dump gzip or split.

Hi Condor. On Mon, Nov 10, 2014 at 12:34 PM, Condor wrote: > I have a database with 30 gb data and decide to archive it, postgresql is > 9.3.5 x64_86, ext4 file system, kernel 3.14.18 Slackware 14.2 (current) > You should have a look at your tools, it seems you have a file size problem >

Re: [GENERAL] justify_interval: days in year

On Mon, Nov 10, 2014 at 10:07 AM, Ilya Ashchepkov wrote: > Is this correct? > $ select > justify_interval(t-f-i) > ,t-f-i > from > ( > select > timestamp '2014-1-1' as f, > timestamp '2015-1-1' as t, > interval '06:49:00' as i > ) S; > > justify_interval|

Re: [GENERAL] Strange result using pg_dump gzip or split.

On 11/10/2014 3:34 AM, Condor wrote: Did the database dump is corrupt or not ? try restoring them to a new database -- john r pierce 37N 122W somewhere on the middle of the left coast -- Sent via pgsql-general mailing list (pgsql-general@postgresql

[GENERAL] Strange result using pg_dump gzip or split.

Hello, I found strange result when I use pg_dump described on postgresql site: http://www.postgresql.org/docs/9.3/static/backup-dump.html I have a database with 30 gb data and decide to archive it, postgresql is 9.3.5 x64_86, ext4 file system, kernel 3.14.18 Slackware 14.2 (current) Firs

Re: [GENERAL] Strange avg value size for index on expression in pg_stats

On Mon, 10 Nov 2014 11:52:54 +0100 Jehan-Guillaume de Rorthais wrote: > Hello, > > I'm not sure if I should post here or on pgsql-hackers. > > While investigating about a wrong result with my btree bloat estimation query, > I found a strange stat deviation between the average size of a value in

[GENERAL] Strange avg value size for index on expression in pg_stats

Hello, I'm not sure if I should post here or on pgsql-hackers. While investigating about a wrong result with my btree bloat estimation query, I found a strange stat deviation between the average size of a value in its table and its average size in one index on the "lower" expression. Take the fo

[GENERAL] justify_interval: days in year

Hello! Is this correct? $ select justify_interval(t-f-i) ,t-f-i from ( select timestamp '2014-1-1' as f, timestamp '2015-1-1' as t, interval '06:49:00' as i ) S; justify_interval| ?column? + 1 year 4 days 17:1