Re: Right version of jdbc

You should probably be using the latest version of postgis-jdbc Maven Repository: net.postgis » postgis-jdbc » 2021.1.0 (mvnrepository.com) Dave Cramer www.postgres.rocks On Mon, 25 Sept 2023 at 08:43, Raivo Rebane wrote:

Accessing system information functions

Environment: Ubuntu 22.04 lts, postgres 15 installed via postgres.org repository I am attempting to use the system information functions here: https://www.postgresql.org/docs/15/functions-info.html I’m logged on as the postgres superuser on the host Trying any of the

Re: Right version of jdbc

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

Re: debugger from superuser only.... why?

Alexander Petrossian writes: >>> I am wondering why is this, why not allow debugging for non-privileged >>> users? Seems obvious to me that it'd be a nasty security hole, ie you could take control of somebody else's session and make it do things you don't have permissions for. Even if there's

Re: Accessing system information functions

Hi po 25. 9. 2023 v 19:51 odesílatel Rob Sargent napsal: > > > On Sep 25, 2023, at 5:05 AM, Johnson, Bruce E - (bjohnson) < > john...@pharmacy.arizona.edu> wrote: > >  Environment: Ubuntu 22.04 lts, postgres 15 installed via postgres.org > repository > > > I am attempting to use the system

Re: debugger from superuser only.... why?

On Fri, Sep 22, 2023 at 9:05 PM wrote: > > hi, > the first steps to use debugger: > 1. modify config file > 2. restart server > ... > i would say, enough reasons to be superuser or not? Well, the above are not privileges "to use" the debugger, rather "to configure" the debugger. Luca > >

Move from v9.4 to v15

I wanted to thank everyone who helped out in our transition to the new version. Thanks especially to Tom, Laurenz, and Adrian. It has taken over a year, since this upgrade project kept getting superseded by more important projects, and because I only work with this client one day a week, but as

Re: Right version of jdbc

On 9/25/23 06:38, Raivo Rebane wrote: Hi, now I use -               org.postgis         postgis-jdbc         1.3.3                 org.postgresql         postgresql         42.5.4       But I got error - Exception in thread "main" java.lang.NoSuchMethodError:

Re: Postgres 11.5 not logging all sqls

Thank you Erik, Not all queries are truncated at same size,different queries different sizes but all 11.5 servers are behaving in same manner. On Mon, 25 Sept, 2023, 5:33 pm Erik Wienhold, wrote: > On 2023-09-25 16:54 +0530, shashidhar Reddy wrote: > > We are using postgres 11.5 on Ubuntu we

Re: Postgres 11.5 not logging all sqls

On 9/25/23 11:55, shashidhar Reddy wrote: Thank you Erik, Not all queries are truncated at same size,different queries different sizes but all 11.5 servers are behaving in same manner. FYI, the last minor release for version is 11.21. You are missing 16 bug/security fixes. I would update to

Re: Postgres 11.5 not logging all sqls

Thank you Adrian! I will apply the patch and see. On Tue, 26 Sept, 2023, 12:53 am Adrian Klaver, wrote: > On 9/25/23 11:55, shashidhar Reddy wrote: > > Thank you Erik, > > > > Not all queries are truncated at same size,different queries different > > sizes but all 11.5 servers are behaving in

Re: Postgres 11.5 not logging all sqls

On 9/25/23 19:30, shashidhar Reddy wrote: Thank you Adrian! I will apply the patch and see. Just to be clear 11.21 represents the changes from 16 different minor releases. -- Adrian Klaver adrian.kla...@aklaver.com

Right version of jdbc

Hi, I use : PostgreSQL 15.2, compiled by Visual C++ build 1914, 64-bit and PostGIS 3.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1 What versions of jdbc driver I have to use for proper work ? Regards, Raivo

Re: Right version of jdbc

Raivo Rebane schrieb am 25.09.2023 um 10:36: > I use : >   PostgreSQL 15.2, compiled by Visual C++ build 1914, 64-bit > and > PostGIS  3.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1 > > What versions of jdbc driver I have to use for proper work ? Use the latest, i.e. 42.6.0

Re: debugger from superuser only.... why?

