RES: [GENERAL] Trouble with regexp_matches

2016-11-05 Thread Edson Richter
> -Mensagem original- > De: Adrian Klaver [mailto:adrian.kla...@aklaver.com] > Enviada em: sábado, 5 de novembro de 2016 15:13 > Para: Edson Richter ; pgsql- > gene...@postgresql.org > Assunto: Re: [GENERAL] Trouble with regexp_matches > > On 11/05/2016 10:01

RES: [GENERAL] Trouble with regexp_matches

2016-11-05 Thread Edson Richter
> -Mensagem original- > De: Tom Lane [mailto:t...@sss.pgh.pa.us] > Enviada em: sábado, 5 de novembro de 2016 15:21 > Para: Edson Richter > Cc: pgsql-general@postgresql.org > Assunto: Re: [GENERAL] Trouble with regexp_matches > > Edson Richter writes: > > I’

[GENERAL] Trouble with regexp_matches

2016-11-05 Thread Edson Richter
ere codigoocorrencia = '091' and observacao is not null order by datahoraimportacao DESC Total results = 3826 Why is that? Regards, Edson Richter

Re: [GENERAL] Installing pgAdmin 4 in Oracle Enterprise Linux 7

2016-10-05 Thread Edson Richter
Devrim Gündüz escreveu > Hi again, > > On Mon, 2016-10-03 at 00:18 +0000, Edson Richter wrote: > > It is not working, I get the following error: > > > > [root@backup1 yum.repos.d]# LANG=C yum install pgadmin4 pgadmin4-web > > Loaded plugins: ulninfo >

Re: [GENERAL] Installing pgAdmin 4 in Oracle Enterprise Linux 7

2016-10-04 Thread Edson Richter
uires: libpython2.7_d.so.1.0()(64bit) You could try using --skip-broken to work around the problem You could try running: rpm -Va --nofiles --nodigest If I can help on anything, please let me know. Regards, Edson De: pgsql-general-ow...@postgresql.org

Re: [GENERAL] Installing pgAdmin 4 in Oracle Enterprise Linux 7

2016-10-04 Thread Edson Richter
Please, ignore this double post. It came from wrong e-mail address. The issue is already being discussed in another discussion thread.

[GENERAL] Installing pgAdmin 4 in Oracle Enterprise Linux 7

2016-10-03 Thread Edson Richter
ork around the problem You could try running: rpm -Va --nofiles --nodigest" (the "LANG=C" at beginning of the line is to force output in english, please ignore it) Have anyone faced similar issue or know how to correct this error? Thanks in advance, Edson Richter

Re: [GENERAL] Installing pgAdmin 4 in Oracle Enterprise Linux 7

2016-10-03 Thread Edson Richter
On 03/10/2016 10:12, Devrim Gündüz wrote: > Hi Edson, > > On Mon, 2016-10-03 at 00:18 +0000, Edson Richter wrote: >> https://download.postgresql.org/pub/repos/yum/testing/9.6/redhat/rhel-7Server >> -x86_64/repodata/repomd.xml: >> [Errno 14] HTTPS Error 404 - Not F

Re: [GENERAL] Installing pgAdmin 4 in Oracle Enterprise Linux 7

