Re: Connection Issue

On 8/2/24 9:55 AM, Andy Hartman wrote: How do I get latest and greatest? Go to the previously shown link and read the Installation section. On Fri, Aug 2, 2024 at 12:52 PM Adrian Klaver > wrote: On 8/2/24 9:47 AM, Andy Hartman wrote: Please do

Re: Connection Issue

On 8/2/24 9:47 AM, Andy Hartman wrote: Please don't top post. Use inline or bottom posting. Looks like 4.5 From here: https://www.npgsql.org/doc/performance.html Release notes I see 4.1 and 5.0, no 4.5 My bet 4.5 is the NET version you are working with. -- Adrian Klaver adrian.kla...

Re: Connection Issue

On 8/2/24 9:32 AM, Andy Hartman wrote: How can I tell that? I don't use NET or npgsql so I getting out of my depth here. The first thing I would do is look at the package/installer you used to load npgsql for version info. Second look at Installed Software and see if the version is repor

Re: Connection Issue

How can I tell that? Thanks. On Fri, Aug 2, 2024 at 12:18 PM Adrian Klaver wrote: > > > On 8/2/24 9:00 AM, Andy Hartman wrote: > Reply to list also. > Ccing list. > > I changed to md5 and I can connect via HeideSQL interface no problem > > Changed what to md5? > > The issue is with Npgsql(?) t

Re: Connection Issue

On 8/2/24 9:00 AM, Andy Hartman wrote: Reply to list also. Ccing list. I changed to md5 and I can connect via HeideSQL interface no problem Changed what to md5? The issue is with Npgsql(?) though. What is the Npgsql version? On Fri, Aug 2, 2024 at 11:05 AM Adrian Klaver

Re: Impact from removal of pgadmin4

Thanks for the deep insight. You are better than OpenChat gpt 4. Happy Friday. On Fri, Aug 2, 2024, 8:53 AM Ron Johnson wrote: > On Fri, Aug 2, 2024 at 3:57 AM Vince McMahon < > sippingonesandze...@gmail.com> wrote: > >> In windows, when the pgadmin4 is removed, will it remove the libraries >>

Re: Subscribe to mailing list - General Question

Adrian Klaver writes: > On 8/1/24 20:53, Sindhu Selvaraj wrote: >> I am reporting this as a bug. Please keep us updated. > That should be done here: > https://www.postgresql.org/account/submitbug/ > FYI, you will need to set up a community account to do that. I think this is the same thing that

Re: Subscribe to mailing list - General Question

On 8/1/24 20:53, Sindhu Selvaraj wrote: In 15.7 and 16.3 Release Notes, I found a change to an unlogged table's sequence. This has been spotted in local postgres installed in MAC as well as in AWS RDS. We had to change the unlogged table to logged and then upgrade. I am reporting this as

Re: Connection Issue

On 8/2/24 07:56, Andy Hartman wrote: I'm using a Powershell script to connect to a remote 16.3(windows) version of the DB. Add-type -path 'C:\Program Files (x86)\PostgreSQL\Npgsql\bin\net451\Npgsql.dll' # Define connection strings for MS SQL and PostgreSQL $pgsqlConnectionString = "Host=xxx

Connection Issue

I'm using a Powershell script to connect to a remote 16.3(windows) version of the DB. Add-type -path 'C:\Program Files (x86)\PostgreSQL\Npgsql\bin\net451\Npgsql.dll' # Define connection strings for MS SQL and PostgreSQL $pgsqlConnectionString = "Host=xx;Port=5432;Username=xxx;Password=xx;Data

Subscribe to mailing list - General Question

In 15.7 and 16.3 Release Notes, I found a change to an unlogged table's sequence. Make ALTER TABLE ... ADD COLUMN create identity/serial sequences with the same persistence as their owning tables (Peter Eisentraut) CREATE UNLOGGED TABLE will make any owned sequences be unlogged too. ALTER TABLE m

Re: Impact from removal of pgadmin4

On Fri, Aug 2, 2024 at 3:57 AM Vince McMahon wrote: > In windows, when the pgadmin4 is removed, will it remove the libraries > from that windows? > > Basically, I have other database applications installed to get and to set > data into postgres db. Will removing of pgadmin4 remove the odbc, jdbc

Re: Windows installation problem at post-install step

On Mon, Jul 22, 2024 at 6:10 PM Sandeep Thakkar < sandeep.thak...@enterprisedb.com> wrote: > > > On Mon, Jul 22, 2024 at 5:52 PM Ertan Küçükoglu > wrote: > >> Sandeep Thakkar , 22 Tem 2024 Pzt, >> 15:01 tarihinde şunu yazdı: >> >>> >>> When I checked the installation log shared by Ertan, I do see

Re: PgBackRest PTR recovery: After table drop to get dropped state

Hi On Fri, Aug 2, 2024 at 1:28 PM KK CHN wrote: > Thank you for shedding light on this. > > On Thu, Aug 1, 2024 at 4:04 PM Mateusz Henicz > wrote: > >> When you are performing PITR you need to configure a timestamp before >> your last committed transaction. In your case you provided timestamp a

Re: PgBackRest PTR recovery: After table drop to get dropped state

Thank you for shedding light on this. On Thu, Aug 1, 2024 at 4:04 PM Mateusz Henicz wrote: > When you are performing PITR you need to configure a timestamp before your > last committed transaction. In your case you provided timestamp after your > last commit. > > I am trying to understand this

Impact from removal of pgadmin4

In windows, when the pgadmin4 is removed, will it remove the libraries from that windows? Basically, I have other database applications installed to get and to set data into postgres db. Will removing of pgadmin4 remove the odbc, jdbc drivers these application use? Thanks.

Re: VACUUM on temp table blocks VACUUM on another...

*PGDG On Fri, 2 Aug 2024 at 08:38, Jim Vanns wrote: > Official PGDB RPM build for Centos 7.9 > > On Thu, 1 Aug 2024 at 23:31, Adrian Klaver > wrote: > >> On 8/1/24 15:13, Jim Vanns wrote: >> > PG 15.4 >> >> Community edition or some variant? >> >> >> >> >> -- >> Adrian Klaver >> adrian.kla...@a

Re: VACUUM on temp table blocks VACUUM on another...

Official PGDB RPM build for Centos 7.9 On Thu, 1 Aug 2024 at 23:31, Adrian Klaver wrote: > On 8/1/24 15:13, Jim Vanns wrote: > > PG 15.4 > > Community edition or some variant? > > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > > -- Jim Vanns Principal Production Engineer Industrial Lig