22 сент. 2023 г., в 14:20, Luca Ferrari написал(а): >> Checked few sources, can not seem to find reasoning behind this limit: >> You must have superuser privileges to use the debugger. >> What is the reason? > I suspect the debugger will need to open a connection back to pgadmin, > and that

Re: debugger from superuser only.... why?

> > > > SELECT * FROM pldbg_set_global_breakpoint(1, 65695, -1, NULL); > > ERROR: must be a superuser to create a breakpoint > > I am wondering why is this, why not allow debugging for non-privileged > users? > > Again, I'm suspecting that this debugger works by performing a > sandboxing and

Re: Accessing system information functions

On 2023-09-22 17:37 +, Johnson, Bruce E - (bjohnson) wrote: > postgres=# pg_database_size(avi); > ERROR: syntax error at or near "pg_database_size" > LINE 1: pg_database_size(avi); Call functions with SELECT, e.g.: SELECT pg_database_size('avi'); Also, the database name must be a

Postgres 11.5 not logging all sqls

Hello We are using postgres 11.5 on Ubuntu we have enabled logging and set log_statements to all but when I checked the statements in the logs I can see only first few lines of the query and also when I check in pgadmin for current queries I could see only few lines. Some one please help me to

Re: Right version of jdbc

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_PROJ=1 USE_STATS=1 >

Re: Right version of jdbc

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 > > > On Mon, 25 Sept

Re: Postgres 11.5 not logging all sqls

On Mon, 2023-09-25 at 16:54 +0530, shashidhar Reddy wrote: > We are using postgres 11.5 on Ubuntu we have enabled logging and set > log_statements to all but when I checked the statements in the logs I > can see only first few lines of the query I don't know about pgAdmin, but the log will

Re: Postgres 11.5 not logging all sqls

Hi Laurenz, Iog is also showing few lines that is incomplete statement. On Mon, 25 Sept, 2023, 5:05 pm Laurenz Albe, wrote: > On Mon, 2023-09-25 at 16:54 +0530, shashidhar Reddy wrote: > > We are using postgres 11.5 on Ubuntu we have enabled logging and set > > log_statements to all but when I

Re: Postgres 11.5 not logging all sqls

On 2023-09-25 16:54 +0530, shashidhar Reddy wrote: > We are using postgres 11.5 on Ubuntu we have enabled logging and set > log_statements to all but when I checked the statements in the logs I can > see only first few lines of the query and also when I check in pgadmin for > current queries I

Re: Right version of jdbc

Hi, now I using following - [INFO] Copying postgis-jdbc-2.1.7.jar to C:\Users\Raivo\eclipse-workspace\backendproject\target\lib\postgis-jdbc-2.1.7.jar [INFO] Copying postgresql-42.6.0.jar to C:\Users\Raivo\eclipse-workspace\backendproject\target\lib\postgresql-42.6.0.jar [INFO] Copying

Re: Right version of jdbc

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 >

Re: Accessing system information functions

On Sep 25, 2023, at 5:05 AM, Johnson, Bruce E - (bjohnson) wrote: Environment: Ubuntu 22.04 lts, postgres 15 installed via postgres.org repository I am attempting to use the system information functions here: https://www.postgresql.org/docs/15/functions-info.html I’m logged on as the

Re: Accessing system information functions

On Sep 25, 2023, at 5:05 AM, Johnson, Bruce E - (bjohnson) wrote: Environment: Ubuntu 22.04 lts, postgres 15 installed via postgres.org repository I am attempting to use the system information functions here: https://www.postgresql.org/docs/15/functions-info.html I’m logged on as the

Re: Right version of jdbc

Hi, now I use - org.postgis postgis-jdbc 1.3.3 org.postgresql postgresql 42.5.4 But I got error - Exception in thread "main" java.lang.NoSuchMethodError: 'org.postgresql.core.Encoding

Re: Right version of jdbc

And target/lib is s following : Directory of C:\Users\Raivo\eclipse-workspace\backendproject\target\lib 25.09.2023 15:35 . 25.09.2023 15:33 .. 25.09.2023 15:33 214 381 checker-qual-3.5.0.jar 25.09.2023 13:1475 847 postgis-jdbc-1.3.3.jar

Re: Right version of jdbc

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.09.2023 15:33