2016-10-02 Thread Edson Richter
On 02/10/2016 17:04, Devrim Gündüz wrote: > Hi, > > On Sun, 2016-10-02 at 17:52 +0000, Edson Richter wrote: >> I'm trying to install pgAdmin4 in Oracle EL 7. >> >> I've already installed PostgreSQL 9.6 final in same server (have EPEL >> enabled, as well

Re: [GENERAL] Installing pgAdmin 4 in Oracle Enterprise Linux 7

2016-10-02 Thread Edson Richter
On 02/10/2016 16:05, Adrian Klaver wrote: > On 10/02/2016 10:52 AM, Edson Richter wrote: >> Dear community, >> >> >> I'm trying to install pgAdmin4 in Oracle EL 7. >> >> I've already installed PostgreSQL 9.6 final in same server (have EPEL >&g

[GENERAL] Installing pgAdmin 4 in Oracle Enterprise Linux 7

2016-10-02 Thread Edson Richter
ork around the problem You could try running: rpm -Va --nofiles --nodigest" (the "LANG=C" at beginning of the line is to force output in english, please ignore it) Have anyone faced similar issue or know how to correct this error? Thanks in advance, Edson Richter

Re: [GENERAL] IDE for function/stored proc development.

2016-09-06 Thread Edson Richter
I do use Dbwrench, but is pretty basic, no fancy procedures / function development support. Enviado do meu smartphone Sony Xperia™ Pavel Stehule escreveu Hi 2016-09-03 11:36 GMT+02:00 Tim Uckun : > Does anybody use an IDE for doing heavy duty stored proc development? > PGadmin is de

Re: [GENERAL] IDE for function/stored proc development.

2016-09-06 Thread Edson Richter
quot;since date... ", "from date ..." or "planned" status... You can split the table by bundle (basic /enterprise) so you will help your visitors to better understand your offer... Just my 2c. Sorry for being off topic... Edson Richter

Re: [GENERAL] Proposal "stack trace" like debugging option in PostgreSQL

2016-07-31 Thread Edson Richter
> From: t...@sss.pgh.pa.us > To: edsonrich...@hotmail.com > CC: pgsql-general@postgresql.org > Subject: Re: [GENERAL] Proposal "stack trace" like debugging option in > PostgreSQL > Date: Sun, 31 Jul 2016 11:56:11 -0400 > > Edson Richter writes: > > But

Re: [GENERAL] Proposal "stack trace" like debugging option in PostgreSQL

2016-07-31 Thread Edson Richter
> Subject: Re: [GENERAL] Proposal "stack trace" like debugging option in > PostgreSQL > To: edsonrich...@hotmail.com; pgsql-general@postgresql.org > From: adrian.kla...@aklaver.com > Date: Sat, 30 Jul 2016 15:26:42 -0700 > > On 07/30/2016 10:52 AM, Edson Ri

[GENERAL] Proposal "stack trace" like debugging option in PostgreSQL

2016-07-30 Thread Edson Richter
ists, please kindly point me to the docs. If not, please consider adding this in a future release. Thanks, -- Atenciosamente, Edson Carlos Ericksson Richter -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Uber migrated from Postgres to MySQL

2016-07-28 Thread Edson Richter
efore decided to migrate all systems to PostgreSQL. My personal experience is that MySQL is excellent for data that is not sensitive (web site, e-mail settings, etc). Everything else goes to PostgreSQL (or Oracle, or MS SQL Server, or Sybase, or DB2 - in *my* order of preference). Regards, Edson Richter

Re: [GENERAL] Index seems "lost" after consecutive deletes

2016-06-15 Thread Edson Richter
Em 14/06/2016 12:02, Edson Richter escreveu: Em 14/06/2016 10:32, David G. Johnston escreveu: On Tue, Jun 14, 2016 at 12:51 AM, Edson Richter wrote: Em 14/06/2016 01:33, David G. Johnston escreveu: On Monday, June 13, 2016, Edson Richter mailto:edsonrich...@hotmail.com>>

Re: [GENERAL] Index seems "lost" after consecutive deletes

2016-06-14 Thread Edson Richter
Em 14/06/2016 10:32, David G. Johnston escreveu: On Tue, Jun 14, 2016 at 12:51 AM, Edson Richter mailto:edsonrich...@hotmail.com>>wrote: Em 14/06/2016 01:33, David G. Johnston escreveu: On Monday, June 13, 2016, Edson Richter mailto:edsonrich...@hotmail.com>> wrote:

Re: [GENERAL] Index seems "lost" after consecutive deletes

2016-06-13 Thread Edson Richter
Em 14/06/2016 01:33, David G. Johnston escreveu: On Monday, June 13, 2016, Edson Richter <mailto:edsonrich...@hotmail.com>> wrote: Em 13/06/2016 23:36, Edson Richter escreveu: Em 13/06/2016 23:18, rob stone escreveu: On Mon, 2016-06-13 at 22:41 -0300, Edson Richter wrote

Re: [GENERAL] Index seems "lost" after consecutive deletes

2016-06-13 Thread Edson Richter
Em 13/06/2016 23:36, Edson Richter escreveu: Em 13/06/2016 23:18, rob stone escreveu: On Mon, 2016-06-13 at 22:41 -0300, Edson Richter wrote: Em 13/06/2016 22:33, Edson Richter escreveu: I've a table "A" with 4,000,000 records. I've decided to delete records from oldest t

Re: [GENERAL] Index seems "lost" after consecutive deletes

2016-06-13 Thread Edson Richter
Em 13/06/2016 23:18, rob stone escreveu: On Mon, 2016-06-13 at 22:41 -0300, Edson Richter wrote: Em 13/06/2016 22:33, Edson Richter escreveu: I've a table "A" with 4,000,000 records. I've decided to delete records from oldest to newest but I can't delete records that

Re: [GENERAL] Index seems "lost" after consecutive deletes

2016-06-13 Thread Edson Richter
Em 13/06/2016 22:33, Edson Richter escreveu: I've a table "A" with 4,000,000 records. I've decided to delete records from oldest to newest but I can't delete records that have references in tables "B", "C" or "D". so, I've

[GENERAL] Index seems "lost" after consecutive deletes

2016-06-13 Thread Edson Richter
ced records can be in my deletion. Has anyone faced a behavior like this? Am I doing something wrong? -- Atenciosamente, Edson Carlos Ericksson Richter -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Columnar store as default for PostgreSQL 10?

2016-05-17 Thread Edson Richter
jects at programming side, and ORM works just so well, it is a really waste of time (and other resources) to change systems that are working well in the past 10 or more years. Just my 2c, Edson Richter -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

Re: [GENERAL] Fastest way to duplicate a quite large database

2016-04-13 Thread Edson Richter
Em 13/04/2016 11:18, Adrian Klaver escreveu: On 04/13/2016 06:58 AM, Edson Richter wrote: Another trouble I've found: I've used "pg_dump" and "pg_restore" to create the new CustomerTest database in my cluster. Immediately, replication started to replicate the

Re: [GENERAL] Fastest way to duplicate a quite large database

2016-04-13 Thread Edson Richter
Em 12/04/2016 12:53, Edson Richter escreveu: *De: *Adrian Klaver <mailto:adrian.kla...@aklaver.com> *Enviado:*terça-feira, 12 de abril de 2016 12:04 *Para: *Edson Richter <mailto:edsonrich...@hotmail.com>; pgsql-general@postgresql.org <mailto:pgsql-general@postgresql.org&

RES: [GENERAL] Fastest way to duplicate a quite large database

2016-04-12 Thread Edson Richter
De: Adrian Klaver Enviado:terça-feira, 12 de abril de 2016 12:04 Para: Edson Richter; pgsql-general@postgresql.org Assunto: Re: [GENERAL] Fastest way to duplicate a quite large database On 04/12/2016 07:51 AM, Edson Richter wrote: > Same machine, same cluster - just different database name.

Re: [GENERAL] Fastest way to duplicate a quite large database

2016-04-12 Thread Edson Richter
Same machine, same cluster - just different database name. Atenciosamente, Edson Carlos Ericksson Richter Em 12/04/2016 11:46, John R Pierce escreveu: On 4/12/2016 7:25 AM, Edson Richter wrote: I have a database "Customer" with about 60Gb of data. I know I can backup and restore

[GENERAL] Fastest way to duplicate a quite large database

2016-04-12 Thread Edson Richter
something like "copy database A to B")? I would like to run this everyday, overnight, with minimal impact to prepare a test environment based on production data. Thanks, -- Atenciosamente, Edson Carlos Ericksson Richter -- Sent via pgsql-general mailing list (pgsql-general@postgresq

Re: [GENERAL] Best approach for multi-database system

2016-03-10 Thread Edson Richter
Em 10/03/2016 17:18, Andy Colson escreveu: please don't top post. > Em 10/03/2016 16:56, Andy Colson escreveu: On 3/10/2016 1:41 PM, Edson Richter wrote: Hi! Using async replication between geographically database servers. I've some 9.3 and some 9.4 servers, so doesn't matte

Re: [GENERAL] Best approach for multi-database system

2016-03-10 Thread Edson Richter
Carlos Ericksson Richter Em 10/03/2016 16:56, Andy Colson escreveu: On 3/10/2016 1:41 PM, Edson Richter wrote: Hi! Using async replication between geographically database servers. I've some 9.3 and some 9.4 servers, so doesn't matter the version (the only reason I've not migrated al

[GENERAL] Best approach for multi-database system

2016-03-10 Thread Edson Richter
r multi-database systems with async replication to avoid such "resync" problems? Thanks for your orientation, -- Atenciosamente, Edson Carlos Ericksson Richter -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] XMLEXISTS on legacy XML with malformed xmlns

2016-02-12 Thread Edson Richter
2016-02-12 1:53 GMT+01:00 Edson Richter <mailto:edsonrich...@hotmail.com>>: Hi! I've some (about 1M records) containing legacy XML I would like to parse and apply XMLEXISTS. This is the query: select * from xmllog where xpath_exists(('/

[GENERAL] XMLEXISTS on legacy XML with malformed xmlns

2016-02-11 Thread Edson Richter
0 I can easly read this XML in Notepad++, and also in Java - but PostgreSQL always throw error. Can you plase tell me how can make PostgreSQL ignore this malformed xmlns and proceed processing the XML? Thanks, -- Atenciosamente, Edson Carlos Ericksson Richter -- Sent via p

Re: [GENERAL] PostgreSQL vs Firebird SQL

2016-02-10 Thread Edson Richter
aditional DBA interference. Also, the tooling to help planning indices and test query performance is really good, and the PgAdmin III has been good and quite strong (has some flaws, but nothing that really interfere in its usage). Regards, Edson Richter -- Sent via pgsql-general ma

[GENERAL] Statement timeout

2016-01-29 Thread Edson Richter
; cn.commit(); Something like that (I know sql syntax is wrong, this is just a lazy example)... -- Atenciosamente, Edson Carlos Ericksson Richter -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] BDR and TX obeyance

2016-01-05 Thread Edson Richter
Em 05/01/2016 11:42, Riley Berton escreveu: Edson Richter writes: BTW, I'm also looking for a "synchronous multi-master" solution... If you find one, please share :-) The only solution I've found so far is a middleware that is close, the C-Jdbc/Sequoia, which seem

Re: [GENERAL] BDR and TX obeyance

2016-01-04 Thread Edson Richter
mente, Edson Carlos Ericksson Richter Em 04/01/2016 18:09, Riley Berton escreveu: I have been experimenting with BDR and have a question about how BDR interacts with transactions. bdrdemo=# create table thingy (id INT, value TEXT, PRIMARY KEY(id)); CREATE TABLE bdrdemo=# create table tx_log(id IN

Re: [GENERAL] BDR and TX obeyance

2016-01-04 Thread Edson Richter
I think this is the nature of "async multi master"... IMHO, It would be necessary to be "sync multi master" (with two-phase commit?) to get the behavior you expect. Atenciosamente, Edson Carlos Ericksson Richter Em 04/01/2016 18:09, Riley Berton escreveu: I have been ex

Re: [GENERAL] Overhead changing varchar(2000) to text

2015-12-15 Thread Edson Richter
Em 15/12/2015 00:27, Jim Nasby escreveu: On 12/9/15 5:43 PM, Edson Richter wrote: Actually, the biggest change is that I don't have to keep another constraint between app and database - if I want to increase the user perceived space, now I just have to change the application (of course,

Re: [GENERAL] Overhead changing varchar(2000) to text

2015-12-09 Thread Edson Richter
to change the application (of course, under the limits). Atenciosamente, Edson Carlos Ericksson Richter Em 09/12/2015 21:17, Kevin Grittner escreveu: On Wed, Dec 9, 2015 at 5:13 PM, Edson Richter wrote: I do have several tables that uses varchar(2000) as store for remarks. Lately, one cus

[GENERAL] Overhead changing varchar(2000) to text

2015-12-09 Thread Edson Richter
data type? Thanks, -- Atenciosamente, Edson Carlos Ericksson Richter -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] PostgreSQL Timezone and Brazilian DST

