RES: [GENERAL] Trouble with regexp_matches

> -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

> -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

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

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

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

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

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

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

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

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

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.

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.

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

> 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

> 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

Dear community, Sorry if this is not the right place for proposing new features. Also, sorry if I'm proposing something already existing. I do currently use the "debug" extension to better understand the entrophy of my application regarding database. But in production this is not possible,

Re: [GENERAL] Uber migrated from Postgres to MySQL

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

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

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

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

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

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

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

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 with qry as ( select A.id from A where not exists (select 1 from B where B.a_id = A.id)

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

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

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

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

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

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

Hi! I have a database "Customer" with about 60Gb of data. I know I can backup and restore, but this seems too slow. Is there any other option to duplicate this database as "CustomerTest" as fast as possible (even fastar than backup/restore) - better if in one operation (something like "copy da

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

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

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

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 all to 9.4 yet is because I'm short on time). I've experienced some synchronization failures between Master-Slave servers

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

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

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(('//MyDocument[@DocNum = ''000411828'']'::text), xmlparse(document cdataout)); This is the error: ERRO: could not parse XML documen

Re: [GENERAL] PostgreSQL vs Firebird SQL

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

I've set statement timeout in postgresql.conf to 300s. Now, I have a schema update procedure at application startup I would like to run without timeout, or with significant larger timeout (let's say, 1s). It is possible to change statement timeout at runtime before issuing the command (fo

Re: [GENERAL] BDR and TX obeyance

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

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 seems not being actively maintained for a while now. Regards, Edson Atenciosamente, Edson Carlos E

Re: [GENERAL] BDR and TX obeyance

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 experimenting with BDR a

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

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

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

Hi! I do have several tables that uses varchar(2000) as store for remarks. Lately, one customer need to store more than 2000 characteres, and I'm considering changing from varchar(2000) to text. What is the overhead? Is there any place where I can learn about storage impacto for each data ty

Re: [GENERAL] PostgreSQL Timezone and Brazilian DST

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

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, in the timezone

Re: [GENERAL] PostgreSQL Timezone and Brazilian DST

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

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 have: timezone="America/Sao_Paulo" Since DST is in place in Brazil, it is enough to "systemctl reload postgresql-9.3" to make it effective? Or a comp

Re: [GENERAL] Replication with 9.4

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

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

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

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"

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 -- Sent via pgsql

Re: [GENERAL] archive_timeout and WAL size

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

Dear community, I'm using PostgreSQL 9.3.6 on Linux x64. Would sound a stupid questions, and sorry if it was already asked before: if I set the "archive_timeout", and then I have them sent every minute (for example), are the files still 16MB in size, or are they truncated and sent in smaller

Re: [GENERAL] Invalid memory alloc

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] Intermitent connection could corrupt slave database?

Hi, folks! I've a async master to slave database replication, both 9.3.5 running Oracle Linux 7 x64. Today, a intermitent link that ended with abrupt interruption, and made necessary to promote the slave database to master. After promotion, two medium databases (<5Gb) became active without iss

Re: [GENERAL] Can I unite 2 selects?

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"?

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 nec

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

Right, Tom! (again :-) ) Ubuntu is running 9.3.4 (I've installed 9.3.5 - but for some reason, it have not started). I suppose I'll uninstall 9.3.4 and then install 9.3.5. Since it is a development machine, I can do that safely. Thanks for your fast and precise answer, as always! Atenciosament

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

I do have two servers running 9.3.5. One server is CentOS 6.5 x64 with all updates. The other server is Ubuntu 14.04-1 x64 with all updates. Both run PostgreSQL 9.3.5 x64 - one installed using YUM, other with APT. When I compare source code of the same view, I get the following differences: *_

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 s

[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 : Re : [GENERAL] Query "top 10 and others"

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"

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"

(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?

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?

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?

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?

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?

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?

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?

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?

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?

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?

I'm curious about the "checkpointer" process and its configuration. What are the configuration options that affects the checkpointer process? Currently, under load, this process goes up to about 1.2GB of RAM: --

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

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?

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?

Hi! I would like to have a improved error message with column name. Today (9.2.3), I receive the following error: "ERROR: value too long for type character varying(20)" Why not this more intuitive error message: "ERROR: value too long for type character varying(20) at column XYZ" Since my t

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

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

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!

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!

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!

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!

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!

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!

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

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

[GENERAL] Transparent exchange BDE from Oracle to PostgreSQL

It is possible to put a PostgreSQL database in substitution of a Oracle database for an app running BDE? Any tips (beyond obvious "check Oracle specific funcionality")? Regards, Edson -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: h

Re: [GENERAL] Replicating SQL 2000 to PostgreSQL 9.x

Em 29/01/2014 12:42, Edson Richter escreveu: I'm trying to setup SQL 2000 replication to PostgreSQL 9.x, and follow those steps: 1) setup the publisher and distributor in SQL 2000 2) setup the article (12 tables) 3) setup the linked server to PostgreSQL and executed some queries to test

[GENERAL] Replicating SQL 2000 to PostgreSQL 9.x

I'm trying to setup SQL 2000 replication to PostgreSQL 9.x, and follow those steps: 1) setup the publisher and distributor in SQL 2000 2) setup the article (12 tables) 3) setup the linked server to PostgreSQL and executed some queries to test (with success) 4) created the 12 tables in PostgreSQ

Re: [GENERAL] A Simple web application

Em 27/01/2014 13:19, Raymond O'Donnell escreveu: On 27/01/2014 15:16, Edson Richter wrote: Em 27/01/2014 10:42, Andreas Kretschmer escreveu: Raymond O'Donnell wrote: On 27/01/2014 12:11, Manoj Soni wrote: Name, Age and Sex Which tutorial, may help me in this regard. I did a Goo

Re: [GENERAL] A Simple web application

already had lots of trouble with customers asking me to adjust my systems to this new "situation", then I've to change systems and database... Regards, Edson 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] ERROR: out of memory DETAIL: Failed on request of size ???

Em 19/11/2013 02:30, Brian Wong escreveu: I've tried any work_mem value from 1gb all the way up to 40gb, with no effect on the error. I'd like to think of this problem as a server process memory (not the server's buffers) or client process memory issue, primarily because when we tested the err

Re: [GENERAL] Browsing postgres database using the Eclipse QuantumDB plugin

Em 22/11/2013 12:54, Adrian Klaver escreveu: On 11/22/2013 05:46 AM, Mike Kienenberger wrote: Has anyone successfully connected and browsed a postgres database using the Eclipse QuantumDB plugin? You might get a answer sooner here: http://sourceforge.net/p/quantum/discussion/24178/ I can c

Re: [GENERAL] PG replication across DataCenters

Em 22/11/2013 08:43, Kaushal Shriyan escreveu: Hi, I have read on the web that Postgresql DB supports replication across data centers. Any real life usecase examples if it has been implemented by anyone. Please also help me understand the caveats i need to take care if i implement this setup.

Re: [GENERAL] Postgres as In-Memory Database?

Em 20/11/2013 01:30, Jeff Janes escreveu: On Tuesday, November 19, 2013, Edson Richter wrote: Em 19/11/2013 22:29, Jeff Janes escreveu: On Sun, Nov 17, 2013 at 4:46 PM, Edson Richter > wrote: Yes, those optimizations I was talking about: having database ser

Re: [GENERAL] Postgres as In-Memory Database?

Em 19/11/2013 22:29, Jeff Janes escreveu: On Sun, Nov 17, 2013 at 4:46 PM, Edson Richter mailto:edsonrich...@hotmail.com>> wrote: Yes, those optimizations I was talking about: having database server store transaction log in high speed solid state disks and consider it done

Re: [GENERAL] Postgres as In-Memory Database?

Em 17/11/2013 22:02, Gavin Flower escreveu: On 18/11/13 12:53, Stefan Keller wrote: Hi Martijn 2013/11/17 Martijn van Oosterhout > wrote: > If your dataset fits in memory then the problem is trivial: any decent > programming language provides you with all the necessar

Re: [GENERAL] Postgres as In-Memory Database?

Em 17/11/2013 20:46, Andreas Brandl escreveu: Edson, Em 17/11/2013 19:26, Stefan Keller escreveu: Hi Edson As Rob wrote: Having a feature like an in-memory table like SQLite has [1] would make application cahces obsoleteand interesting to discuss (but that was'nt exactly what I asked above).

Re: [GENERAL] Postgres as In-Memory Database?

cs/9.1/static/non-durability.html 2013/11/17 Edson Richter <mailto:edsonrich...@hotmail.com>> Em 17/11/2013 12:15, rob stone escreveu: On Sun, 2013-11-17 at 12:25 +0100, Stefan Keller wrote: How can Postgres be used and configured as an In-Memory Da

  1   2   3   >