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,
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,
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
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
> 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
>
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
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,
>
> 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
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
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
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
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
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
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
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.
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
21 matches
Mail list logo
