Re: SSL Enablement in Postgres via Client App like PG-ADMIN-4, Java.

2023-05-05 Thread Adrian Klaver
On 5/5/23 06:49, sujay kadam wrote: Hi Team. I have enabled SSL in postgres on a different port using pgbouncer. I have changed the default port to 6432 and made it SSL enabled and configured pgbouncer to listen port 5432 which is non-ssl. But we are connecting directly using port, not by up

Re: SSL Enablement in Postgres via Client App like PG-ADMIN-4, Java.

2023-05-05 Thread Jeffrey Walton
On Fri, May 5, 2023 at 9:50 AM sujay kadam wrote: > > I have enabled SSL in postgres on a different port using pgbouncer. > > I have changed the default port to 6432 and made it SSL enabled and > configured pgbouncer to listen port 5432 which is non-ssl. > > But we are connecting directly using p

SSL Enablement in Postgres via Client App like PG-ADMIN-4, Java.

2023-05-05 Thread sujay kadam
Hi Team. I have enabled SSL in postgres on a different port using pgbouncer. I have changed the default port to 6432 and made it SSL enabled and configured pgbouncer to listen port 5432 which is non-ssl. But we are connecting directly using port, not by uploading a certificate or setting up SSL

Re: PG Admin 4

2020-07-10 Thread Miles Elam
. > > We're running on a Windows platform. > > We're trying to avoid running anything command-line when doing DDL releases > and leverage whatever PG Admin 4 can provide us. I'm just wondering why we > don't see the results of each CREATE or ALTER statement as

Re: PG Admin 4

2020-07-10 Thread Susan Hurst
87 563420 > > On 10/07/2020 17:36, rwest wrote: > >> Oh sorry, should have specified that. >> >> We're running on a Windows platform. >> >> We're trying to avoid running anything command-line when doing DDL releases >> and leverage whatev

Re: PG Admin 4

2020-07-10 Thread Adrian Klaver
On 7/10/20 12:54 PM, Robert West wrote: Yes...all that is in there is the same results for the entire batch..no intermediate results for each piece of DDL. Hmm, that is something you might have to ask here: https://www.pgadmin.org/support/list/ > I'm submitting a large series of DDL chan

Re: PG Admin 4

2020-07-10 Thread Tim Clarke
g anything command-line when doing DDL releases and leverage whatever PG Admin 4 can provide us. I'm just wondering why we don't see the results of each CREATE or ALTER statement as the script runs in the tool. That seems very strange to me. Is there some sort of setting or parameter tha

Re: PG Admin 4

2020-07-10 Thread rwest
Oh sorry, should have specified that. We're running on a Windows platform. We're trying to avoid running anything command-line when doing DDL releases and leverage whatever PG Admin 4 can provide us. I'm just wondering why we don't see the results of each CREATE or ALTER sta

RE: PG Admin 4

2020-07-10 Thread Robert West
al Message- From: Adrian Klaver Sent: Friday, July 10, 2020 1:47 PM To: Robert West ; pgsql-gene...@postgresql.org Subject: Re: PG Admin 4 ATTENTION: This email was sent from an external source. Please exercise caution when opening attachments or clicking links. On 7/10/20 8:53 AM, rwest wr

Re: PG Admin 4

2020-07-10 Thread rwest
Ah, sorry that i didn't specify. I'm running on a Windows platform. We're trying to avoid running in a command-line mode if possible, and leverage the options PG Admin 4 has available to us. Just find it odd that it doesn't report out each Create or Alter statement as it

Re: PG Admin 4

2020-07-10 Thread Adrian Klaver
On 7/10/20 8:53 AM, rwest wrote: I'm relatively new to PostgreSql and am trying to navigate my way around the tools like PG Admin 4 to do Database Admin work. I'm trying to run an entire set of DDL with lots of tables, indexes, etc. through PG Admin 4 for a database. The only thing I

Re: PG Admin 4

2020-07-10 Thread Rob Sargent
On 7/10/20 9:53 AM, rwest wrote: I'm relatively new to PostgreSql and am trying to navigate my way around the tools like PG Admin 4 to do Database Admin work. I'm trying to run an entire set of DDL with lots of tables, indexes, etc. through PG Admin 4 for a database. The only t

PG Admin 4

2020-07-10 Thread rwest
I'm relatively new to PostgreSql and am trying to navigate my way around the tools like PG Admin 4 to do Database Admin work. I'm trying to run an entire set of DDL with lots of tables, indexes, etc. through PG Admin 4 for a database. The only thing I saw after I ran the script was