2015-10-28 Thread Edson Richter
Perfect explanation and indeed useful suggestions. I'll play a bit with a development server. Thanks, Atenciosamente, Edson Carlos Ericksson Richter Em 28/10/2015 12:15, Yves Dorfsman escreveu: On 2015-10-27 20:29, Edson Richter wrote: Hi! Using PostgreSQL 9.3.10 x86_64 Oracle EL7 com

Re: [GENERAL] PostgreSQL Timezone and Brazilian DST

2015-10-28 Thread Edson Richter
Thanks, Tom. I'll play a bit with this in a development server. Regards, Atenciosamente, Edson Carlos Ericksson Richter Em 28/10/2015 12:06, Tom Lane escreveu: Adrian Klaver writes: No, if the above does not indicate a problem, then the issue is probably, as Francisco said, i

Re: [GENERAL] PostgreSQL Timezone and Brazilian DST

2015-10-27 Thread Edson Richter
Adrian Klaver escreveu > On 10/27/2015 07:29 PM, Edson Richter wrote: > > Hi! > > > > Using PostgreSQL 9.3.10 x86_64 Oracle EL7 compiled by gcc (GCC) 4.8.3 > > 20140911, installed using yum repository. > > > > In postgresql.conf, I do ha

[GENERAL] PostgreSQL Timezone and Brazilian DST

