You should be using the latest version of the driver. What version are you
using ?
Even though you have a 9.4 database the latest version is the correct
version to use.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 8 March 2018 at 22:14, David G. Johnston
wrote:
> On Thu, Ma
Chris,
At this point I'd write small piece of code to test if the url and failover
is working correctly. Sounds like you have a considerably sized stack
making it difficult to debug.
With a small piece of code it should become clear as to how things work or
don't as the case may be
D
Cool, thanks. I'd love to see this work
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 23 March 2018 at 10:24, JCMS22 wrote:
> I forgot to say I am trying to investigate how to make it work as we need
> specific stuff from the DataSource object.
>
> It migh
ities --- feel safe and welcome here.
>
> Also: we *have* had cases where women who had been contributors left
> because of harassment, and I'd like to ensure that doesn't happen again.
>
>
+1000
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
h could be pretty open ended
>> - A reference to the question, e.g. its ID
>> - Some lifecycle attribute such as "viewed-on" or "acknowledged-on"
>>
>> When a user logs in, it should be easy to query that table, providing the
>> list of unexamined updates.
>>
>
Also look at Logical Decoding for implementing Change Data Capture
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
Pretty sure this is a tomcat error .
The connection string looks fine
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On 30 July 2018 at 11:32, Didier Wiroth wrote:
> Hello,
> I'm trying to configure a postgres jndi resource in tomcat that needs to
> connect via
is can be tuned or what the
>> cause is?
>> I don't know what a reason of that, but I think it's reasonable and
>> quite simple to call lo_import()/lo_export() via JNI.
>>
>
Can't imagine that's any faster. The driver simply implements the protocol
Do you have any code to share ? Any other information ?
Is the JDBC connection significantly further away network wise ?
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
e encrypted, so their entropy is
> very high.
>
> Any chance you could write a simple non-hibernate test code to time the
code ?
Dave Cramer
dave.cra...@crunchydata.ca
www.crunchydata.ca
> Mate
>
> On Sun, Sep 2, 2018 at 12:55 AM Dave Cramer wrote:
>
>>
>>
>>
Not sure why reading from a socket is taking 1ms ?
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On Mon, 3 Sep 2018 at 09:39, Mate Varga wrote:
> Hi,
>
> https://imgur.com/a/ovsJPRv -- I've uploaded the profiling info (as an
> image, sorry). It seems this is a JDBC
the one you have highlighted ~1.69ms
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On Mon, 3 Sep 2018 at 10:38, Mate Varga wrote:
> Which frame do you refer to?
>
> On Mon, Sep 3, 2018 at 3:57 PM Dave Cramer wrote:
>
>> Not sure why reading from a socket is takin
On Mon, 3 Sep 2018 at 10:48, Mate Varga wrote:
> That's 1690 msec (1.69 seconds, and that is how long it takes to fetch 20k
> (small-ish) rows without LOBs (LOBs are a few lines below on the screenshot)
>
that sound high as well!
Something isn't adding up.
l but since
they are LOB's we could run out of memory.
Not sure what to tell you at this point. I'd entertain a PR if you were
motivated.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
>
> On Mon, Sep 3, 2018 at 6:54 PM Mate Varga wrote:
>
>> So I have detailed p
Hi
Can you be more explicit how you fixed the problem ?
Thanks
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On Thu, 6 Sep 2018 at 03:46, Mate Varga wrote:
> After inlining the data, performance issues have been solved. Thanks for
> the help.
>
> On Mon, Sep 3, 201
Hi Mate,
Thanks for the detailed response. This will help others in the same
situation
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On Thu, 6 Sep 2018 at 05:03, Mate Varga wrote:
> Hi,
>
> summarizing:
> we had a table that had an OID column, referencing
o what are types of fields in the record?
> >
> > I start the parsing process by looking at types returned in
> > RowDescription message and then reading descriptions in pg_type table.
> >
> > Is there some other way to get full typing information of the result I
>
On Mon, 6 Jul 2020 at 09:33, Tom Lane wrote:
> Niels Jespersen writes:
> > Sorry, "way to provide a default username" should have been "way to
> provide a default databasename"
>
> Not sure, but you'd be more likely to find a knowledgeable answer
> on the pgsql-jdbc list.
>
>
Same way, in the pr
On Wed., Nov. 4, 2020, 8:10 p.m. raf, wrote:
> On Wed, Nov 04, 2020 at 06:29:18PM -0500, Steve Singer
> wrote:
>
> >
> > It is with much sadness that I am letting the community know that Chris
> > Browne passed away recently.
> >
> > Chris had been a long time community member and was active on
one :)
>
> Many thanks.
>
> Regards,
>
> Martin.
>
> --
> Martin Goodson
>
> Whatever you've got planned, forget it. I'm the Doctor.
> I'm 904 years old. I'm from the planet Gallifrey in the
> constellation of Kasterborous. I am The Oncoming Storm,
> the Bringer of Darkness and you are ... basically just a
> rabbit, aren't you? OK, carry on, just a general ...
> warning.
>
>
I'm guessing this is now resolved ?
Dave Cramer
www.postgres.rocks
; https://stackoverflow.com/a/16119489/843699 , but it is not 100% clear.
>
> Would it be possible to have an official answer on this?
>
I can't see how they could possibly be out of order.
Dave Cramer
www.postgres.rocks
>
> Thanks in advance!
>
>
>
So I'm curious. Why does order matter ?
Dave Cramer
www.postgres.rocks
On Wed, 9 Dec 2020 at 03:15, electrotype wrote:
> I can't see how they could possibly be out of order.
>
> Thanks, that what I think too. But, to be honest, I'd really like to see
> this writte
On Wed, 9 Dec 2020 at 10:21, electrotype wrote:
> So I'm curious. Why does order matter ?
>
> Dave Cramer
> www.postgres.rocks
>
>
> When you have to save multiple new entities with subentities.
>
> You first save all the parent entities in a single SQL batch ins
is quite probable that observation of such
> non-orderedness is simply a matter of time. With batching it seems best to
> combine its use with single inserts in order to avoid this problem.
>
> David J.
>
I'd have to agree.
Dave Cramer
www.postgres.rocks
Please follow the instructions here
Configuring the Client (postgresql.org)
<https://jdbc.postgresql.org/documentation/head/ssl-client.html>
<https://jdbc.postgresql.org/documentation/head/ssl-client.html>
Dave Cramer
www.postgres.rocks
On Mon, 1 Feb 2021 at 01:44, wrote:
>
&g
On Mon, 1 Feb 2021 at 04:51, Niels Jespersen wrote:
> >On Sat, 2021-01-30 at 15:56 +, Niels Jespersen wrote:
> >> It would be nice if Npgsql (and jdbc and others) emulated the libpq
> behaviour.
> >> Because in my mind, abstracting hostname, portnumber and databasename
> >> away is a really
On Wed, 10 Feb 2021 at 06:11, Niels Jespersen wrote:
> >Fra: prachi surangalikar
>
> >
>
> >Hello Team,
>
> >Greetings!
>
> >
>
> >We are using Postgres 12.2.1 for fetching per minute data for about 25
> machines but running parallely via a single thread in python.
>
> >But suddenly the insertio
FWIW, messing with serial numbers like this is pretty risky.Sequences have
transactional semantics for a reason.
Dave Cramer
www.postgres.rocks
On Thu, 11 Feb 2021 at 14:57, Steve Baldwin wrote:
> Try ... EXECUTE PROCEDURE customer_num_informix()
>
> Steve
>
> On Fri, Feb 12,
Looks very interesting,
Cheers,
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On Wed, 14 Nov 2018 at 14:57, Konstantin Knizhnik
wrote:
> If somebody is interested in connection to various JDBC-compatible
> databases through postgres_fdw,
> please look at my pq2jdbc proje
Strange, I wouldn't think so, but then I haven't used a raw servlet for so
long I have no idea.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On Fri, 14 Dec 2018 at 13:29, Rob Sargent wrote:
> Using java 1.8, postgresql-42.1.4.jar, embedded tomcat 9
>
> It a
My guess is it has something to do with your servlet classpath loader.
Which servlet engine are you using ?
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On Fri, 14 Dec 2018 at 16:04, Rob Sargent wrote:
>
>
> On Dec 14, 2018, at 2:02 PM, Rob Sargent wrote:
>
>
>
So you are starting up tomcat yourself ? Perhaps that is the difference ?
I have no idea what the tomcat wrapper does, but I'd be curious if the same
thing happens when stared normally
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On Sun, 16 Dec 2018 at 12:20, Rob Sargent
not properly include the driver's jar in the classpath.
>
Servlet classpath issues are legendary. As Thomas points out setting up the
classpath for a servlet engine is not trivial.
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
>
>
Hi Rob,
Interesting. I've not looked too much into the copy implementation.
The JDBC list or the jdbc github repo https://github.com/pgjdbc/pgjdbc
might be a better place to report this. I know Lukas Edar monitors it as
well
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On T
Thomas,
Any chance it would run under graalvm getting rid of the need for the JVM ?
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On Mon, 25 Mar 2019 at 07:06, Thomas Kellerer wrote:
> kpi6...@gmail.com schrieb am 22.03.2019 um 17:25:
> > 95% of my time I use pgadminII
ks,
> Rob
>
> [1]: https://github.com/cretz/pgnio
>
>
Basically because java would have to create a type dynamically to parse the
data into.
There's nothing inherently difficult about parsing the data, the problem is
what do we put it into ?
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
;
https://www.techempower.com/benchmarks/#section=data-r17&hw=ph&test=db
Seems to be worth it.
Now it appears that ADBA is going to die on the vine, R2DBC and vertx seem
to be pretty good
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
On Mon, 17 Jun 2019 at 07:35, Rob Nikander wrote:
>
>
> On Jun 17, 2019, at 1:12 PM, Dave Cramer wrote:
>
> https://www.techempower.com/benchmarks/#section=data-r17&hw=ph&test=db
>
> Seems to be worth it.
>
> Now it appears that ADBA is going to die on the
On Mon, 17 Jun 2019 at 09:43, Rob Nikander wrote:
>
>
> > On Jun 17, 2019, at 3:57 PM, Dave Cramer wrote:
> > […] Postgres can pipeline requests if the client is written correctly so
> it is conceivable that this would be much faster.
>
> Can the JDBC driver do this
Hi Rumpi,
We do have a Speaker Bureau - PostgreSQL wiki
<https://wiki.postgresql.org/wiki/Speaker_Bureau> you can try there.
Also if your group qualifies it's possible to get funding for your meetup
group if you have one.
Dave Cramer
On Thu, 17 Aug 2023 at 10:03, Rumpi Gravens
Hi Amn,
Can you help me understand this issue better?
I don't see anywhere in the code where you are attempting to create a
tablespace ?
Dave Cramer
On Sun, 20 Aug 2023 at 11:17, Amn Ojee Uw wrote:
> Hello.
>
> I have searched the net in an attempt to find if other
On Mon, 21 Aug 2023 at 12:46, Tom Lane wrote:
> "David G. Johnston" writes:
> > Otherwise, I agree this seems like a bug, probably in the JDBC driver,
> > though one pertains to style as opposed to semantics since both answers
> are
> > technically correct.
>
> I don't see any such behavior chan
On Mon, 21 Aug 2023 at 15:12, Edoardo Panfili <
edoardo.panf...@iisgubbio.edu.it> wrote:
>
>
> Il giorno 21 ago 2023, alle ore 17:45, Adrian Klaver <
> adrian.kla...@aklaver.com> ha scritto:
>
> On 8/21/23 08:27, Edoardo Panfili wrote:
>
> Hello,
> I am using
> postgresql version: 15.3 (Debian 15.
On Mon, 21 Aug 2023 at 14:42, Edoardo Panfili wrote:
>
>
> > Il giorno 21 ago 2023, alle ore 20:13, Peter J. Holzer
> ha scritto:
> >
> > On 2023-08-21 17:27:20 +0200, Edoardo Panfili wrote:
> >> The attended result was a sequence of ten equal values but this is the
> actual result:
> >> p: -1
>
On Mon, 21 Aug 2023 at 17:17, Ron wrote:
> On 8/21/23 14:32, Dave Cramer wrote:
>
> [snip]
>
> It has to do with the way the data is being transferred. When the driver
> switches to a named statement it also switches to binary mode which means
> data will be transferred in b
On Tue, 22 Aug 2023 at 01:54, Edoardo Panfili wrote:
>
>
> Il giorno 21 ago 2023, alle ore 21:37, Dave Cramer
> ha scritto:
>
>
>
> On Mon, 21 Aug 2023 at 14:42, Edoardo Panfili wrote:
>
>>
>>
>> > Il giorno 21 ago 2023, alle ore 20:13, P
Hi Amn,
What I don't understand is the requirement to set autocommit to true since
this is the default ?
Either way this is expected behaviour as psql also has autocommit true by
default.
Thanks,
Dave Cramer
On Mon, 21 Aug 2023 at 20:57, Amn Ojee Uw wrote:
> Thanks Dave for your
Hi,
The latest version of the driver is usually the right answer. So 42.5.4
Dave Cramer
www.postgres.rocks
On Mon, 25 Sept 2023 at 07:03, Raivo Rebane wrote:
> Hi,
> I use :
> PostgreSQL 15.2, compiled by Visual C++ build 1914, 64-bit
> and
> PostGIS 3.3 USE_GEOS=1 USE_PRO
Sorry 42.6.0
Interesting that github still has 42.5.4 as the release
Dave Cramer
www.postgres.rocks
On Mon, 25 Sept 2023 at 07:27, Dave Cramer
wrote:
> Hi,
>
> The latest version of the driver is usually the right answer. So 42.5.4
> Dave Cramer
> www.postgres.rocks
>
&
The missing class is from the postgis jar. Are you sure it is on your
classpath ?
Dave Cramer
www.postgres.rocks
On Mon, 25 Sept 2023 at 08:26, Raivo Rebane wrote:
> Hi,
> now I using following -
> [INFO] Copying postgis-jdbc-2.1.7.jar to
> C:\Users\Raivo\eclipse-workspace\ba
remove the postgresql-8.3-603.jdbc4.jar
Dave Cramer
www.postgres.rocks
On Mon, 25 Sept 2023 at 08:43, Raivo Rebane wrote:
> And target/lib is s following :
> Directory of C:\Users\Raivo\eclipse-workspace\backendproject\target\lib
>
> 25.09.2023 15:35 .
> 25
It must be a dependency to something. postgis ?
Dave Cramer
www.postgres.rocks
On Mon, 25 Sept 2023 at 09:25, Raivo Rebane wrote:
> Hi,
> postgresql-8.3-603.jdbc4.jar is added by maven maven install. How to
> avoid it ?
>
You should probably be using the latest version of postgis-jdbc
Maven Repository: net.postgis » postgis-jdbc » 2021.1.0 (mvnrepository.com)
<https://mvnrepository.com/artifact/net.postgis/postgis-jdbc/2021.1.0>
Dave Cramer
www.postgres.rocks
On Mon, 25 Sept 2023 at 08:43, Raivo Rebane
lob/5709a20fbef453749d2394e11502527e4a3ab5bb/pgjdbc/src/main/java/org/postgresql/util/PGobject.java#L19>
I suggest at this point you provide a test project on github that you can
share.
There is something wrong with the classpath
Dave Cramer
www.postgres.rocks
On Wed, 27 Sept 2023 at 01:52,
Dave Cramer
www.postgres.rocks
On Thu, 28 Sept 2023 at 02:18, Raivo Rebane wrote:
> Hi,
>
> I made a new Java application Eclipse Dynamic WEB application and want to
> use Postgres - PostgreSQL 10.14 on x86_64-pc-linux-gnu, compiled by gcc
> (Ubuntu 9.3.0-10ubuntu2) 9.3.0, 64-
Please put this project on github so we can see it.
Thanks
Dave Cramer
www.postgres.rocks
On Thu, 28 Sept 2023 at 11:53, Raivo Rebane wrote:
> Or may be I am using wrong version of Java - java version "17.0.8"
> 2023-07-18 LTS
>
> Raivo
>
> On Thu, Sep 28, 2023 at
The latest version of postgis-jdbc is Maven Repository: net.postgis »
postgis-jdbc » 2021.1.0 (mvnrepository.com)
<https://mvnrepository.com/artifact/net.postgis/postgis-jdbc/2021.1.0>
Dave Cramer
www.postgres.rocks
On Thu, 28 Sept 2023 at 14:51, Raivo Rebane wrote:
> Hi,
>
> T
Dave Cramer
www.postgres.rocks
On Fri, 29 Sept 2023 at 06:19, Raivo Rebane wrote:
> Hi,
>
> The code is :
> package MushroomAPIs;
>
> import java.io.IOException;
> import javax.servlet.ServletException;
> import javax.servlet.annotation.WebServlet;
> import jav
On Fri, 29 Sept 2023 at 14:22, Raivo Rebane wrote:
> Thanks,
>
> there was really JDK 17 in use.
> I changed it to Java 1.8
> PS C:\Program Files\Apache Software Foundation\Tomcat 9.0\bin> java
> -version
> java version "1.8.0_381"
> Java(TM) SE Runtime Environment (build 1.8.0_381-b09)
> Java Ho
Again, can you please post the solution so others can learn as well ?
Dave Cramer
www.postgres.rocks
On Sat, 30 Sept 2023 at 06:49, Raivo Rebane wrote:
> Thanks for very much for help.
> It seems that I can do the test project for new job.
> In future I use help of chat.gpt
&g
On Sat, 21 Oct 2023 at 05:50, Justin Clift wrote:
> On 2023-10-19 04:45, Abelardo Erazo Lopez wrote:
> > Hi, Everyone
> >
> > I have an Oracle database Oracle 19c and I need to access a PostgreSQL
> > database 15.4 that resides on a different server. I see that one
> > alternative is to use ODBC
src/main/java/MushroomAPIs line 47 Java Problem
>>> Point cannot be resolved to a type ProcAddMushrooms.java
>>> /KatseAPIs/src/main/java/MushroomAPIs line 83 Java Problem
>>> Point cannot be resolved to a type Utils.java
>>> /KatseAPIs/src/main/java/MushroomAPIs line
alent to serializable transactions? So I
> guess the downsize is that quarries can’t be run in parallel?
>
I do not think a CTE changes the isolation level.
>
> If I decide to replace all my transaction code with CTE, will I shoot
> myself in the foot down the road?
>
Dave Cramer
www.postgres.rocks
On Thu, 1 Apr 2021 at 11:09, Glen Huang wrote:
> No, but are they equivalent to serializable transactions?
>
No, they are not.
Dave Cramer
www.postgres.rocks
>
> On Apr 1, 2021, at 11:04 PM, Dave Cramer
> wrote:
>
>
>
>
>
> On Thu, 1 Apr 2021 at 10:5
CTE's don't change the isolation level. I'm not sure what you are getting
at here ?
Dave Cramer
www.postgres.rocks
On Thu, 1 Apr 2021 at 11:20, Glen Huang wrote:
> Sorry, my mistake. I misunderstood serializable. Are queries in a CTE
> equivalent to those in a repeat
On Thu, 1 Apr 2021 at 15:39, Bruce Momjian wrote:
> On Thu, Apr 1, 2021 at 11:24:48AM -0400, Dave Cramer wrote:
> > CTE's don't change the isolation level. I'm not sure what you are
> getting at
> > here ?
>
> I think what he/she means here is that all q
On Sun, 4 Apr 2021 at 09:12, Bruce Momjian wrote:
> On Sun, Apr 4, 2021 at 08:35:41AM -0400, Dave Cramer wrote:
> >
> >
> > On Thu, 1 Apr 2021 at 15:39, Bruce Momjian wrote:
> >
> > On Thu, Apr 1, 2021 at 11:24:48AM -0400, Dave Cramer wrote:
> >
On Mon, 5 Apr 2021 at 14:18, Bruce Momjian wrote:
> On Sun, Apr 4, 2021 at 10:02:20AM -0400, Dave Cramer wrote:
> > On Sun, 4 Apr 2021 at 09:12, Bruce Momjian wrote:
> > > OK, that makes sense, but I think it is wrong minded to think that
> this
> > > ab
> The reason why the old-timers around here are sticky about this is that
> we believe we are writing for the mailing list archives. Gmail-style
> quoting is indeed the appropriate amount of effort for throwaway threads
> that only a few people will read and (probably) none of them will consult
>
On Sun, 13 Jun 2021 at 19:32, Avi Weinberg wrote:
> I need to take actions when Postgres streaming replication failover
> occurred. Is there a way to be notified when Postgres slave becomes
> master? If no such notification possible, what is the best way to actively
> monitor which server is ma
Dave Cramer
www.postgres.rocks
On Mon, 26 Jul 2021 at 18:43, Cory Nemelka wrote:
>
> On Mon, Jul 26, 2021 at 12:06 PM Rama Krishnan
> wrote:
>
>> Hi all,
>>
>> I have a postgres server on Aws RDS no i want to replicate the data or
>> logical replication int
On Thu, 29 Jul 2021 at 11:04, Bhavesh Mistry
wrote:
> Hello,
>
> I am getting an NPE exception in the JDBC driver 42.2.23.
>
> When the alias is null, NPE results. Is it possible to handle null value
> ? I have filled a bug against RCA
> https://github.com/vladmihalcea/hibernate-types/issues/335
On Thu, 29 Jul 2021 at 15:44, Bhavesh Mistry
wrote:
> Hi Dave,
>
> It still does not address the NPE issue. If an alias is NULL. What
> should be the behavior?
>
>
> public String getTypeForAlias(String alias) {
> String type = TYPE_ALIASES.get(alias);
> if (type != null) {
> return type;
> }
>
It would be helpful to see the logs from the failed start.
Dave Cramer
www.postgres.rocks
On Thu, 12 Aug 2021 at 07:59, celati Laurent
wrote:
> Good morning,
>
> I want to move the data folder from default path to another drive/path.
> I made an attempt thaks to this li
Dave Cramer
www.postgres.rocks
On Mon, 16 Aug 2021 at 12:32, Andy Hall wrote:
> thanks for the very clear explanation much appreciated shall take this
> back to the team.
>
> On Mon, 16 Aug 2021 at 17:14, Tom Lane wrote:
> >
> > Andy Hall writes:
> > > we h
"timestamp with timezone" is - how do I put this? - more than just
> weird. "timestamp without timezone" should be called "local timestamp
> with unspecified timezone" and "timestamp with timezone" should be
> called "global timestamp without timezone". However, those aren't SQL
> names.
>
>
I would say this is a perspective thing. It's a timestamp with a time zone
from the client's perspective.
> Dave Cramer
> www.postgres.rocks
>
>
On Tue, 21 Sept 2021 at 13:40, Peter J. Holzer wrote:
> On 2021-09-21 13:34:21 -0400, Dave Cramer wrote:
> > On Tue, 21 Sept 2021 at 13:20, Peter J. Holzer wrote:
> > On 2021-09-21 20:50:44 +1200, Tim Uckun wrote:
> > > It's just that the phrase "times
On Fri, 12 Nov 2021 at 06:12, Yessica Brinkmann
wrote:
> Hello.
> Thank you very much for your answer.
> Yes, I restart the server after making the changes.
> Regards,
> Yessica Brinkmann
>
Check the logs for postgres to make sure there were no errors in your new
configura
On Tue, 16 Nov 2021 at 11:09, Joel Rabinovitch
wrote:
> Hi,
>
>
>
> Currently, our application supports SQL Server databases and Oracle
> schemas. We are updating our application to support PostgreSQL schemas. We
> are using version 13.4 of PostgreSQL.
>
>
>
> Our application is written in Java a
,10.20.16.105,255.255.255.255,md5,,
> 161,host,{product},{dbcheck},10.34.21.118,255.255.255.255,md5,,
> 165,host,{product},{product_dba},10.3.10.2,255.255.255.255,md5,,
> 168,host,{product},{product_dba},10.3.10.13,255.255.255.255,md5,,
>
>
>
>
Hmmm for some reason I did not reply to the list.
At any rate.
Your original post stated that you only had
host VJ VJ_USER 10.10.10.1/32 md5
in the pg_hba.conf file.
However the result of the select is considerably more ?
Dave Cramer
>
On Fri, 31 Dec 2021 at 16:25, Paul Jungwirth
wrote:
> On 12/31/21 12:27 PM, Martin Mueller wrote:
> > I know that on my Mac the tables are kept in the data directory
> > /Users/martinmueller/Library/Application Support/Postgres/var-13. If I
> > go there I see that internally the tables have nu
Dave Cramer
www.postgres.rocks
On Sun, 16 Jan 2022 at 10:13, R Batchen wrote:
>
> Hello,
>
> I hope i reached the right mailing list, i have psql 12.3 container that
> is the db of apache guacamole container is connected to,
> the apache guacamole stopped working and i s
the principle is the same)
>
>
JDBC docs on GSSAPI can be found
https://jdbc.postgresql.org/documentation/head/connect.html
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
drive location for my data directory or any important parameter,
>> please let me know.
>>
>> There are lots, but changing the data dir is not particularly difficult.
https://www.postgresql.org/docs/9.3/static/runtime-config-file-locations.html
Dave Cramer
da...@postgresintl.com
www.postgresintl.com
>
>> Thanks in Advance
>>
>> --
>>
>> Regards,
>> Azim
>>
>>
82 matches
Mail list logo
