Re: pgdump version mismatch error. server version: 13.0; pg_dump version: 12.4

Download postgres 13. pg dump 13 will be downloaded along with it On Sun, Nov 29, 2020 at 11:02 AM mark armon <1994hej...@gmail.com> wrote: > > where to get pg_dump 13.0? > > On Sat, Nov 28, 2020 at 9:47 PM Adrian Klaver > wrote: > >> On 11/28/20 8:12 AM, mark armon wrote: >> > >> > OS: Windows

Re: pgdump version mismatch error. server version: 13.0; pg_dump version: 12.4

where to get pg_dump 13.0? On Sat, Nov 28, 2020 at 9:47 PM Adrian Klaver wrote: > On 11/28/20 8:12 AM, mark armon wrote: > > > > OS: Windows > > issue: > > > https://stackoverflow.com/questions/14168920/how-to-fix-pg-dump-version-mismatch-errors > > < > https://stackoverflow.com/questions/141689

Re: How to debug authentication issues in Postgres

Thanks. I will On Sat, Nov 28, 2020 at 9:49 PM Adrian Klaver wrote: > On 11/28/20 8:11 AM, Hemil Ruparel wrote: > > I am unable to connect using Java in general. And DataGrip runs on Java > > as far as I know. My backend in python runs perfectly fine using the > > psycopg2 library (postgres driv

Re: How to debug authentication issues in Postgres

On 11/28/20 8:11 AM, Hemil Ruparel wrote: I am unable to connect using Java in general. And DataGrip runs on Java as far as I know. My backend in python runs perfectly fine using the psycopg2 library (postgres driver for python). At this point I would file an issue here: https://github.com/pg

Re: pgdump version mismatch error. server version: 13.0; pg_dump version: 12.4

On 11/28/20 8:12 AM, mark armon wrote: OS: Windows issue: https://stackoverflow.com/questions/14168920/how-to-fix-pg-dump-version-mismatch-errors |pg_dump: error: server version: 13.0; pg_dump version:

pgdump version mismatch error. server version: 13.0; pg_dump version: 12.4

OS: Windows issue: https://stackoverflow.com/questions/14168920/how-to-fix-pg-dump-version-mismatch-errors pg_dump: error: server version: 13.0; pg_dump version: 12.4 pg_dump: error: aborting because of server version mismatch - - - -

Re: How to debug authentication issues in Postgres

I am unable to connect using Java in general. And DataGrip runs on Java as far as I know. My backend in python runs perfectly fine using the psycopg2 library (postgres driver for python). I was actually changing the database name and user name On Sat, Nov 28, 2020 at 9:28 PM Adrian Klaver wrote:

Re: How to debug authentication issues in Postgres

On 11/28/20 6:10 AM, Hemil Ruparel wrote: Line 88 is this line: host    database    user 0.0.0.0/0               scram-sha-256. I might have forgotten to change one of the names in the earlier mails. Change from what? This should just be a copy and paste or am I missing s

Re: How to debug authentication issues in Postgres

On 11/28/20 6:08 AM, Hemil Ruparel wrote: I commented out scram-sha-256 lines for IPv4 and IPv6. I still got authentication failure. The log output now says: FATAL:  password authentication failed for user "centos" DETAIL:  Connection matched pg_hba.conf line 89: "host       database user 0.

Re: How to debug authentication issues in Postgres

This seems extremely odd. I can connect to my database using python's psycopg2 library. Most likely this is either an extremely stupid mistake on my side, or worst case some edge condition jdbc doesnt handle? On Sat, Nov 28, 2020 at 7:40 PM Hemil Ruparel wrote: > Line 88 is this line: hostda

Re: How to debug authentication issues in Postgres

Line 88 is this line: hostdatabaseuser 0.0.0.0/0 scram-sha-256. I might have forgotten to change one of the names in the earlier mails. On Sat, Nov 28, 2020 at 7:38 PM Hemil Ruparel wrote: > I commented out scram-sha-256 lines for IPv4 and IPv6. I still got > authentication

Re: How to debug authentication issues in Postgres

I commented out scram-sha-256 lines for IPv4 and IPv6. I still got authentication failure. The log output now says: FATAL: password authentication failed for user "centos" DETAIL: Connection matched pg_hba.conf line 89: "host database user 0.0.0.0/0 md5" On Sat, Nov

Re: How to debug authentication issues in Postgres

Yes. Password encryption is set to scram-sha-256. On Fri, Nov 27, 2020 at 10:36 PM Adrian Klaver wrote: > On 11/27/20 12:37 AM, Hemil Ruparel wrote: > > The log says: > > > FATAL: password authentication failed for user "centos" > > > DETAIL: Connection matched pg_hba.conf line 88: "host