2015-10-27 Thread Edson Richter
it effective? Or a complete restart is required? Thanks, -- Atenciosamente, Edson Carlos Ericksson Richter -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Replication with 9.4

2015-10-03 Thread Edson Richter
Madovsky escreveu > Hi, > > I would like to fix a issue I'm facing of with the version 9.4 streaming > replication. > is it possible to set on the fly the synchronous commit on the master > (or standby?) > which only sync commit the hot standby node used by the client who has a > r

[GENERAL] Grouping sets, cube and rollup

2015-08-25 Thread Edson Richter
Any chance to get those amazing wonderful features backported to 9.4? Thanks, Edson Enviado do meu smartphone Sony Xperia™

Re: [GENERAL] Sync replication + high latency server

2015-08-13 Thread Edson Richter
Em 13/08/2015 00:40, Joshua D. Drake escreveu: On 08/12/2015 05:33 PM, Edson Richter wrote: Hi! I've a situation where I would like to keep sync replication, where servers have 10Mbps network connection but high latency (normally, ~20ms but sometimes, 1000ms~2000ms, even 3000ms when ne

[GENERAL] Sync replication + high latency server

2015-08-12 Thread Edson Richter
Hi! I've a situation where I would like to keep sync replication, where servers have 10Mbps network connection but high latency (normally, ~20ms but sometimes, 1000ms~2000ms, even 3000ms when network is under load). Considering that I will keep enough WAL files (let's say, 200 WAL segments on a

