Le 22/08/2019 à 16:23, Arnaud L. a écrit :
Le 22/08/2019 à 16:21, Adrian Klaver a écrit :
The only thing I can think of at the moment is to put the offending line
in a separate script and see what happens.
Then I think I'll first try to switch the line orders. I'll execute this
action last and
Am 25.08.19 um 18:11 schrieb E:
What is the process to update the DSN? I assume I'll have to relay the
changes in my pg_hba.conf, but do not understand, and don't want to
tinker, with BDR before obtaining some educated advice.
I apologize if my question comes across as dumb. I understand I
On 8/25/19 2:59 PM, Howard Wells wrote:
I solved this problem. All four servers are behind a firewall, but port 5432
was not open on the firewall. When I opened 5432, the problem disappeared.
Glad you solved. Confused as to how:
1) From first post:
"All four are behind the same firewall, wi
I solved this problem. All four servers are behind a firewall, but port 5432
was not open on the firewall. When I opened 5432, the problem disappeared.
Thanks to Rob Sargent, Adrian Klaver and Condor for your help.
Howard
‐‐‐ Original Message ‐‐‐
On Sunday, August 25, 2019 12:20 PM, R
David Wall writes:
> ... So we're trying to determine
> if there's actually any difference between commit/rollback after SELECT
> statements (with rows returned or not), a bit like if there's any
> difference for an UPDATE statement that returns zero rows were updated.
They're different code p
On 8/25/19 12:40 PM, Rob Sargent wrote
On Aug 25, 2019, at 1:09 PM, David Wall wrote:
Using the latest PostgreSQL, does it matter if my code does a ROLLBACK or a
COMMIT on an non-modifying SELECT statement? My impression is they'd be the
same as nothing is changed and therefore there's nothi
> On Aug 25, 2019, at 1:09 PM, David Wall wrote:
>
> Using the latest PostgreSQL, does it matter if my code does a ROLLBACK or a
> COMMIT on an non-modifying SELECT statement? My impression is they'd be the
> same as nothing is changed and therefore there's nothing to commit or
> rollback,
On Mon, Aug 26, 2019 at 1:40 AM Roger De Four
wrote:
>
> Apparently can't be done on Ubuntu - cf. https://github.com/dimitri/pgcharts
There is nothig there that indicates Ubuntu is a problem platform.
Have you tried a git clone and used the provided Makefile yourself?
--
Johann
I'm not from
I enabled "host all all 0.0.0.0/0 trust" in pg_hba.conf and restarted
Postgres, but I still get the same behavior. It looks like password
authentication is not the issue. I enabled MD5, but I didn't know I would have
to do anything else; from this test, that doesn't seem to be the problem. I
Thanks for the replies. I am getting the information requested by Adrian
Klaver. Rob Sargent, I am going to temporary enable full trust because the
password authentication could be the issue. Then I'll write back.
Howard
‐‐‐ Original Message ‐‐‐
On Sunday, August 25, 2019 12:20 PM, R
>
> console.
> The pg_hba.conf has these lines enabled:
> pg_hba.conf:
> hostall [username] 0.0.0.0/0 trust
> hostall all 0.0.0.0/0 md5
> hostall all ::/0
Using the latest PostgreSQL, does it matter if my code does a ROLLBACK
or a COMMIT on an non-modifying SELECT statement? My impression is
they'd be the same as nothing is changed and therefore there's nothing
to commit or rollback, but wondered if there was any difference in how
they are proce
On 8/25/19 11:46 AM, Howard Wells wrote:
I have enabled logging. I chose the highest level of recording so I would have
the best chance of finding out what's wrong. My error log is written to a .csv
file. I initiated a browser-based transaction to insert records into a
database. That trans
I have enabled logging. I chose the highest level of recording so I would have
the best chance of finding out what's wrong. My error log is written to a .csv
file. I initiated a browser-based transaction to insert records into a
database. That transaction produced 1,299 records, with what ap
Apparently can't be done on Ubuntu - cf.
https://github.com/dimitri/pgcharts
On Sun, 25 Aug 2019 at 12:47, stan wrote:
> If anyone has installed the package for this on 18.04, and gotten it
> working,
> I'd like to discuss what you had to do.
>
> When I use apt-get to install it, I get a a coup
If anyone has installed the package for this on 18.04, and gotten it working,
I'd like to discuss what you had to do.
When I use apt-get to install it, I get a a couple of errors:
Warning: The home directory /var/log/pgcharts you specified can't be accessed:
No
such file or directory
Not creati
On 25-08-2019 02:54, Adrian Klaver wrote:
On 8/24/19 3:42 PM, Howard Wells wrote:
I have three servers behind a load balancer and a fourth server solely
for Postgres 10 database that is not behind the load balancer. All
four are behind the same firewall, with port 5432 open.
I have a simple
Hello,
As a preamble, I'm running PostgreSQL 9.4 BDR on a Debian 9.
I'm moving a node to a new host. This is the node from which I started
BDR and had a second replicate join it.
I browsed the list archive, Googled all I could, found some threads and
Github issues, but came up with a grant t
stan writes:
> Subject basically says it all.
A domain is a kind of type ... but it's not the only kind of type.
https://www.postgresql.org/docs/current/domains.html
regards, tom lane
On Thu, Aug 22, 2019 at 5:41 PM ouellet marc-andre <
ouellet_marcan...@hotmail.com> wrote:
> CREATE TABLE test ( id integer, data jsonb ) Partition by range (( data
> #>> '{info,time}' ));
>
> CREATE TABLE test_part1 PARTITION OF test
> FOR VALUES FROM ('3') TO ('4');
>
> INSERT INTO t
Subject basically says it all.
--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
-- Benjamin Franklin
On Sun, Aug 25, 2019 at 8:34 AM stan wrote:
> I am using Postgresql version 11 on Ubuntu 18.04. I am considering using an
> extension called libphonenumber. It needs Postgresql-server-dev to build. I
> found postgresql-server-dev-all in the list of available packages, BUT when
> I ask apt-get to
I am using Postgresql version 11 on Ubuntu 18.04. I am considering using an
extension called libphonenumber. It needs Postgresql-server-dev to build. I
found postgresql-server-dev-all in the list of available packages, BUT when
I ask apt-get to lad it, a dependency is postgresql-server-dev-10.
Se
On 2019-08-24 13:22:38 +0200, Luca Ferrari wrote:
> On Sat, Aug 24, 2019 at 11:53 AM Peter Wainaina wrote:
> >
> > Thanks much for the response. This is what I mean am a database
^
> > administrator for a production company and the
24 matches
Mail list logo
