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 <edsonrich...@hotmail.com>; pgsql- > gene...@postgresql.org > Assunto: Re: [GENERAL] Trouble with regexp_matches >

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 <edsonrich...@hotmail.com> > Cc: pgsql-general@postgresql.org > Assunto: Re: [GENERAL] Trouble with regexp_matches >

[GENERAL] Trouble with regexp_matches

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

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

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

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 pgdg 9.6 r

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

[GENERAL] Installing pgAdmin 4 in Oracle Enterprise Linux 7

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

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 <edsonrich...@hotma

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

Re: [GENERAL] Uber migrated from Postgres to MySQL

"lost FK integrity hell" (caused by the problem above) with MySQL long before 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 <edsonrich...@hotmail.com>wrote: Em 14/06/2016 01:33, David G. Johnston escreveu: On Monday, June 13, 2016, Edson Richter <

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 <edsonrich...@hotmail.com <mailto:edsonrich...@hotmail.com>>wrote: Em 14/06/2016 01:33, David G. Johnston escreveu: On Monday, June 13, 2016, Edson Richter <edsonrich

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 <edsonrich...@hotmail.com <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

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 to newest b

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

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 with qry as (

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

y. As I work with objects 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.or

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 60Gb data

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 a

[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

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 matter the vers

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 all to 9.4 yet

[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 <edsonrich...@hotmail.com <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

[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

Re: [GENERAL] PostgreSQL vs Firebird SQL

p 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 mailing list (pgsql-general@postgresql.org) To make chang

[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

Re: [GENERAL] BDR and TX obeyance

Em 05/01/2016 11:42, Riley Berton escreveu: Edson Richter <edsonrich...@hotmail.com> 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/Sequ

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

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

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

[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

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

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 <edsonrich...@hotmail.com> wrote: I do have several tables that uses varchar(2000) as store for r

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

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 compiled

[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

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

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 >

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

[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

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 questions

[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

[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

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:

[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

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 edsonrich...@hotmail.com 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

[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] 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!

[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

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

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 <david.g.johns...@gmail.com>Data:04/07/2014 21h20Para:Edson Richter;Cc:pgsql-general@postgresql.org;Assunto:Re: Re : [GENERAL] Query top 10 and

[GENERAL] Query top 10 and others

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

Would you please provide an example, even hypothetical?Atenciosamente,Edson Richter-- Mensagem original --De:David G Johnston <david.g.johns...@gmail.com>Data:04/07/2014 19h22Para:pgsql-general@postgresql.org;Assunto:Re: [GENERAL] Query top 10 and othersEdson Richter wrote I woul

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 McKown<john.archie.mck...@gmail.com&g

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

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 original -- De: John McKown Data: 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

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 stho...@optionshouse.com 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

[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

[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

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

Em 28/04/2014 12:01, Tom Lane escreveu: Edson Richter edsonrich...@hotmail.com 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

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 "checkpointer" proce

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

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

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

[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

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 edsonrich...@hotmail.com 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

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

Em 18/03/2014 17:44, Tom Lane escreveu: Edson Richter edsonrich...@hotmail.com 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

[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

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

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

[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] 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 edsonrich...@hotmail.com wrote: Without any changes in the configuration files, a **local** connection to a local VPN IP address could not be established

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 edsonrich...@hotmail.com wrote: Without any changes in the configuration

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

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

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 r...@iol.ie wrote: On 27/01/2014 12:11, Manoj Soni wrote: Name, Age and Sex Which tutorial, may help me in this regard. I did

Re: [GENERAL] A Simple web application

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

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

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

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 edsonrich...@hotmail.com mailto:edsonrich...@hotmail.com wrote: Yes, those optimizations I was talking about: having database server store transaction log in high speed solid state disks

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 edsonrich...@hotmail.com javascript:_e({}, 'cvml', 'edsonrich...@hotmail.com'); wrote

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

Em 17/11/2013 10:00, Michael Paquier escreveu: On Sun, Nov 17, 2013 at 8:25 PM, Stefan Keller sfkel...@gmail.com wrote: How can Postgres be used and configured as an In-Memory Database? Does anybody know of thoughts or presentations about this NoSQL feature - beyond e.g. Perspectives on NoSQL

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

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 Database? Does anybody know of thoughts or presentations about this NoSQL feature - beyond e.g. Perspectives on NoSQL from Gavin Roy at

[GENERAL] Partitioning and triggers

Dear community, In documentation, when partitioning tables, it is said that Optionally, define a trigger or rule to redirect data inserted into the master table to the appropriate partition. Is the trigger creation optional? I mean, partitioning will not work as expected if we don't have the

  1   2   3   >