[GENERAL] WAL archive "resend policy"

2015-06-29 Thread Edson Richter
Dear all, Another question about WAR archiving: what is the "resend policy" if remote storage runs out of space? The failed archives will be resend automatically in future, or there is need for manual interation? Thanks, -- Atenciosamente, Edson Carlos Ericksson Richter -

Re: [GENERAL] archive_timeout and WAL size

2015-06-29 Thread Edson Richter
Thanks, Adrian. That's the reference I was looking for. Atenciosamente, Edson Carlos Ericksson Richter Em 29/06/2015 15:55, Adrian Klaver escreveu: On 06/29/2015 11:49 AM, Edson Richter wrote: Dear community, I'm using PostgreSQL 9.3.6 on Linux x64. Would sound a stupid ques

[GENERAL] archive_timeout and WAL size

2015-06-29 Thread Edson Richter
sent in smaller sizes as well? I've not found this information in docs. Thanks, -- Atenciosamente, Edson Carlos Ericksson Richter -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Invalid memory alloc

2015-04-23 Thread Edson Richter
On 23-04-2015 16:55, Marc-André Goderre wrote: Hello, I'm processing a 100Million row table. I get error message about memory and I'ld like to know what can cause this issue. ... psql:/home/ubuntu/create_topo.sql:12: NOTICE: 104855000 edges processed psql:/home/ubuntu/create_topo.sql:12: NOTI

[GENERAL] Has anyone used C-JDBC, HA-JDBC or SymmetricDB with PostgreSQL?

2015-04-11 Thread Edson Carlos Ericksson Richter
Hi, Could anyone share experiences on using C-JDBC, HA-JDBC or SymmetricDB to create a PostgreSQL cluster environment on distributed (different geo locations)? Thanks, Edson -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://

[GENERAL] Intermitent connection could corrupt slave database?

2015-04-10 Thread Edson Richter
if this "intermitent link" scenario is already covered (perhaps in later releases), or this is something we cannot foresee/deal with? -- Atenciosamente, Edson Carlos Ericksson Richter -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Can I unite 2 selects?

2015-01-29 Thread Edson Richter
You mean union? select 1 as t1 union select 2 as t2 union select 3 as t3 ? Atenciosamente, Edson Carlos Ericksson Richter On 29-01-2015 16:58, Sterpu Victor wrote: Hello Can I write a query where I receive a single result set from many queries? Something like this: SELECT (SELECT 1 AS t1, 2

Re: [GENERAL] Replication: How to query current segments allocation relative to "Wal keep segments"?

2015-01-05 Thread Edson Richter
On 05-01-2015 10:02, Michael Paquier wrote: On Mon, Jan 5, 2015 at 6:51 PM, Edson Carlos Ericksson Richter wrote: Would this kind of count being recorded somewhere else? How does the server knows that the wal_segments have been exhausted? You should evaluate the amount of wal_keep_segments

Re: [GENERAL] Replication: How to query current segments allocation relative to "Wal keep segments"?

2015-01-05 Thread Edson Carlos Ericksson Richter
On 05-01-2015 02:08, Michael Paquier wrote: On Sun, Jan 4, 2015 at 1:48 AM, Edson Carlos Ericksson Richter wrote: How to query current segments allocation relative to "Wal keep segments" in each master server? What is your server version? You can have a look at pg_stat_replicat

[GENERAL] Replication: How to query current segments allocation relative to "Wal keep segments"?

2015-01-03 Thread Edson Carlos Ericksson Richter
I'm maintaining async replication (streaming) between four database servers arranged on 2 x 2. How to query current segments allocation relative to "Wal keep segments" in each master server? I want to add this query to Postbix in order to monitor if the "wal keep segments" parameter is too shor

Re: [GENERAL] pg_base_backup limit bandwidth possible?

2015-01-03 Thread Edson Carlos Ericksson Richter
I've limited bandwidth consumption to 10Mbps. Atenciosamente, Edson Richter On 02-01-2015 19:28, Matthew Kelly wrote: The way I’ve solved the problem before 9.4 is to use a command called 'pv' (pipe view). Normally this command is useful for seeing the rate of data flow in

[GENERAL] pg_base_backup limit bandwidth possible?

2014-12-29 Thread Edson Carlos Ericksson Richter
Hi! I could not find in docs, is there any way to limit pg_base_backup bandwidth usage? Thanks, Edson -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] How to install pgAdmin 1.20 on Mint Rebecca?

