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://
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
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
At the end, I've chosen to use the following:
trickle -u 500 -d 500 rsync --progress --partial -az ${PGDATA}/*
r...@xxx.bb.com:/var/lib/pgsql/repl-9.3/data/ --exclude
postmaster.pid --exclude postgresql.conf --exclude pg_hba.conf --exclude
pg_log
and it worked really well. This way I've
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
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
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
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/pgsq
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
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
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
-
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
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
> -Mensagem original-
> De: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] Em nome de Marti Raudsepp
> Enviada em: segunda-feira, 26 de setembro de 2011 17:42
> Para: Edson Carlos Ericksson Richter
> Cc: pgsql-general@postgresql
> -Mensagem original-
> De: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] Em nome de Marti Raudsepp
> Enviada em: terça-feira, 27 de setembro de 2011 09:59
> Para: Alban Hertroys
> Cc: PG-General Mailing List
> Assunto: Re: [GENERAL] Does postgresql 9.0.4
> -Mensagem original-
> De: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] Em nome de Harald Fuchs
> Enviada em: terça-feira, 27 de setembro de 2011 07:01
> Para: pgsql-general@postgresql.org
> Assunto: Re: [GENERAL] Does postgresql 9.0.4 use index on PREF
> -Mensagem original-
> De: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] Em nome de Marti Raudsepp
> Enviada em: segunda-feira, 26 de setembro de 2011 17:42
> Para: Edson Carlos Ericksson Richter
> Cc: pgsql-general@postgresql
w...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] Em nome de Gregg Jaskiewicz
Enviada em: segunda-feira, 26 de setembro de 2011 12:28
Para: Edson Carlos Ericksson Richter
Cc: pgsql-general@postgresql.org
Assunto: Re: [GENERAL] Does postgresql 9.0.4 use index on PREFIX%SUFFIX
que
Alban Hertroys
Enviada em: segunda-feira, 26 de setembro de 2011 12:37
Para: Edson Carlos Ericksson Richter
Cc: pgsql-general@postgresql.org
Assunto: Re: [GENERAL] Does postgresql 9.0.4 use index on PREFIX%SUFFIX
queries?
On 26 September 2011 17:15, Edson Carlos Ericksson Richter
wrote:
> Just
).
select * from notafiscal where numeroctc like ‘POA%34345’;
Thanks,
Edson.
De: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] Em nome de Edson Carlos Ericksson
Richter
Enviada em: segunda-feira, 26 de setembro de 2011 11:03
Para: pgsql
...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] Em nome de Gregg Jaskiewicz
Enviada em: segunda-feira, 26 de setembro de 2011 10:01
Para: Edson Carlos Ericksson Richter
Cc: pgsql-general@postgresql.org
Assunto: Re: [GENERAL] Does postgresql 9.0.4 use index on PREFIX%SUFFIX queries
something else to speed up the query?
Thanks,
Edson Carlos Ericksson Richter
SimKorp Infomática Ltda
Fone:
(51) 3366-7964
Celular:
(51) 8585-0796
Embedded Image
<http://www.simkorp.com.br/> www.simkorp.com.br
<>
smime.p7s
Description: S/MIME cryptographic signature
-hack...@postgresql.org
Assunto: Re: [GENERAL] Alter column...using failure under 9.0.4
=?iso-8859-1?Q?Bj=F6rn_H=E4user?= writes:
> Am 25.09.2011 um 17:17 schrieb Edson Carlos Ericksson Richter:
>> alter table usuario alter column ativo type smallint using (case when
>> ati
working.
I have a script with hundred similar lines (for other tables) without any
error, just this table.
Any hints?
Edson Carlos Ericksson Richter
SimKorp Infomática Ltda
Fone:
(51) 3366-7964
Celular:
(51) 8585-0796
Embedded Image
<http://www.simkorp.com
>From the manual, "In any case the hardware architecture must be the same
shipping from, say, a 32-bit to a 64-bit system will not work."...
I don't even believe you can copy a 64bit database into 32bit machine...
what makes warm standby impossible...
I've tried this in the past, and give up -
Tried both, but they don't work for 9.1.
I want to thank Adrian, without his help I would never find the link that
confirmed the postgresql_fdw is not working.
Would be nice to make all this information clear in Foreign Data Wrapper
documentation at PostgreSQL manuals.
I wasted at least 12 hours
laver
Enviada em: sábado, 17 de setembro de 2011 14:30
Para: pgsql-general@postgresql.org
Cc: Edson Carlos Ericksson Richter
Assunto: Re: RES: RES: [GENERAL] Foreign PostgreSQL server
On Saturday, September 17, 2011 5:22:35 am Edson Carlos Ericksson Richter
wrote:
> Thanks Adrian, I really m
definitely missing something...
What is the way to go?
Edson.
De: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] Em nome de Adrian Klaver
Enviada em: sexta-feira, 16 de setembro de 2011 23:30
Para: pgsql-general@postgresql.org
Cc: Edson Carlos Ericksson Richter
Assunto
Ok, managed to get the first part working:
---
create extension dblink;
CREATE FOREIGN DATA WRAPPER postgresql VALIDATOR postgresql_fdw_validator;
CREATE SERVER simfrete02 FOREIGN DATA WRAPPER postgresql OPTIONS (host
'127.0.0
es not exists
SQL state: 42883
Can you point what I'm doing wrong?
Thanks & Regards,
Edson Carlos Ericksson Richter
SimKorp Infomática Ltda
Fone:
(51) 3366-7964
Celular:
(51) 8585-0796
www.simkorp.com.br
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
30 matches
Mail list logo
