Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

8
  • Are you 100% sure you are connecting to the same database using the same user? Commented May 21, 2015 at 9:05
  • @RadekPostołowicz Yes I am. I currently only have one database with one user. Commented May 21, 2015 at 9:10
  • Can you post results of select current_database(), current_schema(), current_schemas(true), current_user, inet_client_addr(), inet_client_port(), inet_server_addr(), inet_server_port(), pg_my_temp_schema(), pg_postmaster_start_time(), session_user, version(); executed twice: once in psql and once from java code from your application? Commented May 21, 2015 at 9:39
  • @RadekPostołowicz Result from psql: "sapling , , {pg_catalog} , postgres , 192.168.0.13 , 20290 , 192.168.0.3 , 5432 , 0 , "2015-05-21 12:00:20.422757+02" , postgres , "PostgreSQL 9.1.15 on x86_64-unknown-linux-gnu , compiled by gcc (Debian 4.7.2-5) 4.7.2 , 64-bit"" Result from java: sapling , , {pg_catalog} , postgres , 192.168.0.13 , 19955 , 192.168.0.3 , 5432 , 0 , "2015-05-21 12:00:20.422757+02" , postgres , "PostgreSQL 9.1.15 on x86_64-unknown-linux-gnu , compiled by gcc (Debian 4.7.2-5) 4.7.2 , 64-bit" Commented May 21, 2015 at 9:48
  • I am using the JDBC41 Postgresql Driver, Version 9.4-1201 driver from the postgres HP: jdbc.postgresql.org/download.html Commented May 21, 2015 at 9:54