2014-12-26 Thread Edson Carlos Ericksson Richter
On 26-12-2014 22:13, Adrian Klaver wrote: On 12/26/2014 02:16 PM, Edson Carlos Ericksson Richter wrote: Yes, building from sources worked flawlessly, even for me (I'm not kind a "build C apps from sources" guy). Great that it worked for you. I have had issues with the wx

Re: [GENERAL] How to install pgAdmin 1.20 on Mint Rebecca?

2014-12-26 Thread Edson Carlos Ericksson Richter
Yes, building from sources worked flawlessly, even for me (I'm not kind a "build C apps from sources" guy). Regards, Edson On 26-12-2014 17:15, Adrian Klaver wrote: On 12/26/2014 10:41 AM, Edson Carlos Ericksson Richter wrote: Can someone point simple instructions on how to

[GENERAL] How to install pgAdmin 1.20 on Mint Rebecca?

2014-12-26 Thread Edson Carlos Ericksson Richter
Can someone point simple instructions on how to install pgAdmin 1.20 on Linux Mint Rebecca (17.1 - based on Ubuntu trusty)? Thanks, Edson Richter -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

[GENERAL] Database and OS monitoring

2014-12-13 Thread Edson Carlos Ericksson Richter
Dear list, I've been searching in web for guidelines on OS (Linux) and PostgreSQL (9.3.5) active monitoring best practices. Can someone share experiences? I'm inclined to look at Cacti and Nagios. Any other experiences? Recommended books? I don't want to use SaaS for monitoring - I'll have a c

Re: [GENERAL] Divergences in view source code - both servers 9.3.5

2014-12-08 Thread Edson Richter
as always! Atenciosamente, Edson Carlos Ericksson Richter On 08-12-2014 16:53, Tom Lane wrote: select version() -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Divergences in view source code - both servers 9.3.5

2014-12-08 Thread Edson Richter
t;, '1. nfe'::text as "tipo", ( select sum(arquivosimportados.contasucesso) as sum Why does the same CREATE VIEW statement result in different source codes in the server side? Regards, -- Atenciosamente, Edson Carlos Ericksson Richter

Re: [GENERAL] Centos 7 - anyone?

2014-11-10 Thread Edson Richter
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 s

[GENERAL] Centos 7 - anyone?

2014-11-10 Thread Edson Richter
e for path and other things. Can anyone point me what I've done wrong? Thanks,| -- Atenciosamente, Edson Carlos Ericksson Richter

Re: [GENERAL] Why isn't Java support part of Postgresql core?

2014-09-18 Thread Edson Carlos Ericksson Richter
On 18-09-2014 17:58, cowwoc wrote: On 18/09/2014 4:26 PM, David G Johnston [via PostgreSQL] wrote: ​ "only PostgreSQL uses it" ... PostgreSQL doesn't use Java. I don't think it makes a difference from a licensing point of view. The point is that the JRE is not used to run multiple distinct

[GENERAL] After upgrade from 9.2.9 to 9.3.5 got reduced contention

2014-09-13 Thread Edson Carlos Ericksson Richter
After a week or so since upgrade from 9.2.9 to 9.3.5 I'm very surprised (in a good way) by the gain of performance. Most noticeable change is the reduced contention for records by exclusive/shared locks. I can see increased numbers of requests fulfilled per minute (but I can't be exact on th

Re: [GENERAL] Any experiences running PostgreSQL 9.3.5 on compressed Btrfs on Linux?

2014-09-13 Thread Edson Carlos Ericksson Richter
- Hash: SHA1 On 09/13/2014 08:24 AM, Edson Carlos Ericksson Richter wrote: Any experiences running PostgreSQL 9.3.5 on compressed Btrfs on Linux? Yes. It ran great for over a month but once we had some serious data in it (multiple terrabytes) it died, more than once, and the last time was

[GENERAL] Any experiences running PostgreSQL 9.3.5 on compressed Btrfs on Linux?

2014-09-13 Thread Edson Carlos Ericksson Richter
Any experiences running PostgreSQL 9.3.5 on compressed Btrfs on Linux? Thanks, Edson -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re : Re : [GENERAL] Query "top 10 and others"

2014-07-05 Thread Edson Richter
Thanks!I'll investigate (explain) performance for both versions. Atenciosamente,Edson Richter -- Mensagem original --De: David Johnston Data: 04/07/2014 21h20Para: Edson Richter;Cc:pgsql-general@postgresql.org;Assunto:Re: Re : [GENERAL] Query "top 10 and others"> with

Re : [GENERAL] Query "top 10 and others"

2014-07-04 Thread Edson Richter
Would you please provide an example, even hypothetical?  Atenciosamente,Edson Richter -- Mensagem original --De: David G Johnston Data: 04/07/2014 19h22Para: pgsql-general@postgresql.org;Assunto:Re: [GENERAL] Query "top 10 and others"Edson Richter wrote > I would like to cons

[GENERAL] Query "top 10 and others"

2014-07-04 Thread Edson Richter
(select 1 from QRY where country = QRY.country and state = QRY.state) Can I simplify the query by using some sort of window function or other PostgreSQL feature I don't know yet? Thanks, Edson Richter

Re: Re : [GENERAL] Global value/global variable?

2014-06-19 Thread Edson Richter
hu, 19 Jun 2014 14:39:45 + Yes. It's similar, but consider I'm using a connection pool, so I''ve no control on when the connections are established/destroyed.I think I need something with scope broader than session... Atenciosamente, Edson Richter -- Mensagem origi

Re : [GENERAL] Global value/global variable?

2014-06-19 Thread Edson Richter
Yes. It's similar, but consider I'm using a connection pool, so I''ve no control on when the connections are established/destroyed.I think I need something with scope broader than session... Atenciosamente,Edson Richter -- Mensagem original --De: John McKownData: 19/06/

[GENERAL] Global value/global variable?

2014-06-18 Thread Edson Richter
It is possible to define a global value/variable in PostgreSQL in a way that I can use it in any query/view/function?For example, I do have a connection string I use for dblink connections in several places (specially, inside views).Then, if I want to change the connection string, I do have to c

Re: [GENERAL] Backups over slave instead master?

2014-05-02 Thread Edson Richter
Em 01/05/2014 16:39, bricklen escreveu: On Thu, May 1, 2014 at 8:54 AM, Shaun Thomas <mailto:stho...@optionshouse.com>> wrote: On 05/01/2014 10:31 AM, Edson Richter wrote: I'm wondering if would be possible to execute these backups in the slave serv

[GENERAL] Backups over slave instead master?

2014-05-01 Thread Edson Richter
I've a basic setup with async replication between two distant, geographically separated servers over vpn. Replication happens every 0.5 seconds or so, and is incredible reliable. Today, I've been using backup on master server every twelve hours. I'm wondering if would be possible to execute these

Re: [GENERAL] Select max(id) causes AccessExclusiveLock?

2014-04-28 Thread Edson Richter
Em 28/04/2014 12:01, Tom Lane escreveu: Edson Richter writes: When I issue a select max(id) from MyTableName Postgres 9.2.7 is scaling a AccessExclusiveLock and causing large delays. Really? regression=# create table MyTableName ( regression(#id integer not null primary key, regression

[GENERAL] Select max(id) causes AccessExclusiveLock?

2014-04-28 Thread Edson Richter
On table create table MyTableName ( id integer not null primary key, seqYear char(4), seqCount integer, ...) Where id is primary key and (seqYear, seqCount) is a unique index. Table facts: about 40 fields, 1 million records. When I issue a select max(id) from MyTableName Postgres 9.2

Re: [GENERAL] Why does "checkpointer" is consumig ~1.2Gb of RAM?

2014-03-31 Thread Edson Richter
now I understand. Regards, Edson On Mon, Mar 31, 2014 at 1:44 PM, Edson Richter <edsonrich...@hotmail.com> wrote: Em 31/03/2014 00:38, Scott Marlo

Re: [GENERAL] Why does "checkpointer" is consumig ~1.2Gb of RAM?

2014-03-31 Thread Edson Richter
Em 31/03/2014 00:38, Scott Marlowe escreveu: On Sun, Mar 30, 2014 at 8:43 PM, Edson Richter <edsonrich...@hotmail.com> wrote: I'm curious about the "checkpoin

[GENERAL] Why does "checkpointer" is consumig ~1.2Gb of RAM?

2014-03-30 Thread Edson Richter
ut 1.2GB of RAM: -- Edson Carlos Ericksson Richter Sistemas para Bibliotecas, Escolinhas Infantis Projetos sob medida para sua empresa Celular: (51) 9318-9766

Re: [GENERAL] Add column name to error message?

2014-03-18 Thread Edson Richter
Em 18/03/2014 17:44, Tom Lane escreveu: Edson Richter writes: Em 18/03/2014 17:17, Francisco Olarte escreveu: Maybe they are not hiding it, but the error is raised by a value checking routine which does not know where the value comes from / goes to ( ie, it's a 'check_varchar(

Re: [GENERAL] Add column name to error message?

2014-03-18 Thread Edson Richter
Em 18/03/2014 17:17, Francisco Olarte escreveu: Hi: On Tue, Mar 18, 2014 at 8:22 PM, Edson Richter mailto:edsonrich...@hotmail.com>> wrote: Since my table can have more than one "character varying(20)" inside, would be useful to know which one has throw the error...

[GENERAL] Add column name to error message?

2014-03-18 Thread Edson Richter
XYZ" Since my table can have more than one "character varying(20)" inside, would be useful to know which one has throw the error... Is there any reasoning (security, perhaps) for hiding column name in the error? Thanks, -- *Edson Carlos Ericksson Richter* /Sistemas para Bi

Re: [GENERAL] Help with connection issue - started today

2014-02-06 Thread Edson Richter
wrong database server reference - the reason that made Tomcat to start considering that file is a mystery to me, but removing the file, it became normal again. Regards, Edson On Wed, 2014-02-05 at 09:21 -0200, Edson Richter wrote: Dear all, I need your advise. Found a tricky situation. Without

[GENERAL] Help with connection issue - started today

2014-02-06 Thread Edson Richter
Dear all, I need your advise. Found a tricky situation. Without any changes in the configuration files, a **local** connection to a local VPN IP address could not be established with the following error: 2014-02-05 09:12:21.111 - x - org.postgresql.util.PSQLException: ERROR: could not est

Re: [GENERAL] Connection problems - local IP address refused!

2014-02-05 Thread Edson Richter
Em 05/02/2014 15:08, Adrian Klaver escreveu: On 02/05/2014 08:53 AM, Edson Richter wrote: Em 05/02/2014 13:03, Adrian Klaver escreveu: On 02/05/2014 05:43 AM, Edson Richter wrote: Em 05/02/2014 11:12, Alban Hertroys escreveu: Are you connecting to the correct host? On 5 February 2014 12:37

Re: [GENERAL] Connection problems - local IP address refused!

2014-02-05 Thread Edson Richter
Em 05/02/2014 11:51, rob stone escreveu: O n Wed, 2014-02-05 at 09:37 -0200, Edson Richter wrote:W ithout any changes in the configuration files, a **local** connection to a local VPN IP address could not be established with the following error: The error (JDBC connection using driver version

Re: [GENERAL] Connection problems - local IP address refused!

2014-02-05 Thread Edson Richter
Em 05/02/2014 15:08, Adrian Klaver escreveu: On 02/05/2014 08:53 AM, Edson Richter wrote: Em 05/02/2014 13:03, Adrian Klaver escreveu: On 02/05/2014 05:43 AM, Edson Richter wrote: Em 05/02/2014 11:12, Alban Hertroys escreveu: Are you connecting to the correct host? On 5 February 2014 12:37

Re: [GENERAL] Connection problems - local IP address refused!

2014-02-05 Thread Edson Richter
Em 05/02/2014 13:03, Adrian Klaver escreveu: On 02/05/2014 05:43 AM, Edson Richter wrote: Em 05/02/2014 11:12, Alban Hertroys escreveu: Are you connecting to the correct host? On 5 February 2014 12:37, Edson Richter wrote: Without any changes in the configuration files, a **local

Re: [GENERAL] Connection problems - local IP address refused!

2014-02-05 Thread Edson Richter
Em 05/02/2014 11:12, Alban Hertroys escreveu: Are you connecting to the correct host? On 5 February 2014 12:37, Edson Richter wrote: Without any changes in the configuration files, a **local** connection to a local VPN IP address could not be established with the following error: The error

[GENERAL] Connection problems - local IP address refused!

2014-02-05 Thread Edson Richter
Dear all, I need your advise. Found a tricky situation. Without any changes in the configuration files, a **local** connection to a local VPN IP address could not be established with the following error: _*The error (JDBC connection using driver version 1002):*_ 2014-02-05 09:12:21.111 -

Re: [GENERAL] Transparent exchange BDE from Oracle to PostgreSQL

2014-02-02 Thread Edson Richter
Em 02/02/2014 04:24, John R Pierce escreveu: On 2/1/2014 4:26 PM, Adrian Klaver wrote: On 02/01/2014 03:26 PM, John R Pierce wrote: On 2/1/2014 3:18 PM, Edson Richter wrote: It is possible to put a PostgreSQL database in substitution of a Oracle database for an app running BDE? Any tips

  1   2   3   4   >