Translators: Release next week (v8.13)

[Akshay Joshi]

Hi Translators,

We will have a release next week, so updating translations before the
release would be helpful. The template and catalogs have been updated in
Git. As we have moved to GitHub, you can raise the PR request. You can also
send the patches on pgadmin-hackers.

*Note:* We generally create our candidate builds on Monday (2 PM IST), so
please send the translation file by Monday 1:00 PM IST.


Akshay Joshi

Principle Software Architect

enterprisedb.com

*  Blog*: https://www.enterprisedb.com/akshay-joshi
*  GitHub*: https://github.com/akshay-joshi
*  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216

Re: pgAdmin4 v8.13 candidate builds

[Akshay Joshi]

The latest candidate builds and source code is available at
https://developer.pgadmin.org/builds/2024-10-17-1/

On Thu, Oct 17, 2024 at 5:26 PM Devrim Gündüz  wrote:

> Hi,
>
> They are already in the repos.
>
>
> On 17 October 2024 13:43:41 GMT+03:00, Akshay Joshi <
> akshay.jo...@enterprisedb.com> wrote:
>
>> Hi Devrim
>>
>> When should I start the pgAdmin 4 build?
>>
>> On Thu, Oct 17, 2024 at 4:11 PM Devrim Gündüz  wrote:
>>
>>> Should be fixed in 17.0-43 package.
>>>
>>>
>>> On 17 October 2024 10:06:09 GMT+03:00, Dave Page 
>>> wrote:
>>>
>>>> Devrim, can you assist with this please?
>>>>
>>>>
>>>> On Thu, 17 Oct 2024 at 07:57, Akshay Joshi <
>>>> akshay.jo...@enterprisedb.com> wrote:
>>>>
>>>>> Hi All,
>>>>>
>>>>> We encountered an issue during the installation of pgAdmin 4 on Fedora
>>>>> when any version of PostgreSQL is already installed. We are getting
>>>>> below error:
>>>>>
>>>>> Error: Transaction test error: file /usr/share/pgsql/postgres.bki from
>>>>> install of libpq5-17.0-42PGDG.f39.x86_64 conflicts with file from package
>>>>> postgresql-server-15.6-1.fc39.x86_64 file
>>>>> /usr/share/pgsql/system_constraints.sql from install of
>>>>> libpq5-17.0-42PGDG.f39.x86_64 conflicts with file from package
>>>>> postgresql-server-15.6-1.fc39.x86_64
>>>>>
>>>>> We are trying to fix the above error. We will have to reschedule the
>>>>> release until this issue is resolved. If it will resolve today then we 
>>>>> will
>>>>> release pgAdmin tomorrow.
>>>>>
>>>>> On Wed, Oct 16, 2024 at 11:57 PM Usman Khan  wrote:
>>>>>
>>>>>> Sorry it was my bad, I forgot to mention details.
>>>>>>
>>>>>> The detail is as following
>>>>>> *Server *: "PostgreSQL 16.4, compiled by Visual C++ build 1940,
>>>>>> 64-bit"
>>>>>> *STEPS:*
>>>>>> 1. Create a new database 'test1'
>>>>>> 2. Create a new schema 'testscheme' in 'test1' and create a single
>>>>>> table with a single column type integer.
>>>>>> 3. Create a backup with default values through pgadmin4 context menu
>>>>>> 4. Create another database 'test2'
>>>>>> 5.Restore the backup created at step 3. above through the context
>>>>>> menu of the tree with default values on the dialogue.
>>>>>>
>>>>>>
>>>>>> On Wed, Oct 16, 2024 at 8:42 PM Ashesh Vashi <
>>>>>> ashesh.va...@enterprisedb.com> wrote:
>>>>>>
>>>>>>> Please mentioned the database server version, and probably the steps
>>>>>>> to reproduction.
>>>>>>>
>>>>>>> --
>>>>>>>
>>>>>>> Thanks & Regards,
>>>>>>>
>>>>>>> Ashesh Vashi
>>>>>>> EnterpriseDB INDIA: Enterprise PostgreSQL Company
>>>>>>> <http://www.enterprisedb.com>
>>>>>>>
>>>>>>>
>>>>>>> *http://www.linkedin.com/in/asheshvashi*
>>>>>>> <http://www.linkedin.com/in/asheshvashi>
>>>>>>>
>>>>>>>
>>>>>>> On Wed, 16 Oct 2024 at 19:23, Usman Khan  wrote:
>>>>>>>
>>>>>>>> Verified, the issue related to digital signature is fixed.
>>>>>>>>
>>>>>>>> I have encountered the following error while restoring a very
>>>>>>>> simple database .
>>>>>>>>
>>>>>>>> [image: image.png]
>>>>>>>>
>>>>>>>> I tried with 8.12 with the same steps and it was successful.
>>>>>>>>
>>>>>>>>
>>>>>>>> On Tue, Oct 15, 2024 at 5:10 PM Akshay Joshi <
>>>>>>>> akshay.jo...@enterprisedb.com> wrote:
>>>>>>>>
>>>>>>>>> Hi All
>>>>>>>>>
>>>>>>>>> We have found one issue on Windows where the Digital Signature is
>>>>>>>>> missing. We have fixed it.
>>>>>>>>>
>>>>>>>>> The latest candidate builds and source code is available at
>>>>>>>>> https://developer.pgadmin.org/builds/2024-10-15-1/
>>>>>>>>>
>>>>>>>>> On Mon, Oct 14, 2024 at 5:14 PM Akshay Joshi <
>>>>>>>>> akshay.jo...@enterprisedb.com> wrote:
>>>>>>>>>
>>>>>>>>>> Hi All,
>>>>>>>>>>
>>>>>>>>>> pgAdmin4 v8.13 candidate builds and source code is available at
>>>>>>>>>> https://developer.pgadmin.org/builds/2024-10-14-1/
>>>>>>>>>>
>>>>>>>>>> Yogesh, could you please verify this for Thursday's release?
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Akshay Joshi
>>>>>>>>>>
>>>>>>>>>> Principle Software Architect
>>>>>>>>>>
>>>>>>>>>> enterprisedb.com
>>>>>>>>>>
>>>>>>>>>> *  Blog*: https://www.enterprisedb.com/akshay-joshi
>>>>>>>>>> *  GitHub*: https://github.com/akshay-joshi
>>>>>>>>>> *  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216
>>>>>>>>>>
>>>>>>>>>

Re: pgAdmin4 v8.13 candidate builds

[Akshay Joshi]

Hi Devrim

When should I start the pgAdmin 4 build?

On Thu, Oct 17, 2024 at 4:11 PM Devrim Gündüz  wrote:

> Should be fixed in 17.0-43 package.
>
>
> On 17 October 2024 10:06:09 GMT+03:00, Dave Page 
> wrote:
>
>> Devrim, can you assist with this please?
>>
>>
>> On Thu, 17 Oct 2024 at 07:57, Akshay Joshi 
>> wrote:
>>
>>> Hi All,
>>>
>>> We encountered an issue during the installation of pgAdmin 4 on Fedora
>>> when any version of PostgreSQL is already installed. We are getting
>>> below error:
>>>
>>> Error: Transaction test error: file /usr/share/pgsql/postgres.bki from
>>> install of libpq5-17.0-42PGDG.f39.x86_64 conflicts with file from package
>>> postgresql-server-15.6-1.fc39.x86_64 file
>>> /usr/share/pgsql/system_constraints.sql from install of
>>> libpq5-17.0-42PGDG.f39.x86_64 conflicts with file from package
>>> postgresql-server-15.6-1.fc39.x86_64
>>>
>>> We are trying to fix the above error. We will have to reschedule the
>>> release until this issue is resolved. If it will resolve today then we will
>>> release pgAdmin tomorrow.
>>>
>>> On Wed, Oct 16, 2024 at 11:57 PM Usman Khan  wrote:
>>>
>>>> Sorry it was my bad, I forgot to mention details.
>>>>
>>>> The detail is as following
>>>> *Server *: "PostgreSQL 16.4, compiled by Visual C++ build 1940, 64-bit"
>>>> *STEPS:*
>>>> 1. Create a new database 'test1'
>>>> 2. Create a new schema 'testscheme' in 'test1' and create a single
>>>> table with a single column type integer.
>>>> 3. Create a backup with default values through pgadmin4 context menu
>>>> 4. Create another database 'test2'
>>>> 5.Restore the backup created at step 3. above through the context menu
>>>> of the tree with default values on the dialogue.
>>>>
>>>>
>>>> On Wed, Oct 16, 2024 at 8:42 PM Ashesh Vashi <
>>>> ashesh.va...@enterprisedb.com> wrote:
>>>>
>>>>> Please mentioned the database server version, and probably the steps
>>>>> to reproduction.
>>>>>
>>>>> --
>>>>>
>>>>> Thanks & Regards,
>>>>>
>>>>> Ashesh Vashi
>>>>> EnterpriseDB INDIA: Enterprise PostgreSQL Company
>>>>> <http://www.enterprisedb.com>
>>>>>
>>>>>
>>>>> *http://www.linkedin.com/in/asheshvashi*
>>>>> <http://www.linkedin.com/in/asheshvashi>
>>>>>
>>>>>
>>>>> On Wed, 16 Oct 2024 at 19:23, Usman Khan  wrote:
>>>>>
>>>>>> Verified, the issue related to digital signature is fixed.
>>>>>>
>>>>>> I have encountered the following error while restoring a very simple
>>>>>> database .
>>>>>>
>>>>>> [image: image.png]
>>>>>>
>>>>>> I tried with 8.12 with the same steps and it was successful.
>>>>>>
>>>>>>
>>>>>> On Tue, Oct 15, 2024 at 5:10 PM Akshay Joshi <
>>>>>> akshay.jo...@enterprisedb.com> wrote:
>>>>>>
>>>>>>> Hi All
>>>>>>>
>>>>>>> We have found one issue on Windows where the Digital Signature is
>>>>>>> missing. We have fixed it.
>>>>>>>
>>>>>>> The latest candidate builds and source code is available at
>>>>>>> https://developer.pgadmin.org/builds/2024-10-15-1/
>>>>>>>
>>>>>>> On Mon, Oct 14, 2024 at 5:14 PM Akshay Joshi <
>>>>>>> akshay.jo...@enterprisedb.com> wrote:
>>>>>>>
>>>>>>>> Hi All,
>>>>>>>>
>>>>>>>> pgAdmin4 v8.13 candidate builds and source code is available at
>>>>>>>> https://developer.pgadmin.org/builds/2024-10-14-1/
>>>>>>>>
>>>>>>>> Yogesh, could you please verify this for Thursday's release?
>>>>>>>>
>>>>>>>>
>>>>>>>> Akshay Joshi
>>>>>>>>
>>>>>>>> Principle Software Architect
>>>>>>>>
>>>>>>>> enterprisedb.com
>>>>>>>>
>>>>>>>> *  Blog*: https://www.enterprisedb.com/akshay-joshi
>>>>>>>> *  GitHub*: https://github.com/akshay-joshi
>>>>>>>> *  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216
>>>>>>>>
>>>>>>>

Re: pgAdmin4 v8.13 candidate builds

[Akshay Joshi]

On Wed, Oct 16, 2024 at 12:23 PM Usman Khan  wrote:

> Hi Akshay,
> Any bug reported for this issue for reference?
> I would be able to revery after 5:00PM PST.
>

The bug is not reported for this. This is the first step we generally
test after downloading the installer.

>
> On Tue, Oct 15, 2024 at 5:10 PM Akshay Joshi <
> akshay.jo...@enterprisedb.com> wrote:
>
>> Hi All
>>
>> We have found one issue on Windows where the Digital Signature is
>> missing. We have fixed it.
>>
>> The latest candidate builds and source code is available at
>> https://developer.pgadmin.org/builds/2024-10-15-1/
>>
>> On Mon, Oct 14, 2024 at 5:14 PM Akshay Joshi <
>> akshay.jo...@enterprisedb.com> wrote:
>>
>>> Hi All,
>>>
>>> pgAdmin4 v8.13 candidate builds and source code is available at
>>> https://developer.pgadmin.org/builds/2024-10-14-1/
>>>
>>> Yogesh, could you please verify this for Thursday's release?
>>>
>>>
>>> Akshay Joshi
>>>
>>> Principle Software Architect
>>>
>>> enterprisedb.com
>>>
>>> *  Blog*: https://www.enterprisedb.com/akshay-joshi
>>> *  GitHub*: https://github.com/akshay-joshi
>>> *  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216
>>>
>>

Re: pgAdmin4 v8.13 candidate builds

[Akshay Joshi]

Hi All

We have found one issue on Windows where the Digital Signature is missing.
We have fixed it.

The latest candidate builds and source code is available at
https://developer.pgadmin.org/builds/2024-10-15-1/

On Mon, Oct 14, 2024 at 5:14 PM Akshay Joshi 
wrote:

> Hi All,
>
> pgAdmin4 v8.13 candidate builds and source code is available at
> https://developer.pgadmin.org/builds/2024-10-14-1/
>
> Yogesh, could you please verify this for Thursday's release?
>
>
> Akshay Joshi
>
> Principle Software Architect
>
> enterprisedb.com
>
> *  Blog*: https://www.enterprisedb.com/akshay-joshi
> *  GitHub*: https://github.com/akshay-joshi
> *  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216
>

pgAdmin4 v8.13 candidate builds

[Akshay Joshi]

Hi All,

pgAdmin4 v8.13 candidate builds and source code is available at
https://developer.pgadmin.org/builds/2024-10-14-1/

Yogesh, could you please verify this for Thursday's release?


Akshay Joshi

Principle Software Architect

enterprisedb.com

*  Blog*: https://www.enterprisedb.com/akshay-joshi
*  GitHub*: https://github.com/akshay-joshi
*  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216

Re: Update translation for Indonesian pgAdmin

[Akshay Joshi]

Thanks Committed.

On Sun, Oct 13, 2024 at 8:51 PM Kira  wrote:

> Hello pgAdmin
>
> I just create an update for Indonesian messages.po
> 
> file on October,12, 2024. I send the updated translation in file
> attachment. Hope this translation can be merged and released soon.
>
> Thank you!
>
>

Re: Translators: Release next week (v8.13)

[Akshay Joshi]

Thanks Committed.

On Fri, Oct 11, 2024 at 9:17 PM  wrote:

> Hi,
>
> I updated the French translation for pgadmin 8.13
>
>
>
>
> De : Akshay Joshi 
> À : pgadmin-hackers 
> Sujet : Translators: Release next week (v8.13)
> Date : 10/10/2024 14:40:36 Europe/Paris
>
> Hi Translators,
>
> We will have a release next week, so updates to translations before the
> release would be helpful. The template and catalogs have been updated in
> Git. As we have moved to GitHub, you can raise the PR request. You can send
> the patches on pgadmin-hackers as well.
>
> *Note:* We generally create our candidate builds on Monday (2 PM IST), so
> please send the translation file by Monday 1:00 PM IST.
>
>
> Akshay Joshi
>
> Principle Software Architect
>
> enterprisedb.com
>
> *  Blog*: https://www.enterprisedb.com/akshay-joshi
> *  GitHub*: https://github.com/akshay-joshi
> *  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216
>
>

Translators: Release next week (v8.13)

[Akshay Joshi]

Hi Translators,

We will have a release next week, so updates to translations before the
release would be helpful. The template and catalogs have been updated in
Git. As we have moved to GitHub, you can raise the PR request. You can send
the patches on pgadmin-hackers as well.

*Note:* We generally create our candidate builds on Monday (2 PM IST), so
please send the translation file by Monday 1:00 PM IST.


Akshay Joshi

Principle Software Architect

enterprisedb.com

*  Blog*: https://www.enterprisedb.com/akshay-joshi
*  GitHub*: https://github.com/akshay-joshi
*  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216

Re: French translation for pgadmin

[Akshay Joshi]

Thanks committed.

On Thu, Oct 3, 2024 at 2:08 PM  wrote:

> Hi,
>
> I updated the French translation. I have attached the .po file.
> I used the template message catalog for pgadmin 8.12
>
>
> --
> Nicolas Letellier
>
>
> De : Akshay Joshi 
> À : nicolas.letell...@mailo.com
> Sujet : Re: French translation for pgadmin
> Date : 25/04/2024 14:30:39 Europe/Paris
> Copie à : pgadmin-hack...@postgresql.org
>
> Thanks, Nicolas,
>
> I'll be updating all the catalog files shortly, after which you can
> proceed to raise the PR for the French translation.
> Please check my email on "pgadmin-hackers" within the next half hour.
>
>
>>

pgAdmin 4 v8.12 Released

[Akshay Joshi]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.12.

This release of pgAdmin 4 includes 13 bug fixes and new features. For more
details please see the release notes at:

https://www.pgadmin.org/docs/pgadmin4/8.12/release_notes_8_12.html

pgAdmin is the leading Open Source graphical management tool for
PostgreSQL. For more information, please see:

https://www.pgadmin.org/

Notable changes in this release include:

Features:

   -

   Added feature to restore preferences to their default values.
   -

   Add a new config variable - ALLOW_SPECIAL_EMAIL_DOMAINS to allow special
   domains for pgAdmin user emails.
   -

   Allow running non-continuous selected SQL code blocks in the query tool.


Bugs/Housekeeping:

   -

   Fixed a security issue where the OAuth2 client ID and secret were
   exposed through the web browser (CVE-2024-9014).
   -

   Improved the extensibility of the SchemaView and DataGridView.
   -

   Fix the query tool restore connection issue on the server disconnection
   from the left side object explorer.
   -

   Revamp the current password saving implementation to a keyring and
   reduce repeated OS user password prompts.
   -

   Fixed an issue where users could not use pgAdmin if they did not have
   access to the management database.
   -

   Fixed an issue where servers listed in the servers.json file were being
   reimported upon container restart.
   -

   Added support for OIDC based OAuth2 authentication.
   -

   Fixed an issue where the cursor moves to the end of the line when
   editing input fields.
   -

   Fixed an issue where different client backend shows all SQL are the same.
   -

   Fixed an issue where the "Quit App" confirmation modal in desktop app is
   not respecting "Confirm on close or refresh?"


Builds for Windows and macOS are available now, along with a Python Wheel,

Docker Container, RPM, DEB Package, and source code tarball from:

https://www.pgadmin.org/download/

--

Akshay Joshi

pgAdmin Project

Re: pgAdmin4 v8.12 candidate builds

[Akshay Joshi]

Hi All,

The latest pgAdmin4 v8.12 candidate builds and source code is available at
https://developer.pgadmin.org/builds/2024-09-20-1/

Yogesh, could you please verify this for Monday's release?

On Wed, Sep 18, 2024 at 2:52 PM Akshay Joshi 
wrote:

> Hi All,
>
> We’ve encountered some issues with the candidate builds, and both bug
> fixing and testing are still in progress. As a result, we will need to
> delay the release by 1 or 2 days.
> We are now targeting to release v8.12 on either Friday, 20th September, or
> Monday, 23rd September.
>
> On Tue, Sep 17, 2024 at 11:52 AM Usman Khan  wrote:
>
>> Hi Hackers,
>> Due to some unavoidable circumstances, I would not be able to take part
>> in this release testing.
>>
>> On Mon, Sep 16, 2024 at 6:26 PM Akshay Joshi <
>> akshay.jo...@enterprisedb.com> wrote:
>>
>>> Hi All,
>>>
>>> pgAdmin4 v8.12 candidate builds and source code is available at
>>> https://developer.pgadmin.org/builds/2024-09-16-1/
>>>
>>> Yogesh, could you please verify this for Thursday's release?
>>>
>>>
>>>
>>> Akshay Joshi
>>>
>>> Principle Software Architect
>>>
>>> enterprisedb.com
>>>
>>> *  Blog*: https://www.enterprisedb.com/akshay-joshi
>>> *  GitHub*: https://github.com/akshay-joshi
>>> *  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216
>>>
>>

Re: pgAdmin4 v8.12 candidate builds

[Akshay Joshi]

Hi All,

We’ve encountered some issues with the candidate builds, and both bug
fixing and testing are still in progress. As a result, we will need to
delay the release by 1 or 2 days.
We are now targeting to release v8.12 on either Friday, 20th September, or
Monday, 23rd September.

On Tue, Sep 17, 2024 at 11:52 AM Usman Khan  wrote:

> Hi Hackers,
> Due to some unavoidable circumstances, I would not be able to take part in
> this release testing.
>
> On Mon, Sep 16, 2024 at 6:26 PM Akshay Joshi <
> akshay.jo...@enterprisedb.com> wrote:
>
>> Hi All,
>>
>> pgAdmin4 v8.12 candidate builds and source code is available at
>> https://developer.pgadmin.org/builds/2024-09-16-1/
>>
>> Yogesh, could you please verify this for Thursday's release?
>>
>>
>>
>> Akshay Joshi
>>
>> Principle Software Architect
>>
>> enterprisedb.com
>>
>> *  Blog*: https://www.enterprisedb.com/akshay-joshi
>> *  GitHub*: https://github.com/akshay-joshi
>> *  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216
>>
>

pgAdmin4 v8.12 candidate builds

[Akshay Joshi]

Hi All,

pgAdmin4 v8.12 candidate builds and source code is available at
https://developer.pgadmin.org/builds/2024-09-16-1/

Yogesh, could you please verify this for Thursday's release?



Akshay Joshi

Principle Software Architect

enterprisedb.com

*  Blog*: https://www.enterprisedb.com/akshay-joshi
*  GitHub*: https://github.com/akshay-joshi
*  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216

Translators: Release next week (v8.12)

[Akshay Joshi]

Hi Translators,

We will have a release next week, so updates to translations before the
release would be helpful. The template and catalogs have been updated in
Git. As we have moved to GitHub, you can raise the PR request. You can send
the patches on pgadmin-hackers as well.

*Note:* We generally create our candidate builds on Monday (2 PM IST), so
please send the translation file by Monday 1:00 PM IST.


Akshay Joshi

Principle Software Architect

enterprisedb.com

*  Blog*: https://www.enterprisedb.com/akshay-joshi
*  GitHub*: https://github.com/akshay-joshi
*  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216

pgAdmin 4 v8.11 Released

[Akshay Joshi]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.11.

This release of pgAdmin 4 includes 15 bug fixes and new features. For more
details please see the release notes at:

https://www.pgadmin.org/docs/pgadmin4/8.11/release_notes_8_11.html

pgAdmin is the leading Open Source graphical management tool for
PostgreSQL. For more information, please see:

https://www.pgadmin.org/

Notable changes in this release include:

Features:

   -

   Add a home button to the geometry viewer to set the original zoom level
   when the viewer is opened.



Bugs/Housekeeping:

   -

   Fixed an issue where refreshing the Schema Diff tool opened in a new tab
   caused an error.
   -

   Fix server heartbeat logging error after deleting the server.
   -

   Fixed an issue where the Generate Script ignored filter conditions when
   a parent node was selected.
   -

   Fixed an issue where delete object(shortcut key) affected both text and
   Object Explorer items.
   -

   Fix an issue where the ERD tool should be able to open saved pgerd file
   when using keyboard shortcuts.
   -

   Fixed an issue where the REVOKE statement in the create script was
   throwing an error if the role contained special characters.
   -

   Improve code highlighting in the query editor.
   -

   Fix an issue where the wheel package is not getting installed on the
   arm64-based macOS version < 14.
   -

   Fixed an issue where column resizing is not working in the search
   objects dialog
   -

   Fixed an issue where the value in the find box is not updating with
   selected text in the editor if the find is already open and re-triggered.


Builds for Windows and macOS are available now, along with a Python Wheel,

Docker Container, RPM, DEB Package, and source code tarball from:

https://www.pgadmin.org/download/

--

Akshay Joshi

pgAdmin Project

Re: pgAdmin4 v8.11 candidate builds

[Akshay Joshi]

Fixed a few more issues. The latest candidate builds and source code is
available at https://developer.pgadmin.org/builds/2024-08-20-2/

On Tue, Aug 20, 2024 at 2:37 PM Akshay Joshi 
wrote:

> Hi All,
>
> We have found an issue in Windows, RHEL, and Debian platforms in
> Dekstop mode, so have to regenerate the candidate build.
> The latest candidate builds and source code is available at
> https://developer.pgadmin.org/builds/2024-08-20-1/
>
> On Mon, Aug 19, 2024 at 11:53 PM Usman Khan  wrote:
>
>> Hi,
>> I will verify on ubuntu 24.04 and windows 11. Once it's finished I will
>> update here.
>>
>>
>> On Mon, Aug 19, 2024 at 5:48 PM Akshay Joshi <
>> akshay.jo...@enterprisedb.com> wrote:
>>
>>> Hi All,
>>>
>>> pgAdmin4 v8.11 candidate builds and source code is available at
>>> https://developer.pgadmin.org/builds/2024-08-19-1/
>>>
>>> Yogesh, could you please verify this for Thursday's release?
>>>
>>>
>>> Akshay Joshi
>>>
>>> Principle Software Architect
>>>
>>> enterprisedb.com
>>>
>>> *  Blog*: https://www.enterprisedb.com/akshay-joshi
>>> *  GitHub*: https://github.com/akshay-joshi
>>> *  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216
>>>
>>

Re: pgAdmin4 v8.11 candidate builds

[Akshay Joshi]

Hi All,

We have found an issue in Windows, RHEL, and Debian platforms in
Dekstop mode, so have to regenerate the candidate build.
The latest candidate builds and source code is available at
https://developer.pgadmin.org/builds/2024-08-20-1/

On Mon, Aug 19, 2024 at 11:53 PM Usman Khan  wrote:

> Hi,
> I will verify on ubuntu 24.04 and windows 11. Once it's finished I will
> update here.
>
>
> On Mon, Aug 19, 2024 at 5:48 PM Akshay Joshi <
> akshay.jo...@enterprisedb.com> wrote:
>
>> Hi All,
>>
>> pgAdmin4 v8.11 candidate builds and source code is available at
>> https://developer.pgadmin.org/builds/2024-08-19-1/
>>
>> Yogesh, could you please verify this for Thursday's release?
>>
>>
>> Akshay Joshi
>>
>> Principle Software Architect
>>
>> enterprisedb.com
>>
>> *  Blog*: https://www.enterprisedb.com/akshay-joshi
>> *  GitHub*: https://github.com/akshay-joshi
>> *  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216
>>
>

pgAdmin4 v8.11 candidate builds

[Akshay Joshi]

Hi All,

pgAdmin4 v8.11 candidate builds and source code is available at
https://developer.pgadmin.org/builds/2024-08-19-1/

Yogesh, could you please verify this for Thursday's release?


Akshay Joshi

Principle Software Architect

enterprisedb.com

*  Blog*: https://www.enterprisedb.com/akshay-joshi
*  GitHub*: https://github.com/akshay-joshi
*  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216

Translators: Release next week (v8.11)

[Akshay Joshi]

Hi Translators,

We will have a release next week, so updates to translations before the
release would be helpful. The template and catalogs have been updated in
Git. As we have moved to GitHub, you can raise the PR request. You can send
the patches on pgadmin-hackers as well.

*Note:* We generally create our candidate builds on Monday (2 PM IST), so
please send the translation file by Monday 1:00 PM IST.


Akshay Joshi

Principle Software Architect

enterprisedb.com

*  Blog*: https://www.enterprisedb.com/akshay-joshi
*  GitHub*: https://github.com/akshay-joshi
*  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216

pgAdmin 4 v8.10 Released

[Akshay Joshi]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.10.

This release of pgAdmin 4 includes 29 bug fixes and new features. For more
details please see the release notes at:

https://www.pgadmin.org/docs/pgadmin4/8.10/release_notes_8_10.html

pgAdmin is the leading Open Source graphical management tool for
PostgreSQL. For more information, please see:

https://www.pgadmin.org/

Note:- With this release, pgAdmin 4 has transitioned from NW.js to Electron.

Notable changes in this release include:

Features:

   -

   Add support for Postgres Server Logs for Text, CS, and JSON format in
   plain and tabular formats.
   -

   Add support for highlighting selection matches in the query editor.
   -

   Add a keyboard shortcut to close the active tab panel.


Bugs/Housekeeping:

   -

   Replace pgAdmin NW.js container with Electron container.
   -

   Ensure that pgAdmin 4 is compatible with PostgreSQL v17.
   -

   Fixed an issue where paste operation in query tool data grid should skip
   bytea columns and put the value as NULL instead.
   -

   Ensure pgAdmin never makes network requests to Google etc.
   -

   Fixed the permission denied issue for functions of the pgstattuple
   extension when accessing statistics with a non-admin user.
   -

   Updated entrypoint.sh to utilize the email-validator package for email
   validation.
   -

   Fixed an issue where users could not insert characters at the desired
   location, as it was added to the end of the line.
   -

   Fixed an issue where users could not autofill their saved passwords in
   the connect server dialog in the browser.
   -

   Fixed an issue where boolean values in node details of the graphical
   explain plan were not interpreted correctly.
   -

   Ensure that pgAdmin works when opened in an iframe.


Builds for Windows and macOS are available now, along with a Python Wheel,

Docker Container, RPM, DEB Package, and source code tarball from:

https://www.pgadmin.org/download/

--

Akshay Joshi

pgAdmin Project

Extending the release of version 8.10 by 4 days

[Akshay Joshi]

Hello Hackers,

Starting with version 8.10, we have transitioned from NW.js to Electron for
desktop mode and upgraded to React 18. Due to some issues we have
encountered, we are extending the release by 4 days. The new release date
is July 29, 2024.


Akshay Joshi

Principle Software Architect

enterprisedb.com

*  Blog*: https://www.enterprisedb.com/akshay-joshi
*  GitHub*: https://github.com/akshay-joshi
*  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216

Re: pgAdmin4 v8.10 candidate builds

[Akshay Joshi]

On Wed, Jul 24, 2024 at 5:58 PM Usman Khan  wrote:

> Thanks,
> Is there any pre req related to ELECTRON? Because for the previous
> releases I did not face any issue.
>

This is the first release with ELECTRON.

>
> On Wed, Jul 24, 2024 at 5:13 PM Aditya Toshniwal <
> aditya.toshni...@enterprisedb.com> wrote:
>
>> Sorry, my bad. I misread the screenshot with amd as arm. Will check once
>> at my end.
>>
>> On Wed, Jul 24, 2024 at 5:37 PM Usman Khan  wrote:
>>
>>> I am on following linux platform with architecture
>>>
>>> 
>>> root@ubuntu-VirtualBox:/home/ubuntu/Desktop# uname -m
>>> x86_64
>>> root@ubuntu-VirtualBox:/home/ubuntu/Desktop# cat /etc/os-release
>>> PRETTY_NAME="Ubuntu 24.04 LTS"
>>> NAME="Ubuntu"
>>> VERSION_ID="24.04"
>>> VERSION="24.04 LTS (Noble Numbat)"
>>> VERSION_CODENAME=noble
>>> ID=ubuntu
>>> ID_LIKE=debian
>>> HOME_URL="https://www.ubuntu.com/";
>>> SUPPORT_URL="https://help.ubuntu.com/";
>>> BUG_REPORT_URL="https://bugs.launchpad.net/ubuntu/";
>>> PRIVACY_POLICY_URL="
>>> https://www.ubuntu.com/legal/terms-and-policies/privacy-policy";
>>> UBUNTU_CODENAME=noble
>>> LOGO=ubuntu-logo
>>> root@ubuntu-VirtualBox:/home/ubuntu/Desktop#
>>>
>>> ---
>>>
>>> On Wed, Jul 24, 2024 at 5:00 PM Aditya Toshniwal <
>>> aditya.toshni...@enterprisedb.com> wrote:
>>>
>>>> Hi Usman,
>>>>
>>>> pgAdmin doesn't support ARM Linux yet. ARM is supported only for Mac.
>>>>
>>>> On Wed, Jul 24, 2024 at 5:20 PM Usman Khan  wrote:
>>>>
>>>>> I am not able to launch desktop pgadmin on ubuntu 24.04. Getting
>>>>> following error
>>>>>
>>>>> Web pgadmin4 working fine.
>>>>>
>>>>> On Wed, Jul 24, 2024 at 10:28 AM Usman Khan  wrote:
>>>>>
>>>>>> Hi Hackers,
>>>>>> I will verify the build on ubuntu 24.04 and windows 11.
>>>>>>
>>>>>> On Tue, Jul 23, 2024 at 5:32 PM Akshay Joshi <
>>>>>> akshay.jo...@enterprisedb.com> wrote:
>>>>>>
>>>>>>> Hi All,
>>>>>>>
>>>>>>> pgAdmin4 v8.10 candidate builds and source code is available at
>>>>>>> https://developer.pgadmin.org/builds/2024-07-23-1/
>>>>>>>
>>>>>>> Yogesh, could you please verify this for Thursday's release?
>>>>>>>
>>>>>>> *Note:-  We have transitioned from NW.js to Electron starting with
>>>>>>> this release.*
>>>>>>>
>>>>>>>
>>>>>>> Akshay Joshi
>>>>>>>
>>>>>>> Principle Software Architect
>>>>>>>
>>>>>>> enterprisedb.com
>>>>>>>
>>>>>>> *  Blog*: https://www.enterprisedb.com/akshay-joshi
>>>>>>> *  GitHub*: https://github.com/akshay-joshi
>>>>>>> *  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216
>>>>>>>
>>>>>>
>>>>
>>>> --
>>>> Thanks,
>>>> Aditya Toshniwal
>>>> pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
>>>> <https://www.enterprisedb.com/>
>>>> "Don't Complain about Heat, Plant a TREE"
>>>>
>>>
>>
>> --
>> Thanks,
>> Aditya Toshniwal
>> pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
>> <https://www.enterprisedb.com/>
>> "Don't Complain about Heat, Plant a TREE"
>>
>

Re: pgAdmin4 v8.10 candidate builds

[Akshay Joshi]

The new candidate builds and source code is available at
https://developer.pgadmin.org/builds/2024-07-24-1/

On Wed, Jul 24, 2024 at 10:58 AM Usman Khan  wrote:

> Hi Hackers,
> I will verify the build on ubuntu 24.04 and windows 11.
>
> On Tue, Jul 23, 2024 at 5:32 PM Akshay Joshi <
> akshay.jo...@enterprisedb.com> wrote:
>
>> Hi All,
>>
>> pgAdmin4 v8.10 candidate builds and source code is available at
>> https://developer.pgadmin.org/builds/2024-07-23-1/
>>
>> Yogesh, could you please verify this for Thursday's release?
>>
>> *Note:-  We have transitioned from NW.js to Electron starting with this
>> release.*
>>
>>
>> Akshay Joshi
>>
>> Principle Software Architect
>>
>> enterprisedb.com
>>
>> *  Blog*: https://www.enterprisedb.com/akshay-joshi
>> *  GitHub*: https://github.com/akshay-joshi
>> *  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216
>>
>

pgAdmin4 v8.10 candidate builds

[Akshay Joshi]

Hi All,

pgAdmin4 v8.10 candidate builds and source code is available at
https://developer.pgadmin.org/builds/2024-07-23-1/

Yogesh, could you please verify this for Thursday's release?

*Note:-  We have transitioned from NW.js to Electron starting with this
release.*


Akshay Joshi

Principle Software Architect

enterprisedb.com

*  Blog*: https://www.enterprisedb.com/akshay-joshi
*  GitHub*: https://github.com/akshay-joshi
*  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216

Translators: Release next week (v8.10)

[Akshay Joshi]

Hi Translators,

We will have a release next week, so updates to translations before the
release would be helpful. The template and catalogs have been updated in
Git. As we have moved to GitHub, you can raise the PR request. You can send
the patches on pgadmin-hackers as well.

*Note:* We generally create our candidate builds on Monday (2 PM IST), so
please send the translation file by Monday 1:00 PM IST.


Akshay Joshi

Principle Software Architect

enterprisedb.com

*  Blog*: https://www.enterprisedb.com/akshay-joshi
*  GitHub*: https://github.com/akshay-joshi
*  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216

Re: Next Library/Package update

[Akshay Joshi]

Hi All,

The next pgAdmin 4 release, v8.10, is scheduled for July 25, 2024. Based on
the EOL dates of the operating system in the previous email, we will
discontinue support for *Debian 10* and *Ubuntu 23.10* (with an updated EOL
of July 11) starting with this release. If anyone has any
objections/suggestions, please let us know.

On Tue, May 14, 2024 at 10:53 AM Pravesh Sharma <
pravesh.sha...@enterprisedb.com> wrote:

> Hi Team,
>
> I have reviewed the list of upcoming OS releases and EOL dates. Below are
> the details:
>
> Upcoming OS versions:
> 1. Fedora 40 - released on 23 Apr 2024
> 2. Ubuntu 24.04 - released on 25 Apr 2024
>
> OS nearing EOL:
> 1. Fedora 38 - 14 May 2024
> 2. Debian 10 - 30 Jun 2024
> 3. Ubuntu 23.10 - 01 Jul 2024
>
> Please note that Python 3.8 security support will end on 31 Oct 2024.
> I have referenced the details from here <https://endoflife.date/>.
>
> Regards,
> Pravesh Sharma
>
>
> On Thu, Apr 11, 2024 at 5:04 PM Pravesh Sharma <
> pravesh.sha...@enterprisedb.com> wrote:
>
>> Hi Dave/ Team,
>>
>> While updating to the latest Flask version, I found that support for
>> Python 3.7 has been dropped on most of the packages. Debian 10, which
>> defaults to Python 3.7, will reach its End of Life on 30th June 2024.
>> Should we drop support for Python 3.7 in the upcoming May release with the
>> package update, or should we wait?
>>
>>
>> @team Please share your suggestions.
>>
>>
>>
>> Regards,
>>
>> Pravesh
>>
>> On Wed, Jun 21, 2023 at 12:55 PM Akshay Joshi <
>> akshay.jo...@enterprisedb.com> wrote:
>>
>>> Hi Dave/Team
>>>
>>> Following things that we should update as the next big change:
>>>
>>>1. Flask and other dependent packages( Can't pick until we drop
>>>support for Python 3.7)
>>>2. WCDocker
>>>3. Mui 5
>>>    4. Code Mirror 6
>>>5. React Aspen tree with React Arborist (
>>>https://www.npmjs.com/package/react-arborist)
>>>
>>>
>>> --
>>> Akshay Joshi
>>> Principal Software Architect
>>> www.enterprisedb.com
>>>
>>> *Blog*: https://www.enterprisedb.com/akshay-joshi
>>> *GitHub*: https://github.com/akshay-joshi
>>> *LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216
>>>
>>
>>
>> --
>>
>> <http://www.enterprisedb.com>
>>
>> Pravesh Sharma
>>
>> Software Engineer
>>
>> +91 9406461406
>>
>> www.enterprisedb.com
>>
>> Power to Postgres
>>
>> <https://www.linkedin.com/company/edbpostgres>
>> <https://twitter.com/edbpostgres?lang=en>
>> <https://www.facebook.com/EDBpostgres>
>> <https://www.instagram.com/EDBpostgres/>
>>
>

pgAdmin 4 v8.9 Released

[Akshay Joshi]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.9.

This release of pgAdmin 4 includes 20 bug fixes and new features. For more
details please see the release notes at:

https://www.pgadmin.org/docs/pgadmin4/8.9/release_notes_8_9.html

pgAdmin is the leading Open Source graphical management tool for
PostgreSQL. For more information, please see:

https://www.pgadmin.org/

Notable changes in this release include:

Features:

   -

   Provide the option to set a theme based on OS theme preference.


Bugs/Housekeeping:

   -

   Remove the usage of MUI makeStyles as it doesn't support React 18.
   -

   Fix the permissions issue in the pgAdmin installation directory on
   Debian and RHEL-8 platforms (CVE-2024-6238).
   -

   Fixed an issue where resizable data editors in the query tool should not
   be allowed to resize beyond the app window bounds.
   -

   Ensure that a user can connect to a server using SSL certificates and
   identity files from a shared storage.
   -

   Fixed an issue where the dark theme shows a white background when all
   tabs are closed.
   -

   Fixed an issue where the schema diff incorrectly marked tables as
   different due to schema-qualified trigger functions in the trigger
   definitions.
   -

   Fixed an issue where backslash breaks syntax highlighting.
   -

   Fixed an issue where query tool shortcuts for find/replace are not
   working.
   -

   Fixed new line indentation in the query editor and added a user
   preference to disable it.
   -

   Fixed migration failure while using an external database.


Builds for Windows and macOS are available now, along with a Python Wheel,

Docker Container, RPM, DEB Package, and source code tarball from:

https://www.pgadmin.org/download/

--

Akshay Joshi

pgAdmin Project

Re: pgAdmin4 v8.9 candidate builds

[Akshay Joshi]

Hi All,

We have found one small issue in the 2FA dialog that is fixed. The latest
candidate builds and source code is available at
https://developer.pgadmin.org/builds/2024-06-25-1/


On Tue, Jun 25, 2024 at 2:45 PM Akshay Joshi 
wrote:

>
>
> On Tue, Jun 25, 2024 at 1:45 PM Usman Khan  wrote:
>
>> Hi Hackers,
>>
>> I performed the basic sanity for windows 11 and ubuntu 24.04. No issue
>> found.
>> I verified both the new installation and upgrade(from 8.7 to 8.9)
>> scenarios. Postgresql 16 is used.
>>
>
>Thanks.
>
>>
>> On Tue, Jun 25, 2024 at 6:48 AM Akshay Joshi <
>> akshay.jo...@enterprisedb.com> wrote:
>>
>>> Thanks Usman
>>>
>>> On Tue, 25 Jun, 2024, 12:28 am Usman Khan,  wrote:
>>>
>>>> Hi Hackers,
>>>> I am going to verify on Windows 11 and Ubuntu 24.04.
>>>>
>>>> On Mon, Jun 24, 2024 at 9:29 PM Akshay Joshi <
>>>> akshay.jo...@enterprisedb.com> wrote:
>>>>
>>>>> Hi All,
>>>>>
>>>>> pgAdmin4 v8.9 candidate builds and source code is available at
>>>>> https://developer.pgadmin.org/builds/2024-06-24-1/
>>>>>
>>>>> Yogesh, could you please verify this for Thursday's release?
>>>>>
>>>>>
>>>>>
>>>>> Akshay Joshi
>>>>>
>>>>> Principle Software Architect
>>>>>
>>>>> enterprisedb.com
>>>>>
>>>>> *  Blog*: https://www.enterprisedb.com/akshay-joshi
>>>>> *  GitHub*: https://github.com/akshay-joshi
>>>>> *  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216
>>>>>
>>>>

Re: pgAdmin4 v8.9 candidate builds

[Akshay Joshi]

On Tue, Jun 25, 2024 at 1:45 PM Usman Khan  wrote:

> Hi Hackers,
>
> I performed the basic sanity for windows 11 and ubuntu 24.04. No issue
> found.
> I verified both the new installation and upgrade(from 8.7 to 8.9)
> scenarios. Postgresql 16 is used.
>

   Thanks.

>
> On Tue, Jun 25, 2024 at 6:48 AM Akshay Joshi <
> akshay.jo...@enterprisedb.com> wrote:
>
>> Thanks Usman
>>
>> On Tue, 25 Jun, 2024, 12:28 am Usman Khan,  wrote:
>>
>>> Hi Hackers,
>>> I am going to verify on Windows 11 and Ubuntu 24.04.
>>>
>>> On Mon, Jun 24, 2024 at 9:29 PM Akshay Joshi <
>>> akshay.jo...@enterprisedb.com> wrote:
>>>
>>>> Hi All,
>>>>
>>>> pgAdmin4 v8.9 candidate builds and source code is available at
>>>> https://developer.pgadmin.org/builds/2024-06-24-1/
>>>>
>>>> Yogesh, could you please verify this for Thursday's release?
>>>>
>>>>
>>>>
>>>> Akshay Joshi
>>>>
>>>> Principle Software Architect
>>>>
>>>> enterprisedb.com
>>>>
>>>> *  Blog*: https://www.enterprisedb.com/akshay-joshi
>>>> *  GitHub*: https://github.com/akshay-joshi
>>>> *  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216
>>>>
>>>

Re: pgAdmin4 v8.9 candidate builds

[Akshay Joshi]

Thanks Usman

On Tue, 25 Jun, 2024, 12:28 am Usman Khan,  wrote:

> Hi Hackers,
> I am going to verify on Windows 11 and Ubuntu 24.04.
>
> On Mon, Jun 24, 2024 at 9:29 PM Akshay Joshi <
> akshay.jo...@enterprisedb.com> wrote:
>
>> Hi All,
>>
>> pgAdmin4 v8.9 candidate builds and source code is available at
>> https://developer.pgadmin.org/builds/2024-06-24-1/
>>
>> Yogesh, could you please verify this for Thursday's release?
>>
>>
>>
>> Akshay Joshi
>>
>> Principle Software Architect
>>
>> enterprisedb.com
>>
>> *  Blog*: https://www.enterprisedb.com/akshay-joshi
>> *  GitHub*: https://github.com/akshay-joshi
>> *  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216
>>
>

pgAdmin4 v8.9 candidate builds

[Akshay Joshi]

Hi All,

pgAdmin4 v8.9 candidate builds and source code is available at
https://developer.pgadmin.org/builds/2024-06-24-1/

Yogesh, could you please verify this for Thursday's release?



Akshay Joshi

Principle Software Architect

enterprisedb.com

*  Blog*: https://www.enterprisedb.com/akshay-joshi
*  GitHub*: https://github.com/akshay-joshi
*  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216

Translators: Release next week (v8.9)

[Akshay Joshi]

Hi Translators,

We will have a release next week, so updates to translations before the
release would be helpful. The template and catalogs have been updated in
Git. As we have moved to GitHub, you can raise the PR request. You can send
the patches on pgadmin-hackers as well.

*Note:* We generally create our candidate builds on Monday (2 PM IST), so
please send the translation file by Monday 1:00 PM IST.


Akshay Joshi

Principle Software Architect

enterprisedb.com

*  Blog*: https://www.enterprisedb.com/akshay-joshi
*  GitHub*: https://github.com/akshay-joshi
*  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216

pgAdmin 4 v8.8 Released

[Akshay Joshi]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.8.

This release of pgAdmin 4 includes 5 bug fixes. For more details please see
the release notes at:

https://www.pgadmin.org/docs/pgadmin4/8.8/release_notes_8_8.html

pgAdmin is the leading Open Source graphical management tool for
PostgreSQL. For more information, please see:

https://www.pgadmin.org/

Notable changes in this release include:

Bugs/Housekeeping:

   -

   Fix an issue where user authentication fails with special characters in
   the password.
   -

   Fixed an issue where canceling a query without privilege does not
   display any message on the query tool.
   -

   Fix the issue where docker with SSL v8.7 fails to start.
   -

   Fixed an issue where the size displayed as 'NaN B' for all databases in
   the statistics tab.
   -

   Fixed an issue where backup and restore operations failed with the error
   'This build does not support compression with gzip'.


Builds for Windows and macOS are available now, along with a Python Wheel,

Docker Container, RPM, DEB Package, and source code tarball from:

https://www.pgadmin.org/download/

--

Akshay Joshi

pgAdmin Project

Re: pgAdmin4 v8.8 candidate builds

[Akshay Joshi]

On Thu, Jun 6, 2024 at 10:47 AM Usman Khan  wrote:

> Hi,
> I have performed testing on windows 11, I performed basic sanity for
> following scenarios
> i) clean installation.
> ii) upgrade scenario from 8.7 to 8.8.
>
> Everything went well. There were two issues faced which I have reported
> separately.
>
> From the next release cycle, I will try to pick a couple of platforms and
> will let the team know in advance before testing so that overlap efforts
> can be avoided.
>

   Thanks, Usman for the support.

>
>
>
> On Wed, Jun 5, 2024 at 5:18 PM Akshay Joshi 
> wrote:
>
>> Hi All
>>
>> The latest pgAdmin4 v8.8 candidate builds and source code is available at
>> https://developer.pgadmin.org/builds/2024-06-05-1/
>>
>> On Wed, Jun 5, 2024 at 2:58 PM Aditya Toshniwal <
>> aditya.toshni...@enterprisedb.com> wrote:
>>
>>> Hi Usman,
>>>
>>> We're glad that you wish to help us in testing.
>>> Generally, Akshay will share the candidate builds link on email. You
>>> could test any supported platform.
>>> Testing involves upgrading existing pgAdmin and doing a basic sanity
>>> test. Same for a clean install pgAdmin.
>>>
>>> Let us know if you have any other questions.
>>>
>>>
>>> On Wed, Jun 5, 2024 at 9:13 AM Usman Khan  wrote:
>>>
>>>> Hi Hackers,
>>>> Can you please let me know the final testing process, I want to see
>>>> where I can contribute in my capacity in this regard.
>>>>
>>>> On Tue, Jun 4, 2024 at 7:22 PM Akshay Joshi <
>>>> akshay.jo...@enterprisedb.com> wrote:
>>>>
>>>>> Hi All,
>>>>>
>>>>> Due to some critical issues, the pgAdmin team has decided to release
>>>>> v8.8 ahead of schedule. pgAdmin4 v8.8 candidate builds and source code is
>>>>> available at https://developer.pgadmin.org/builds/2024-06-04-1/
>>>>>
>>>>> Yogesh, could you please verify this for Thursday's release?
>>>>>
>>>>>
>>>>> Akshay Joshi
>>>>>
>>>>> Principle Software Architect
>>>>>
>>>>> enterprisedb.com
>>>>>
>>>>> *  Blog*: https://www.enterprisedb.com/akshay-joshi
>>>>> *  GitHub*: https://github.com/akshay-joshi
>>>>> *  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216
>>>>>
>>>>
>>>
>>> --
>>> Thanks,
>>> Aditya Toshniwal
>>> pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
>>> <https://www.enterprisedb.com/>
>>> "Don't Complain about Heat, Plant a TREE"
>>>
>>

Re: pgAdmin4 v8.8 candidate builds

[Akshay Joshi]

Hi All

The latest pgAdmin4 v8.8 candidate builds and source code is available at
https://developer.pgadmin.org/builds/2024-06-05-1/

On Wed, Jun 5, 2024 at 2:58 PM Aditya Toshniwal <
aditya.toshni...@enterprisedb.com> wrote:

> Hi Usman,
>
> We're glad that you wish to help us in testing.
> Generally, Akshay will share the candidate builds link on email. You could
> test any supported platform.
> Testing involves upgrading existing pgAdmin and doing a basic sanity test.
> Same for a clean install pgAdmin.
>
> Let us know if you have any other questions.
>
>
> On Wed, Jun 5, 2024 at 9:13 AM Usman Khan  wrote:
>
>> Hi Hackers,
>> Can you please let me know the final testing process, I want to see where
>> I can contribute in my capacity in this regard.
>>
>> On Tue, Jun 4, 2024 at 7:22 PM Akshay Joshi <
>> akshay.jo...@enterprisedb.com> wrote:
>>
>>> Hi All,
>>>
>>> Due to some critical issues, the pgAdmin team has decided to release
>>> v8.8 ahead of schedule. pgAdmin4 v8.8 candidate builds and source code is
>>> available at https://developer.pgadmin.org/builds/2024-06-04-1/
>>>
>>> Yogesh, could you please verify this for Thursday's release?
>>>
>>>
>>> Akshay Joshi
>>>
>>> Principle Software Architect
>>>
>>> enterprisedb.com
>>>
>>> *  Blog*: https://www.enterprisedb.com/akshay-joshi
>>> *  GitHub*: https://github.com/akshay-joshi
>>> *  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216
>>>
>>
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
> <https://www.enterprisedb.com/>
> "Don't Complain about Heat, Plant a TREE"
>

pgAdmin4 v8.8 candidate builds

[Akshay Joshi]

Hi All,

Due to some critical issues, the pgAdmin team has decided to release v8.8
ahead of schedule. pgAdmin4 v8.8 candidate builds and source code is
available at https://developer.pgadmin.org/builds/2024-06-04-1/

Yogesh, could you please verify this for Thursday's release?


Akshay Joshi

Principle Software Architect

enterprisedb.com

*  Blog*: https://www.enterprisedb.com/akshay-joshi
*  GitHub*: https://github.com/akshay-joshi
*  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216

pgAdmin 4 v8.7 Released

[Akshay Joshi]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.7.

This release of pgAdmin 4 includes 19 bug fixes and new features. For more
details please see the release notes at:

https://www.pgadmin.org/docs/pgadmin4/8.7/release_notes_8_7.html

pgAdmin is the leading Open Source graphical management tool for
PostgreSQL. For more information, please see:

https://www.pgadmin.org/

Notable changes in this release include:

Features:

   -

   Added support for the 'Add to macros' feature and fixed various
   usability issues.
   -

   Added support for executing the query at the cursor position in the
   query tool.
   -

   Changes in Query Tool, Debugger, and ERD Tool shortcuts to remove the
   use of Accesskey which will allow them to be customized.
   -

   Added support for viewing PGD Clusters.
   -

   Enhance the Delete dialog by highlighting the names of the objects to be
   deleted in bold.
   -

   Added support for platform Ubuntu 24.04 and Fedora 40.



Bugs/Housekeeping:

   -

   Upgrade react-table from v7 to v8.
   -

   Ensure that Schema Diff does not indicate a table as different when the
   trigger names are the same but the trigger function body is different.
   -

   Fixed an issue of the pgAdmin window size increasing each time it was
   reopened.
   -

   Update the documentation for the preferences dialog and keyboard
   shortcuts.
   -

   Fixed an issue where pgAdmin fails to start when Ubuntu OS is upgraded
   to a major version.
   -

   Fixed incorrect highlighting for C-Style escape strings in SQL editor.
   -

   Fixed an issue where the recover password button was enabled even when
   no email was provided.
   -

   Fixed an issue where resetting the password from the password reset link
   was not working.


Builds for Windows and macOS are available now, along with a Python Wheel,

Docker Container, RPM, DEB Package, and source code tarball from:

https://www.pgadmin.org/download/

--

Akshay Joshi

pgAdmin Project

Re: pgAdmin4 v8.7 candidate builds

[Akshay Joshi]

Hi All,

We have fixed an issue found during testing. The latest candidate builds
and source code are now available at
https://developer.pgadmin.org/builds/2024-05-28-1/

On Mon, May 27, 2024 at 5:34 PM Akshay Joshi 
wrote:

> Hi All,
>
> pgAdmin4 v8.7 candidate builds and source code is available at
> https://developer.pgadmin.org/builds/2024-05-27-1/
>
> Yogesh, could you please verify this for Thursday's release?
>
>
> Akshay Joshi
>
> Principle Software Architect
>
> enterprisedb.com
>
> *  Blog*: https://www.enterprisedb.com/akshay-joshi
> *  GitHub*: https://github.com/akshay-joshi
> *  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216
>

pgAdmin4 v8.7 candidate builds

[Akshay Joshi]

Hi All,

pgAdmin4 v8.7 candidate builds and source code is available at
https://developer.pgadmin.org/builds/2024-05-27-1/

Yogesh, could you please verify this for Thursday's release?


Akshay Joshi

Principle Software Architect

enterprisedb.com

*  Blog*: https://www.enterprisedb.com/akshay-joshi
*  GitHub*: https://github.com/akshay-joshi
*  LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216

Translators: Release next week (v8.7)

[Akshay Joshi]

Hi Translators,

We will have a release next week, so updates to translations before the
release would be helpful. The template and catalogs have been updated in
Git. As we have moved to GitHub, you can raise the PR request. You can send
the patches on pgadmin-hackers as well.

*Note:* We generally create our candidate builds on Monday (2 PM IST), so
please send the translation file by Monday 1:00 PM IST.

--
Akshay Joshi
Principal Software Architect
www.enterprisedb.com

*Blog*: https://www.enterprisedb.com/akshay-joshi
*GitHub*: https://github.com/akshay-joshi
*LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216

[pgadmin-org/pgadmin4] f833ce: Trying to fix the OSX build failure

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: f833cea0dde0d64d24d722a71afcadb50f035297
  
https://github.com/pgadmin-org/pgadmin4/commit/f833cea0dde0d64d24d722a71afcadb50f035297
  Author: Akshay Joshi 
  Date:   2024-05-15 (Wed, 15 May 2024)

  Changed paths:
M pkg/mac/build-functions.sh

  Log Message:
  ---
  Trying to fix the OSX build failure



To unsubscribe from these emails, change your notification settings at 
https://github.com/pgadmin-org/pgadmin4/settings/notifications

pgAdmin 4 v8.6 Released

[Akshay Joshi]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.6.

This release of pgAdmin 4 includes 15 bug fixes and new features. For more
details please see the release notes at:

https://www.pgadmin.org/docs/pgadmin4/8.6/release_notes_8_6.html

pgAdmin is the leading Open Source graphical management tool for
PostgreSQL. For more information, please see:

https://www.pgadmin.org/

Notable changes in this release include:

*Features:*

   - Added the new columns "last_seq_scan" and "last_idx_scan" from the
   pg_stat_all_tables and pg_stat_all_indexes tables respectively to the
   Statistics tab.
   - Added support for excluding multiple tables while taking Backup.


*Bugs/Housekeeping:*

   - Fixed an XSS vulnerability in the /settings/store endpoint
   (CVE-2024-4216).
   - Fixed Multi-Factor Authentication bypass vulnerability (CVE-2024-4215).
   - Update UI library MUI from v4 to v5.
   - Upgraded Flask, Flask-Security-Too, Werkzeug, and other dependencies,
   ensuring compatibility with Python 3.7.
   - Fixed violates check constraint issue when creating a pgAgent schedule.
   - Fixed an issue where pressing backspace should remove the spaces and
   not the entire tab width, on enabling 'Use spaces?' in the preferences.
   - Fixed an issue where incorrect select/exec scripts were generated for
   functions/procedures.
   - Fixed an issue when closing the view data second tab; it raises the
   error that the 'ViewCommand' object has no attribute 'auto_commit'.
   - Install dbus-python, an in-direct dependency of the Keyring package as
   a system package for Debian platforms.


Builds for Windows and macOS are available now, along with a Python Wheel,
Docker Container, RPM, DEB Package, and source code tarball from:
https://www.pgadmin.org/download/

--
Akshay Joshi
pgAdmin Project

pgAdmin4 v8.6 candidate builds

[Akshay Joshi]

Hi All,

pgAdmin4 v8.6 candidate builds and source code is available at
https://developer.pgadmin.org/builds/2024-04-29-1/

Yogesh, could you please verify this for Thursday's release?

--
Akshay Joshi
Principal Software Architect
www.enterprisedb.com

*Blog*: https://www.enterprisedb.com/akshay-joshi
*GitHub*: https://github.com/akshay-joshi
*LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216

Translators: Release next week (v8.6)

[Akshay Joshi]

Hi Translators,

We will have a release next week, so updates to translations before the
release would be helpful. The template and catalogs have been updated in
Git. As we have moved to GitHub, you can raise the PR request. You can send
the patches on pgadmin-hackers as well.

*Note:* We generally create our candidate builds on Monday (2 PM IST), so
please send the translation file by Monday 1:00 PM IST.

--
Akshay Joshi
Principal Software Architect
www.enterprisedb.com

*Blog*: https://www.enterprisedb.com/akshay-joshi
*GitHub*: https://github.com/akshay-joshi
*LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216

Re: French translation for pgadmin

[Akshay Joshi]

Thanks, Nicolas,

I'll be updating all the catalog files shortly, after which you can proceed
to raise the PR for the French translation.
Please check my email on "pgadmin-hackers" within the next half hour.

On Thu, Apr 25, 2024 at 5:55 PM  wrote:

> Hello
>
> I would like to offer my participation to support the translation of the
> pgAdmin language files into French.
> I use pgAdmin every day for my work.
>
> For your information, I know Fred Escallier very well. I worked in the
> same company for 5 years. Now he has changed jobs. He became a farmer in
> the French Alps. It was Fred who asked me to take over his work as a
> translator for pgAdmin.
>
> Thanks.
> --
> Nicolas Letellier
>
>
>
>
>
>
>

pgAdmin 4 v8.5 Released

[Akshay Joshi]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.5.

This release of pgAdmin 4 includes 24 bug fixes and new features. For more
details please see the release notes at:

https://www.pgadmin.org/docs/pgadmin4/8.5/release_notes_8_5.html

pgAdmin is the leading Open Source graphical management tool for
PostgreSQL. For more information, please see:

https://www.pgadmin.org/

Notable changes in this release include:

Features:

   -

   Added support for EDB Job Scheduler.
   -

   Added support for viewing Log Based Clusters.
   -

   Added support for UNIX socket in entrypoint.sh for Docker implementation.
   -

   Added support for provider, deterministic, version, and RULES parameters
   while creating collation.



Bugs/Housekeeping:

   -

   Fixed a remote code execution issue in the validate binary path
   (CVE-2024-3116).
   -

   Fixed an issue in Schema Diff where Columns with sequences get altered
   unnecessarily.
   -

   Fixed schema diff wrong query generation for the table, foreign table,
   and sequence.
   -

   Fixed an issue where the maximize icon is missing from the query tool
   panel.
   -

   Fix an issue in the editor where the Format SQL shortcut and multiline
   selection are not working.
   -

   Fix an issue in the editor where the "Use Spaces?" preference of the
   Editor is not working.
   -

   Fixed an issue where Triggers, Rules, and Indexes were absent from the
   Schema Diff when comparing views.
   -

   Fixed an issue where taking a backup of a shared server was using the
   server owner's user name.
   -

   Fix an issue in the query tool where custom keyboard shortcuts are not
   working for some.


Builds for Windows and macOS are available now, along with a Python Wheel,

Docker Container, RPM, DEB Package, and source code tarball from:

https://www.pgadmin.org/download/

--

Akshay Joshi

pgAdmin Project

pgAdmin4 v8.5 candidate builds

[Akshay Joshi]

Hi All,

pgAdmin4 v8.5 candidate builds and source code is available at
https://developer.pgadmin.org/builds/2024-04-01-1/

Yogesh, could you please verify this for Thursday's release?


--
Akshay Joshi
Principal Software Architect
www.enterprisedb.com

*Blog*: https://www.enterprisedb.com/akshay-joshi
*GitHub*: https://github.com/akshay-joshi
*LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216

Translators: Release next week

[Akshay Joshi]

Hi Translators,

We will have a release next week, so updates to translations before the
release would be helpful. The template and catalogs have been updated in
Git. As we have moved to GitHub, you can raise the PR request. You can send
the patches on pgadmin-hackers as well.

*Note:* We generally create our candidate builds on Monday (2 PM IST), so
please send the translation file by Monday 1:00 PM IST.

--
Akshay Joshi
Principal Software Architect
www.enterprisedb.com

*Blog*: https://www.enterprisedb.com/akshay-joshi
*GitHub*: https://github.com/akshay-joshi
*LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216

Re: pgAdmin Release and Installer Survey

[Akshay Joshi]

Adding pgadmin-support.

On Thu, 7 Mar, 2024, 3:30 pm Akshay Joshi, 
wrote:

> Hello everyone,
>
> I hope this message finds you well.
>
> As part of the pgAdmin team, I'm reaching out to request your assistance
> with a survey regarding pgAdmin Release and Installation. Taking just a
> minute to fill out this form would greatly help us streamline the
> management of pgAdmin releases. Your input is highly valued and appreciated.
>
>
> https://docs.google.com/forms/d/1SaDS-PSU3MQEVbojLYzN5AFa9Hr5vHqXchJ52-REqSs/edit?ts=65e98d39
>
> Thank you in advance for your cooperation.
>
> --
> Akshay Joshi
> Principal Software Architect
> www.enterprisedb.com
>
> *Blog*: https://www.enterprisedb.com/akshay-joshi
> *GitHub*: https://github.com/akshay-joshi
> *LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216
>

pgAdmin 4 v8.4 Released

[Akshay Joshi]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.4.

This release of pgAdmin 4 includes 16 bug fixes and new features. For more
details please see the release notes at:

https://www.pgadmin.org/docs/pgadmin4/8.4/release_notes_8_4.html

pgAdmin is the leading Open Source graphical management tool for
PostgreSQL. For more information, please see:

https://www.pgadmin.org/

Notable changes in this release include:

Features:

   -

   Allow preferences customization using a configuration file.
   -

   Add support for JSON log format.
   -

   Add --yes option for skipping the confirmation prompt while deleting the
   user via CLI for scripting purposes.


Bugs/Housekeeping:

   -

   Unsafe Deserialization and Remote Code Execution by an Authenticated
   user in pgAdmin 4 (CVE-2024-2044).
   -

   Upgrade CodeMirror from version 5 to 6.
   -

   Fix multiple issues where PasswordExecCommand was not working in server
   mode and PasswordExecCommand was not loaded when importing servers.
   -

   Fix the tabbed panel backward/forward shortcut for tabs.
   -

   Fixed an issue where dependencies and dependents were not showing if a
   composite type was used as an attribute in another composite type.
   -

   Remove role-related checks on the UI dashboard when terminating a
   session/query and let PostgreSQL take care of it.
   -

   Fix an issue where the scripts created by generating script of Schema
   diff for Table with sequence were not working earlier.
   -

   Added documentation for Dashboard's System Statistics tab.
   -

   Ensure that the OAuth2 session is logged out when users log out from
   pgAdmin.


Builds for Windows and macOS are available now, along with a Python Wheel,

Docker Container, RPM, DEB Package, and source code tarball from:

https://www.pgadmin.org/download/

--

Akshay Joshi

pgAdmin Project

pgAdmin Release and Installer Survey

[Akshay Joshi]

Hello everyone,

I hope this message finds you well.

As part of the pgAdmin team, I'm reaching out to request your assistance
with a survey regarding pgAdmin Release and Installation. Taking just a
minute to fill out this form would greatly help us streamline the
management of pgAdmin releases. Your input is highly valued and appreciated.

https://docs.google.com/forms/d/1SaDS-PSU3MQEVbojLYzN5AFa9Hr5vHqXchJ52-REqSs/edit?ts=65e98d39

Thank you in advance for your cooperation.

--
Akshay Joshi
Principal Software Architect
www.enterprisedb.com

*Blog*: https://www.enterprisedb.com/akshay-joshi
*GitHub*: https://github.com/akshay-joshi
*LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216

pgAdmin4 v8.4 candidate builds

[Akshay Joshi]

Hi All,

pgAdmin4 v8.4 candidate builds and source code is available at
https://developer.pgadmin.org/builds/2024-03-04-1/

Yogesh, could you please verify this for Thursday's release?

--
Akshay Joshi
Principal Software Architect
www.enterprisedb.com

*Blog*: https://www.enterprisedb.com/akshay-joshi
*GitHub*: https://github.com/akshay-joshi
*LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216

Translators: Release next week

[Akshay Joshi]

Hi Translators,

We will have a release next week, so updates to translations before the
release would be helpful. The template and catalogs have been updated in
Git. As we have moved to GitHub, you can raise the PR request. You can send
the patches on pgadmin-hackers as well.

*Note:* We generally create our candidate builds on Monday (2 PM IST), so
please send the translation file by Monday 1:00 PM IST.

--
Akshay Joshi
Principal Software Architect
www.enterprisedb.com

*Blog*: https://www.enterprisedb.com/akshay-joshi
*GitHub*: https://github.com/akshay-joshi
*LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216

[pgadmin-org/pgadmin4] a74b02: Update release note

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: a74b0232f9dc4e3de7c281b8329b078f3840c549
  
https://github.com/pgadmin-org/pgadmin4/commit/a74b0232f9dc4e3de7c281b8329b078f3840c549
  Author: Akshay Joshi 
  Date:   2024-02-15 (Thu, 15 Feb 2024)

  Changed paths:
M docs/en_US/release_notes_8_4.rst

  Log Message:
  ---
  Update release note

[pgadmin-org/pgadmin4] 96ed38: Added release note for v8.4

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: 96ed38292fc7fc2369a6ce92e98a38f14f1250f0
  
https://github.com/pgadmin-org/pgadmin4/commit/96ed38292fc7fc2369a6ce92e98a38f14f1250f0
  Author: Akshay Joshi 
  Date:   2024-02-09 (Fri, 09 Feb 2024)

  Changed paths:
M docs/en_US/release_notes.rst
A docs/en_US/release_notes_8_4.rst

  Log Message:
  ---
  Added release note for v8.4

pgAdmin 4 v8.3 Released

[Akshay Joshi]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.3.

This release of pgAdmin 4 includes 16 bug fixes and new features. For more
details please see the release notes at:

https://www.pgadmin.org/docs/pgadmin4/8.3/release_notes_8_3.html

pgAdmin is the leading Open Source graphical management tool for
PostgreSQL. For more information, please see:

https://www.pgadmin.org/

Notable changes in this release include:

Features:

   -

   Allow drag-n-drop column’s collection tree nodes as comma-separated
   columns.
   -

   Added support to rename columns in Views.
   -

   Added BYPASSRLS|NOBYPASSRLS option while creating a Role.
   -

   Added support for column storage syntax while creating table.
   -

   Use COOKIE_DEFAULT_PATH or SCRIPT_NAME in the session cookie path.
   -

   Added configurable parameter to enable support for PasswordExecCommand
   in server mode.



Bugs/Housekeeping:

   -

   Fixed an issue where format SQL was messing up the operator. Included
   many other feature changes.
   -

   Fixed an issue where formatting inserts empty lines in specific cases.
   -

   Add support for selecting a schema in the backup database dialog with no
   tables, mviews, views, or foreign tables.
   -

   Fixed a UI border issue on the dependencies tab for columns with icons.
   -

   Fixed an issue where multiple errors were showing if the user did not
   have connect privileges.
   -

   Fixed an issue where group membership information was displayed
   incorrectly.
   -

   Ensure that the correct SQL is generated when changing the column data
   type to "char".
   -

   Fixed an issue of pgAdmin failing to launch due to inconsistent PATH
   variable name on Windows.
   -

   Fix a backend server error when creating a named restore point.


Builds for Windows and macOS are available now, along with a Python Wheel,

Docker Container, RPM, DEB Package, and source code tarball from:

https://www.pgadmin.org/download/


--

Akshay Joshi

pgAdmin Project

[pgadmin-org/pgadmin4]

[Akshay Joshi]

  Branch: refs/tags/REL-8_3
  Home:   https://github.com/pgadmin-org/pgadmin4

Re: pgAdmin4 v8.3 candidate builds

[Akshay Joshi]

Hi All

We identified an issue during testing, prompting us to regenerate the
builds again. The latest candidate builds and source code is available at
https://developer.pgadmin.org/builds/2024-02-08-1/

*Note: *Due to the issue mentioned above, we are extending the release by
one day, now scheduled for tomorrow.

On Mon, Feb 5, 2024 at 2:29 PM Akshay Joshi 
wrote:

> Hi All,
>
> pgAdmin4 v8.3 candidate builds and source code is available at
> https://developer.pgadmin.org/builds/2024-02-05-1/
>
> Yogesh, could you please verify this for Thursday's release?
>
> --
> Akshay Joshi
> Principal Software Architect
> www.enterprisedb.com
>
> *Blog*: https://www.enterprisedb.com/akshay-joshi
> *GitHub*: https://github.com/akshay-joshi
> *LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216
>
>

[pgadmin-org/pgadmin4] c92e9c: Fixed all broken submenus of the Help menu due to ...

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: c92e9c2953a7d18447e0b10a8f5454232531707c
  
https://github.com/pgadmin-org/pgadmin4/commit/c92e9c2953a7d18447e0b10a8f5454232531707c
  Author: Akshay Joshi 
  Date:   2024-02-08 (Thu, 08 Feb 2024)

  Changed paths:
M docs/en_US/release_notes_8_3.rst
M web/pgadmin/browser/static/js/MainMenuFactory.js

  Log Message:
  ---
  Fixed all broken submenus of the Help menu due to the SonarQube fix.

pgAdmin4 v8.3 candidate builds

[Akshay Joshi]

Hi All,

pgAdmin4 v8.3 candidate builds and source code is available at
https://developer.pgadmin.org/builds/2024-02-05-1/

Yogesh, could you please verify this for Thursday's release?

--
Akshay Joshi
Principal Software Architect
www.enterprisedb.com

*Blog*: https://www.enterprisedb.com/akshay-joshi
*GitHub*: https://github.com/akshay-joshi
*LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216

[pgadmin-org/pgadmin4] af1f4b: Update version for release v8.3

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: af1f4b3aa77243cc720d5128f5f8bc1d5fe2cdbe
  
https://github.com/pgadmin-org/pgadmin4/commit/af1f4b3aa77243cc720d5128f5f8bc1d5fe2cdbe
  Author: Akshay Joshi 
  Date:   2024-02-05 (Mon, 05 Feb 2024)

  Changed paths:
M docs/en_US/release_notes_8_3.rst
M web/config.py

  Log Message:
  ---
  Update version for release v8.3

Translators: Release next week

[Akshay Joshi]

Hi Translators,

We will have a release next week, so updates to translations before the
release would be helpful. The template and catalogs have been updated in
Git. As we have moved to GitHub, you can raise the PR request. You can send
the patches on pgadmin-hackers as well.

*Note:* We generally create our candidate builds on Monday (2 PM IST), so
please send the translation file by Monday 1:00 PM IST.

--
Akshay Joshi
Principal Software Architect
www.enterprisedb.com

*Blog*: https://www.enterprisedb.com/akshay-joshi
*GitHub*: https://github.com/akshay-joshi
*LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216

[pgadmin-org/pgadmin4] e12e8b: Update message catalogs for v8.3

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: e12e8bc9cf38390426e0df072b7f3a3d6d54cdd1
  
https://github.com/pgadmin-org/pgadmin4/commit/e12e8bc9cf38390426e0df072b7f3a3d6d54cdd1
  Author: Akshay Joshi 
  Date:   2024-02-01 (Thu, 01 Feb 2024)

  Changed paths:
M web/pgadmin/messages.pot
M web/pgadmin/translations/cs/LC_MESSAGES/messages.mo
M web/pgadmin/translations/cs/LC_MESSAGES/messages.po
M web/pgadmin/translations/de/LC_MESSAGES/messages.mo
M web/pgadmin/translations/de/LC_MESSAGES/messages.po
M web/pgadmin/translations/es/LC_MESSAGES/messages.mo
M web/pgadmin/translations/es/LC_MESSAGES/messages.po
M web/pgadmin/translations/fr/LC_MESSAGES/messages.mo
M web/pgadmin/translations/fr/LC_MESSAGES/messages.po
M web/pgadmin/translations/id/LC_MESSAGES/messages.mo
M web/pgadmin/translations/id/LC_MESSAGES/messages.po
M web/pgadmin/translations/it/LC_MESSAGES/messages.mo
M web/pgadmin/translations/it/LC_MESSAGES/messages.po
M web/pgadmin/translations/ja/LC_MESSAGES/messages.mo
M web/pgadmin/translations/ja/LC_MESSAGES/messages.po
M web/pgadmin/translations/ko/LC_MESSAGES/messages.mo
M web/pgadmin/translations/ko/LC_MESSAGES/messages.po
M web/pgadmin/translations/pl/LC_MESSAGES/messages.mo
M web/pgadmin/translations/pl/LC_MESSAGES/messages.po
M web/pgadmin/translations/pt_BR/LC_MESSAGES/messages.mo
M web/pgadmin/translations/pt_BR/LC_MESSAGES/messages.po
M web/pgadmin/translations/ru/LC_MESSAGES/messages.mo
M web/pgadmin/translations/ru/LC_MESSAGES/messages.po
M web/pgadmin/translations/zh/LC_MESSAGES/messages.mo
M web/pgadmin/translations/zh/LC_MESSAGES/messages.po

  Log Message:
  ---
  Update message catalogs for v8.3

[pgadmin-org/pgadmin4] e23ef5: Update release note.

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: e23ef5d9dfbdad106e1ed42f71b94f6c0e72d377
  
https://github.com/pgadmin-org/pgadmin4/commit/e23ef5d9dfbdad106e1ed42f71b94f6c0e72d377
  Author: Akshay Joshi 
  Date:   2024-01-29 (Mon, 29 Jan 2024)

  Changed paths:
M docs/en_US/release_notes_8_3.rst

  Log Message:
  ---
  Update release note.

[pgadmin-org/pgadmin4] 4c5324: Fixed API test cases for Backup.

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: 4c5324bd991f2dd5040a05d78c2d3117b31fcf00
  
https://github.com/pgadmin-org/pgadmin4/commit/4c5324bd991f2dd5040a05d78c2d3117b31fcf00
  Author: Akshay Joshi 
  Date:   2024-01-25 (Thu, 25 Jan 2024)

  Changed paths:
M web/pgadmin/tools/backup/__init__.py

  Log Message:
  ---
  Fixed API test cases for Backup.

[pgadmin-org/pgadmin4] 639a28: Fixed code smell 'Prefer using an optional chain e...

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: 639a28fbfc97db2f85f72b6a0cbc24c79afd88b0
  
https://github.com/pgadmin-org/pgadmin4/commit/639a28fbfc97db2f85f72b6a0cbc24c79afd88b0
  Author: Akshay Joshi 
  Date:   2024-01-25 (Thu, 25 Jan 2024)

  Changed paths:
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/collations/static/js/collation.ui.js
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/packages/static/js/package.ui.js
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/partitions/static/js/partition.ui.js
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/static/js/table.ui.js
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/types/static/js/type.ui.js
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/views/static/js/mview.js
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/views/static/js/view.ui.js
M web/pgadmin/browser/server_groups/servers/databases/static/js/database.js
M web/pgadmin/browser/server_groups/servers/static/js/server.js
M web/pgadmin/browser/static/js/MainMenuFactory.js
M web/pgadmin/browser/static/js/browser.js
M web/pgadmin/browser/static/js/node.js
M web/pgadmin/dashboard/static/js/Dashboard.jsx
M web/pgadmin/dashboard/static/js/WelcomeDashboard.jsx
M web/pgadmin/misc/cloud/static/js/biganimal_schema.ui.js
M web/pgadmin/misc/cloud/static/js/google.js
M web/pgadmin/misc/file_manager/static/js/components/FileManager.jsx
M web/pgadmin/misc/properties/CollectionNodeProperties.jsx
M web/pgadmin/misc/statistics/static/js/Statistics.jsx
M web/pgadmin/preferences/static/js/components/PreferencesComponent.jsx
M web/pgadmin/static/bundle/app.js
M web/pgadmin/static/js/Dialogs/MasterPasswordContent.jsx
M web/pgadmin/static/js/Dialogs/NamedRestoreContent.jsx
M web/pgadmin/static/js/Explain/Graphical.jsx
M web/pgadmin/static/js/Explain/index.jsx
M web/pgadmin/static/js/QuickSearch/online_help.js
M web/pgadmin/static/js/SchemaView/DepListener.js
M web/pgadmin/static/js/SchemaView/FormView.jsx
M web/pgadmin/static/js/SchemaView/MappedControl.jsx
M web/pgadmin/static/js/SchemaView/base_schema.ui.js
M web/pgadmin/static/js/SchemaView/index.jsx
M web/pgadmin/static/js/UtilityView.jsx
M web/pgadmin/static/js/chartjs/index.jsx
M web/pgadmin/static/js/components/CodeMirror.jsx
M web/pgadmin/static/js/components/FormComponents.jsx
M web/pgadmin/static/js/components/SelectRefresh.jsx
M web/pgadmin/static/js/helpers/ModalProvider.jsx
M web/pgadmin/static/js/keyboard_shortcuts.js
M web/pgadmin/static/js/tree/pgadmin_tree_save_state.js
M web/pgadmin/static/js/tree/tree.js
M web/pgadmin/static/js/window.js
M web/pgadmin/static/vendor/require/require.js
M web/pgadmin/tools/backup/__init__.py
M web/pgadmin/tools/debugger/static/js/DebuggerModule.js
M 
web/pgadmin/tools/debugger/static/js/components/DebuggerArgumentComponent.jsx
M web/pgadmin/tools/debugger/static/js/debugger_utils.js
M web/pgadmin/tools/import_export/static/js/import_export.js
M web/pgadmin/tools/maintenance/static/js/maintenance.js
M web/pgadmin/tools/psql/static/js/psql_module.js
M 
web/pgadmin/tools/sqleditor/static/js/components/sections/GeometryViewer.jsx
M web/pgadmin/tools/sqleditor/static/js/components/sections/ResultSet.jsx
M web/regression/javascript/tree/tree_fake.js

  Log Message:
  ---
  Fixed code smell 'Prefer using an optional chain expression instead, as it's 
more concise and easier to read'.

[pgadmin-org/pgadmin4] 41fe1d: Fixed PEP8

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: 41fe1db8844d439198b58df0b7a3d4bf1490cf34
  
https://github.com/pgadmin-org/pgadmin4/commit/41fe1db8844d439198b58df0b7a3d4bf1490cf34
  Author: Akshay Joshi 
  Date:   2024-01-25 (Thu, 25 Jan 2024)

  Changed paths:
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/constraints/exclusion_constraint/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/row_security_policies/utils.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/triggers/utils.py
M web/pgadmin/tools/backup/__init__.py

  Log Message:
  ---
  Fixed PEP8

[pgadmin-org/pgadmin4] cafe69: Fixed SonarQube Bugs and API test cases.

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: cafe69c23591ecf7fa6c9b5daa980b4dbecca6ed
  
https://github.com/pgadmin-org/pgadmin4/commit/cafe69c23591ecf7fa6c9b5daa980b4dbecca6ed
  Author: Akshay Joshi 
  Date:   2024-01-25 (Thu, 25 Jan 2024)

  Changed paths:
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/packages/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/compound_triggers/utils.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/constraints/check_constraint/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/constraints/exclusion_constraint/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/utils.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/row_security_policies/utils.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/triggers/utils.py
M web/pgadmin/tools/backup/__init__.py

  Log Message:
  ---
  Fixed SonarQube Bugs and API test cases.

[pgadmin-org/pgadmin4] d55c35: Revert yarnrc.yml and yarn.lock

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: d55c35c0e80ba7a0b46f6c877008b403cf7aa96d
  
https://github.com/pgadmin-org/pgadmin4/commit/d55c35c0e80ba7a0b46f6c877008b403cf7aa96d
  Author: Akshay Joshi 
  Date:   2024-01-24 (Wed, 24 Jan 2024)

  Changed paths:
M web/.yarnrc.yml
M web/yarn.lock

  Log Message:
  ---
  Revert yarnrc.yml and yarn.lock

[pgadmin-org/pgadmin4] 0e0cbc: Fixed SonarQube code smell Replace the unused loca...

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: 0e0cbc40b8407506762b53f9e6bc48297570576f
  
https://github.com/pgadmin-org/pgadmin4/commit/0e0cbc40b8407506762b53f9e6bc48297570576f
  Author: Akshay Joshi 
  Date:   2024-01-24 (Wed, 24 Jan 2024)

  Changed paths:
M web/.yarnrc.yml
M web/pgacloud/pgacloud.py
M web/pgacloud/providers/azure.py
M web/pgadmin/authenticate/mfa/email.py
M web/pgadmin/browser/server_groups/servers/databases/casts/__init__.py
M web/pgadmin/browser/server_groups/servers/databases/extensions/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/foreign_data_wrappers/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/foreign_data_wrappers/foreign_servers/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/foreign_data_wrappers/foreign_servers/user_mappings/__init__.py
M web/pgadmin/browser/server_groups/servers/databases/languages/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/publications/__init__.py
M web/pgadmin/browser/server_groups/servers/databases/schemas/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/collations/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/domains/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/domains/domain_constraints/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/fts_configurations/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/fts_dictionaries/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/fts_parsers/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/fts_templates/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/functions/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/packages/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/sequences/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/synonyms/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/columns/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/compound_triggers/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/compound_triggers/utils.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/constraints/check_constraint/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/constraints/check_constraint/utils.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/constraints/exclusion_constraint/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/constraints/exclusion_constraint/utils.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/constraints/foreign_key/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/constraints/foreign_key/utils.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/constraints/index_constraint/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/constraints/index_constraint/utils.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/utils.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/partitions/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/row_security_policies/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/row_security_policies/utils.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/rules/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/triggers/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/triggers/utils.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/types/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/views/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/subscriptions/__init__.py
M web/pgadmin/browser/server_groups/servers/pgagent/__init__.py
M web/pgadmin/browser/server_groups/servers/pgagent/steps/__init__.py
M web/pgadmin/browser/server_groups/servers/resource_groups/__init__.py
M web/pgadmin/browser/server_groups/servers/tablespaces/__init__.py
M web/pgadmin/dashboard/__init__.py
M web/pgadmin/misc/__init__.py
M web/pgadmin/misc/bgprocess/processes.py
M web/pgadmin/misc/cloud/azure/__init__.py
M web/pgadmin/misc/cloud/biganimal

[pgadmin-org/pgadmin4] 81fccc: Added support to rename columns in Views. #6380

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: 81fccc87b598fa11153b6ae85c0e1ec6b9247255
  
https://github.com/pgadmin-org/pgadmin4/commit/81fccc87b598fa11153b6ae85c0e1ec6b9247255
  Author: Akshay Joshi 
  Date:   2024-01-22 (Mon, 22 Jan 2024)

  Changed paths:
M docs/en_US/release_notes_8_3.rst
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/columns/static/js/column.ui.js

  Log Message:
  ---
  Added support to rename columns in Views. #6380

[pgadmin-org/pgadmin4] 60983a: Updated release note.

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: 60983a25d22b013634fc56208a6f56de3330a207
  
https://github.com/pgadmin-org/pgadmin4/commit/60983a25d22b013634fc56208a6f56de3330a207
  Author: Akshay Joshi 
  Date:   2024-01-12 (Fri, 12 Jan 2024)

  Changed paths:
M docs/en_US/release_notes_8_3.rst

  Log Message:
  ---
  Updated release note.

[pgadmin-org/pgadmin4] 5240e8: Added BYPASSRLS|NOBYPASSRLS option while creating ...

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: 5240e8ccf8adbf97af6480dba0a0aceda08ae8b5
  
https://github.com/pgadmin-org/pgadmin4/commit/5240e8ccf8adbf97af6480dba0a0aceda08ae8b5
  Author: Akshay Joshi 
  Date:   2024-01-11 (Thu, 11 Jan 2024)

  Changed paths:
M docs/en_US/images/role_privileges.png
M docs/en_US/release_notes.rst
A docs/en_US/release_notes_8_3.rst
M docs/en_US/role_dialog.rst
M web/pgadmin/browser/server_groups/servers/roles/__init__.py
M web/pgadmin/browser/server_groups/servers/roles/static/js/role.js
M web/pgadmin/browser/server_groups/servers/roles/static/js/role.ui.js
M 
web/pgadmin/browser/server_groups/servers/roles/templates/roles/sql/default/create.sql
M 
web/pgadmin/browser/server_groups/servers/roles/templates/roles/sql/default/permission.sql
M 
web/pgadmin/browser/server_groups/servers/roles/templates/roles/sql/default/properties.sql
M 
web/pgadmin/browser/server_groups/servers/roles/templates/roles/sql/default/sql.sql
M 
web/pgadmin/browser/server_groups/servers/roles/templates/roles/sql/default/update.sql
M 
web/pgadmin/browser/server_groups/servers/roles/tests/default/alter_login_role_description.sql
M 
web/pgadmin/browser/server_groups/servers/roles/tests/default/alter_login_role_name.sql
M 
web/pgadmin/browser/server_groups/servers/roles/tests/default/alter_login_role_options.msql
M 
web/pgadmin/browser/server_groups/servers/roles/tests/default/alter_login_role_options.sql
M 
web/pgadmin/browser/server_groups/servers/roles/tests/default/alter_role_description.sql
M 
web/pgadmin/browser/server_groups/servers/roles/tests/default/alter_role_name.sql
M 
web/pgadmin/browser/server_groups/servers/roles/tests/default/alter_role_options1.sql
M 
web/pgadmin/browser/server_groups/servers/roles/tests/default/alter_role_options2.sql
M 
web/pgadmin/browser/server_groups/servers/roles/tests/default/alter_role_options3.sql
M 
web/pgadmin/browser/server_groups/servers/roles/tests/default/alter_role_options4.sql
M 
web/pgadmin/browser/server_groups/servers/roles/tests/default/create_login_role.msql
M 
web/pgadmin/browser/server_groups/servers/roles/tests/default/create_login_role.sql
M 
web/pgadmin/browser/server_groups/servers/roles/tests/default/create_role.msql
M 
web/pgadmin/browser/server_groups/servers/roles/tests/default/create_role.sql
M web/pgadmin/browser/server_groups/servers/roles/tests/default/test.json
M web/pgadmin/browser/server_groups/servers/roles/tests/utils.py
M web/pgadmin/browser/static/js/node.js

  Log Message:
  ---
  Added BYPASSRLS|NOBYPASSRLS option while creating a Role. #6392

[pgadmin-org/pgadmin4]

[Akshay Joshi]

  Branch: refs/tags/REL-8_2
  Home:   https://github.com/pgadmin-org/pgadmin4

pgAdmin 4 v8.2 Released

[Akshay Joshi]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.2.

This release of pgAdmin 4 includes 20 bug fixes and new features. For more
details please see the release notes at:

https://www.pgadmin.org/docs/pgadmin4/8.2/release_notes_8_2.html

pgAdmin is the leading Open Source graphical management tool for
PostgreSQL. For more information, please see:

https://www.pgadmin.org/


Notable changes in this release include:

Features:

   -

   Administer pgAdmin Users and Preferences Using the Command Line
   Interface (CLI).
   -

   Allow users to convert the View/Edit table into a Query tool to enable
   editing the SQL generated
   -

   Added copy server support, allowing the duplication of existing servers
   with the option to make certain modifications.
   -

   Added keep-alive support for SSH sessions when connecting to a
   PostgreSQL server via an SSH tunnel.



Bugs/Housekeeping:

   -

   Fixed an issue where the query tool title did not change after "Save As"
   until any new change was made.
   -

   Fixed an issue where export servers were not adding extensions if not
   specified.
   -

   Fixed an issue where pgAdmin imports servers to the wrong accounts for
   the external authentication.
   -

   Fixed an issue where an error occurred in the SQL tab when using an
   extended index(pgroonga).
   -

   Fixed an issue where DB Restrictions were not visible on the server
   dialog.
   -

   Ensure that the 'Dbo' schema is displayed as a regular schema rather
   than a system catalog schema.
   -

   Introduce LDAP configuration parameter LDAP_IGNORE_MALFORMED_SCHEMA to
   ignore fetching schema from the LDAP server.
   -

   Fixed an issue where Schema Diff not generating differences for missing
   columns.
   -

   Fixed an error-'amname' when generating ERD for the database containing
   partition tables.
   -

   Fixed an issue where the user is not able to cancel or terminate active
   queries from the dashboard.


Builds for Windows and macOS are available now, along with a Python Wheel,

Docker Container, RPM, DEB Package, and source code tarball from:

https://www.pgadmin.org/download/

--

Akshay Joshi

pgAdmin Project

pgAdmin4 v8.2 candidate builds

[Akshay Joshi]

Hi All,

pgAdmin4 v8.2 candidate builds and source code is available at
https://developer.pgadmin.org/builds/2024-01-08-1/

Yogesh, could you please verify this for Thursday's release?

--
Akshay Joshi
Principal Software Architect
www.enterprisedb.com

*Blog*: https://www.enterprisedb.com/akshay-joshi
*GitHub*: https://github.com/akshay-joshi
*LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216

[pgadmin-org/pgadmin4] 4ce65e: Added setuptools in the requirements for Python ve...

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: 4ce65ea77085977fca39773a8ea2d56d74d7a0c3
  
https://github.com/pgadmin-org/pgadmin4/commit/4ce65ea77085977fca39773a8ea2d56d74d7a0c3
  Author: Akshay Joshi 
  Date:   2024-01-08 (Mon, 08 Jan 2024)

  Changed paths:
M requirements.txt

  Log Message:
  ---
  Added setuptools in the requirements for Python version >= 3.12

[pgadmin-org/pgadmin4] f5ba42: Fixed API test case for Foreign Table.

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: f5ba42bec8cdca4a4c1b85fcb279777ca569d1ce
  
https://github.com/pgadmin-org/pgadmin4/commit/f5ba42bec8cdca4a4c1b85fcb279777ca569d1ce
  Author: Akshay Joshi 
  Date:   2024-01-08 (Mon, 08 Jan 2024)

  Changed paths:
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/foreign_tables/tests/foreign_tables_test_data.json

  Log Message:
  ---
  Fixed API test case for Foreign Table.


  Commit: 19b8d05e65a29f2f2b078903e1f1f547903f599d
  
https://github.com/pgadmin-org/pgadmin4/commit/19b8d05e65a29f2f2b078903e1f1f547903f599d
  Author: Akshay Joshi 
  Date:   2024-01-08 (Mon, 08 Jan 2024)

  Changed paths:
M web/config.py

  Log Message:
  ---
  Update version for release v8.2


Compare: 
https://github.com/pgadmin-org/pgadmin4/compare/26ec59ab5f34...19b8d05e65a2

[pgadmin-org/pgadmin4] 30509d: Added copy server support, allowing the duplicatio...

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: 30509d1bc1978b33d133ed0856503da0bf2e0bfd
  
https://github.com/pgadmin-org/pgadmin4/commit/30509d1bc1978b33d133ed0856503da0bf2e0bfd
  Author: Akshay Joshi 
  Date:   2024-01-08 (Mon, 08 Jan 2024)

  Changed paths:
M docs/en_US/images/file_menu.png
M docs/en_US/images/object_menu.png
M docs/en_US/images/runtime_menu.png
M docs/en_US/menu_bar.rst
M docs/en_US/release_notes_8_2.rst
M web/pgadmin/browser/server_groups/__init__.py
M web/pgadmin/browser/server_groups/servers/__init__.py
M web/pgadmin/browser/server_groups/servers/static/js/server.js
M web/pgadmin/browser/server_groups/servers/static/js/server.ui.js
M web/pgadmin/browser/static/js/node.js
M web/pgadmin/misc/cloud/static/js/cloud.js
M web/pgadmin/misc/properties/ObjectNodeProperties.jsx
M web/pgadmin/model/__init__.py
M web/regression/javascript/schema_ui_files/server.ui.spec.js

  Log Message:
  ---
  Added copy server support, allowing the duplication of existing servers with 
the option to make certain modifications. #6085 (#7106)

Added copy server support, allowing the duplication of existing servers with 
the option to make certain modifications. #6085

[pgadmin-org/pgadmin4] 5e710f: Fixed an issue where Schema Diff not generating di...

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: 5e710f7ee30ad6a26f39349079b330b530aa07d1
  
https://github.com/pgadmin-org/pgadmin4/commit/5e710f7ee30ad6a26f39349079b330b530aa07d1
  Author: Akshay Joshi 
  Date:   2024-01-08 (Mon, 08 Jan 2024)

  Changed paths:
M docs/en_US/release_notes_8_2.rst
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/foreign_tables/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/columns/utils.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/utils.py

  Log Message:
  ---
  Fixed an issue where Schema Diff not generating difference for missing 
columns. #7104

Translators: Release next week

[Akshay Joshi]

Hi Translators,

We will have a release next week, so updates to translations before the
release would be helpful. The template and catalogs have been updated in
Git. As we have moved to GitHub, you can raise the PR request. You can send
the patches on pgadmin-hackers as well.

*Note:* We generally create our candidate builds on Monday (2 PM IST), so
please send the translation file by Monday 1:00 PM IST.

--
Akshay Joshi
Principal Software Architect
www.enterprisedb.com

*Blog*: https://www.enterprisedb.com/akshay-joshi
*GitHub*: https://github.com/akshay-joshi
*LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216

[pgadmin-org/pgadmin4] db7273: Update message catalogs for v8.2

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: db727381b113f2844a435d8b34b34d0c780edaa4
  
https://github.com/pgadmin-org/pgadmin4/commit/db727381b113f2844a435d8b34b34d0c780edaa4
  Author: Akshay Joshi 
  Date:   2024-01-04 (Thu, 04 Jan 2024)

  Changed paths:
M web/pgadmin/messages.pot
M web/pgadmin/translations/cs/LC_MESSAGES/messages.mo
M web/pgadmin/translations/cs/LC_MESSAGES/messages.po
M web/pgadmin/translations/de/LC_MESSAGES/messages.mo
M web/pgadmin/translations/de/LC_MESSAGES/messages.po
M web/pgadmin/translations/es/LC_MESSAGES/messages.mo
M web/pgadmin/translations/es/LC_MESSAGES/messages.po
M web/pgadmin/translations/fr/LC_MESSAGES/messages.mo
M web/pgadmin/translations/fr/LC_MESSAGES/messages.po
M web/pgadmin/translations/id/LC_MESSAGES/messages.mo
M web/pgadmin/translations/id/LC_MESSAGES/messages.po
M web/pgadmin/translations/it/LC_MESSAGES/messages.mo
M web/pgadmin/translations/it/LC_MESSAGES/messages.po
M web/pgadmin/translations/ja/LC_MESSAGES/messages.mo
M web/pgadmin/translations/ja/LC_MESSAGES/messages.po
M web/pgadmin/translations/ko/LC_MESSAGES/messages.mo
M web/pgadmin/translations/ko/LC_MESSAGES/messages.po
M web/pgadmin/translations/pl/LC_MESSAGES/messages.mo
M web/pgadmin/translations/pl/LC_MESSAGES/messages.po
M web/pgadmin/translations/pt_BR/LC_MESSAGES/messages.mo
M web/pgadmin/translations/pt_BR/LC_MESSAGES/messages.po
M web/pgadmin/translations/ru/LC_MESSAGES/messages.mo
M web/pgadmin/translations/ru/LC_MESSAGES/messages.po
M web/pgadmin/translations/zh/LC_MESSAGES/messages.mo
M web/pgadmin/translations/zh/LC_MESSAGES/messages.po

  Log Message:
  ---
  Update message catalogs for v8.2

Re: Regarding codemirror upgrade and query tool autocomplete

[Akshay Joshi]

Hi Aditya

On Tue, Jan 2, 2024 at 6:33 PM Aditya Toshniwal <
aditya.toshni...@enterprisedb.com> wrote:

> Hi,
> Just to add to my previous email, double quoted table autocomplete works
> now with the latest minor version. More reasons to use the new approach.
>

   I think we should use the new approach.

>
> On Tue, Jan 2, 2024 at 4:44 PM Aditya Toshniwal <
> aditya.toshni...@enterprisedb.com> wrote:
>
>> Hi Hackers,
>>
>> I am working on upgrading the CodeMirror package (used by SQL input/Query
>> editor) to the latest version. One major improvement is on the autocomplete
>> part. CodeMirror provides a very versatile way of using autocomplete now.
>> One needs to pass the schema, table and columns data and it will show up in
>> intellisense on typing.
>> Right now, we send the query to the backend and the backend sends the
>> suggestions which are shown on the screen. This can be very slow for remote
>> PostgreSQL servers as it queries everytime to the server for data and
>> requires an active connection. Also, not a good user experience.
>> I was playing around with the new autocomplete and I have attached the
>> screen-recording for the same. The data from the backend is loaded once the
>> query tool opens.
>> It has a few issues though. Column suggestions don't work correctly for
>> double quoted tables aliases. It doesn't suggest "joins" which we do right
>> now.
>> I still need to figure out how we can refresh the data when new
>> tables/columns are added/removed. Overall, I find it more useful to the
>> users as it is quick and does the job what someone expects from an
>> autocomplete/intellisense.
>>
>> Thoughts/Suggestions on whether we should use it or continue with
>> existing?
>>
>> --
>> Thanks,
>> Aditya Toshniwal
>> pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
>> 
>> "Don't Complain about Heat, Plant a TREE"
>>
>
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
> 
> "Don't Complain about Heat, Plant a TREE"
>

[pgadmin-org/pgadmin4] fcfe7c: Fixed an issue where DB Restrictions were not visi...

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: fcfe7cfb7c7c284855ef3af1de1b4e0018800a7f
  
https://github.com/pgadmin-org/pgadmin4/commit/fcfe7cfb7c7c284855ef3af1de1b4e0018800a7f
  Author: Akshay Joshi 
  Date:   2024-01-01 (Mon, 01 Jan 2024)

  Changed paths:
M docs/en_US/release_notes_8_2.rst
M web/pgadmin/static/js/components/FormComponents.jsx

  Log Message:
  ---
  Fixed an issue where DB Restrictions were not visible on the server dialog. 
#7059

[pgadmin-org/pgadmin4] 740ce1: Update copyright notices for 2024

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: 740ce15bd73c7820fe91372bf512b663dd2604c4
  
https://github.com/pgadmin-org/pgadmin4/commit/740ce15bd73c7820fe91372bf512b663dd2604c4
  Author: Akshay Joshi 
  Date:   2024-01-01 (Mon, 01 Jan 2024)

  Changed paths:
M Dockerfile
M LICENSE
M Makefile
M docs/en_US/code_review.rst
M docs/en_US/coding_standards.rst
M docs/en_US/licence.rst
M pkg/mac/build-functions.sh
M pkg/mac/licence.rtf
M pkg/pip/build.sh
M pkg/pip/setup_pip.py
M pkg/src/build.sh
M pkg/win32/Resources/license.rtf
M runtime/.eslintrc.js
M runtime/src/js/configure.js
M runtime/src/js/misc.js
M runtime/src/js/pgadmin.js
M runtime/src/js/server_error.js
M runtime/src/js/view_log.js
M tools/copyright_updater.py
M tools/dependency_inventory.py
M tools/get_chromedriver.py
M tools/get_sb_package.py
M tools/sql_keywords.py
M tools/update_selenoid_browsers.py
M web/.eslintrc.js
M web/config.py
M web/migrations/alembic.ini
M web/migrations/env.py
M web/migrations/script.py.mako
M web/migrations/versions/02b9dccdcfcb_.py
M web/migrations/versions/09d53fca90c7_.py
M web/migrations/versions/1586db67b98e_.py
M web/migrations/versions/15c88f765bc8_.py
M web/migrations/versions/35f29b1701bd_.py
M web/migrations/versions/398697dc9550_.py
M web/migrations/versions/3c1e4b6eda55_.py
M web/migrations/versions/3ce25f562f3b_.py
M web/migrations/versions/44926ac97232_.py
M web/migrations/versions/44b9ce549393_.py
M web/migrations/versions/493cd3e39c0c_.py
M web/migrations/versions/50aad68f99c2_.py
M web/migrations/versions/6650c52670c2_.py
M web/migrations/versions/7c56ea250085_.py
M web/migrations/versions/7fedf8531802_.py
M web/migrations/versions/81c7ffeffeee_.py
M web/migrations/versions/84700139beb0_.py
M web/migrations/versions/9426ad06a63b_.py
M web/migrations/versions/a091c9611d20_.py
M web/migrations/versions/a39bd015b644_.py
M web/migrations/versions/a68b374fe373_.py
M web/migrations/versions/a77a0932a568_.py
M web/migrations/versions/aa86fb60b73d_.py
M web/migrations/versions/aff1436e3c8c_.py
M web/migrations/versions/b5b87fdfcb30_.py
M web/migrations/versions/c465fee44968_.py
M web/migrations/versions/c6974f64df08_.py
M web/migrations/versions/ca00ec32581b_.py
M web/migrations/versions/d0bc9f32b2b9_.py
M web/migrations/versions/d39482714a2e_.py
M web/migrations/versions/d85a62333272_.py
M web/migrations/versions/ec0f11f9a4e6_.py
M web/migrations/versions/ec1cac3399c9_.py
M web/migrations/versions/ece2e76bf60e_.py
M web/migrations/versions/ef590e979b0d_.py
M web/migrations/versions/f195f9a4923d_.py
M web/migrations/versions/f656e56dfdc8_.py
M web/migrations/versions/f79844e926ae_.py
M web/migrations/versions/fdc58d9bd449_.py
M web/pgAdmin4.py
M web/pgAdmin4.wsgi
M web/pgacloud/pgacloud.py
M web/pgacloud/providers/_abstract.py
M web/pgacloud/providers/aws.py
M web/pgacloud/providers/azure.py
M web/pgacloud/providers/biganimal.py
M web/pgacloud/providers/google.py
M web/pgacloud/utils/io.py
M web/pgacloud/utils/misc.py
M web/pgadmin/__init__.py
M web/pgadmin/about/__init__.py
M web/pgadmin/about/static/js/AboutComponent.jsx
M web/pgadmin/about/static/js/about.js
M web/pgadmin/authenticate/__init__.py
M web/pgadmin/authenticate/internal.py
M web/pgadmin/authenticate/kerberos.py
M web/pgadmin/authenticate/ldap.py
M web/pgadmin/authenticate/mfa/__init__.py
M web/pgadmin/authenticate/mfa/authenticator.py
M web/pgadmin/authenticate/mfa/email.py
M web/pgadmin/authenticate/mfa/registry.py
M web/pgadmin/authenticate/mfa/tests/test_config.py
M web/pgadmin/authenticate/mfa/tests/test_mfa.py
M web/pgadmin/authenticate/mfa/tests/test_mfa_view.py
M web/pgadmin/authenticate/mfa/tests/test_user_execution.py
M web/pgadmin/authenticate/mfa/tests/utils.py
M web/pgadmin/authenticate/mfa/utils.py
M web/pgadmin/authenticate/mfa/views.py
M web/pgadmin/authenticate/oauth2.py
M web/pgadmin/authenticate/registry.py
M web/pgadmin/authenticate/static/js/kerberos.js
M web/pgadmin/authenticate/webserver.py
M web/pgadmin/browser/__init__.py
M web/pgadmin/browser/collection.py
M web/pgadmin/browser/register_browser_preferences.py
M web/pgadmin/browser/server_groups/__init__.py
M web/pgadmin/browser/server_groups/servers/__init__.py
M web/pgadmin/browser/server_groups/servers/databases/__init__.py
M web/pgadmin/browser/server_groups/servers/databases/casts/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/casts/static/js/cast.js
M 
web/pgadmin/browser/server_groups/servers/databases/casts/static/js/cast.ui.js
M 
web/pgadmin/browser/server_groups

[pgadmin-org/pgadmin4] 2b736c: Ensure that eventlet's subprocess should be used f...

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: 2b736c18ab41ec047ed6e59647e01017034d874d
  
https://github.com/pgadmin-org/pgadmin4/commit/2b736c18ab41ec047ed6e59647e01017034d874d
  Author: Akshay Joshi 
  Date:   2024-01-01 (Mon, 01 Jan 2024)

  Changed paths:
M docs/en_US/release_notes_8_2.rst
M requirements.txt
M web/pgadmin/tools/psql/__init__.py

  Log Message:
  ---
  Ensure that eventlet's subprocess should be used following the resolution of 
an issue with Python 3.12 by eventlet. #6926

[pgadmin-org/pgadmin4] 8c06d9: Fixed an issue where an error occurred in the SQL ...

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: 8c06d933039e1a9568197eb4cba0796018bce3b7
  
https://github.com/pgadmin-org/pgadmin4/commit/8c06d933039e1a9568197eb4cba0796018bce3b7
  Author: Akshay Joshi 
  Date:   2023-12-22 (Fri, 22 Dec 2023)

  Changed paths:
M docs/en_US/release_notes_8_2.rst
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/utils.py

  Log Message:
  ---
  Fixed an issue where an error occurred in the SQL tab when using an extended 
index(pgroonga). #7002

[pgadmin-org/pgadmin4] 9ccdaf: Ensure that the 'Dbo' schema is displayed as a reg...

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: 9ccdaf73cd74ce35bd85a53642f1cede306bb4f5
  
https://github.com/pgadmin-org/pgadmin4/commit/9ccdaf73cd74ce35bd85a53642f1cede306bb4f5
  Author: Akshay Joshi 
  Date:   2023-12-21 (Thu, 21 Dec 2023)

  Changed paths:
M docs/en_US/release_notes_8_2.rst
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/catalog_objects/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/collations/templates/collations/sql/default/backend_support.sql
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/foreign_tables/templates/foreign_tables/sql/macros/db_catalogs.macro
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/sequences/templates/sequences/sql/default/backend_support.sql
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/synonyms/static/js/synonym.js
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/tables/sql/default/backend_support.sql
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/tables/sql/macros/db_catalogs.macro
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/templates/catalog/ppas/macros/catalogs.sql
M web/pgadmin/tools/search_objects/static/js/SearchObjects.jsx
M web/pgadmin/tools/search_objects/utils.py

  Log Message:
  ---
  Ensure that the 'Dbo' schema is displayed as a regular schema rather than a 
system catalog schema. #7061

[pgadmin-org/pgadmin4] a973c9: Remove EPAS 11 and add EPAS 16 in the GitHub actions.

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: a973c9c62ce8c91839f9fa007c6a56e4051cfa1a
  
https://github.com/pgadmin-org/pgadmin4/commit/a973c9c62ce8c91839f9fa007c6a56e4051cfa1a
  Author: Akshay Joshi 
  Date:   2023-12-20 (Wed, 20 Dec 2023)

  Changed paths:
M .github/workflows/run-feature-tests-epas.yml
M .github/workflows/run-python-tests-epas.yml
M docs/en_US/release_notes_8_2.rst

  Log Message:
  ---
  Remove EPAS 11 and add EPAS 16 in the GitHub actions.

[pgadmin-org/pgadmin4] a22b2a: Added keep-alive support for SSH sessions when con...

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: a22b2a6074133f9926384736c969d6bb6ddf0373
  
https://github.com/pgadmin-org/pgadmin4/commit/a22b2a6074133f9926384736c969d6bb6ddf0373
  Author: Akshay Joshi 
  Date:   2023-12-19 (Tue, 19 Dec 2023)

  Changed paths:
M docs/en_US/images/server_ssh_tunnel.png
M docs/en_US/release_notes.rst
A docs/en_US/release_notes_8_2.rst
M docs/en_US/server_dialog.rst
A web/migrations/versions/ec0f11f9a4e6_.py
M web/pgadmin/browser/server_groups/servers/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/subscriptions/static/js/subscription.ui.js
M web/pgadmin/browser/server_groups/servers/static/js/server.ui.js
M web/pgadmin/browser/server_groups/servers/tests/servers_test_data.json
M web/pgadmin/browser/server_groups/servers/tests/test_add_server.py
M web/pgadmin/browser/server_groups/servers/tests/test_check_connect.py
M 
web/pgadmin/browser/server_groups/servers/tests/test_check_ssh_mock_connect.py
M web/pgadmin/browser/server_groups/tests/servers_group_test_data.json
M web/pgadmin/model/__init__.py
M web/pgadmin/utils/driver/psycopg3/connection.py
M web/pgadmin/utils/driver/psycopg3/server_manager.py
M web/regression/javascript/schema_ui_files/server.ui.spec.js
M web/regression/javascript/schema_ui_files/subscription.ui.spec.js

  Log Message:
  ---
  Added keep-alive support for SSH sessions when connecting to a PostgreSQL 
server via an SSH tunnel. #7016

pgAdmin 4 v8.1 Released

[Akshay Joshi]

The pgAdmin Development Team is pleased to announce pgAdmin 4 version 8.1.

This release of pgAdmin 4 includes 21 bug fixes and new features. For more
details please see the release notes at:

https://www.pgadmin.org/docs/pgadmin4/8.1/release_notes_8_1.html

pgAdmin is the leading Open Source graphical management tool for
PostgreSQL. For more information, please see:

https://www.pgadmin.org/


Notable changes in this release include:

Features:

   -

   Add support for generating ERD for a schema.
   -

   Add support for creating a function with a custom return type.


Bugs/Housekeeping:

   -

   Fixed several accessibility-related issues for enhanced usability.
   -

   Ensure that indexes created by constraints are visible in the object
   explorer when "Show system objects" is enabled.
   -

   Provide a way to bypass the SSL cert verification for the OAuth2
   provider.
   -

   Fixed an issue where reading process logs throws an error when DATA_DIR
   is moved to a networked drive.
   -

   Remove the 'Close Window' submenu specifically for OSX to prevent
   unintended closure of the entire application.
   -

   Fixed an issue where syntax error was not highlighted in the query tool.
   -

   Reverse engineer serial columns when generating ERD for database/table.
   -

   Fixed an issue where the Schema was not visible in the dropdown for
   table properties or when creating a new table.
   -

   Ensure that the correct timezone is set for Docker deployments.
   -

   Fixed an issue where all rows and filter rows buttons of the object
   explorer toolbar were disabled for views and other supported nodes.


Builds for Windows and macOS are available now, along with a Python Wheel,

Docker Container, RPM, DEB Package, and source code tarball from:

https://www.pgadmin.org/download/


--

Akshay Joshi

pgAdmin Project

[pgadmin-org/pgadmin4]

[Akshay Joshi]

  Branch: refs/tags/REL-8_1
  Home:   https://github.com/pgadmin-org/pgadmin4

pgAdmin4 v8.1 candidate builds

[Akshay Joshi]

Hi All,

pgAdmin4 v8.1 candidate builds and source code is available at
https://developer.pgadmin.org/builds/2023-12-12-1/

Yogesh, could you please verify this for Thursday's release?

--
Akshay Joshi
Principal Software Architect
www.enterprisedb.com

*Blog*: https://www.enterprisedb.com/akshay-joshi
*GitHub*: https://github.com/akshay-joshi
*LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216

[pgadmin-org/pgadmin4] 9379df: Update version for release 8.1

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: 9379df25438ef4da19d2038307eac5c4ae0a6aab
  
https://github.com/pgadmin-org/pgadmin4/commit/9379df25438ef4da19d2038307eac5c4ae0a6aab
  Author: Akshay Joshi 
  Date:   2023-12-11 (Mon, 11 Dec 2023)

  Changed paths:
M web/config.py

  Log Message:
  ---
  Update version for release 8.1

Translators: Release next week

[Akshay Joshi]

Hi Translators,

We will have a release next week, so updates to translations before the
release would be helpful. The template and catalogs have been updated in
Git. As we have moved to GitHub, you can raise the PR request. You can send
the patches on pgadmin-hackers as well.

*Note:* We generally create our candidate builds on Monday (2 PM IST), so
please send the translation file by Monday 1:00 PM IST.

--
Akshay Joshi
Principal Software Architect
www.enterprisedb.com

*Blog*: https://www.enterprisedb.com/akshay-joshi
*GitHub*: https://github.com/akshay-joshi
*LinkedIn*: https://www.linkedin.com/in/akshay-joshi-086497216

[pgadmin-org/pgadmin4] 75a1b4: Update message catalog for v8.1

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: 75a1b4b17e695a79824290773909064f8c7eed96
  
https://github.com/pgadmin-org/pgadmin4/commit/75a1b4b17e695a79824290773909064f8c7eed96
  Author: Akshay Joshi 
  Date:   2023-12-07 (Thu, 07 Dec 2023)

  Changed paths:
M docs/en_US/release_notes_8_1.rst
M web/pgadmin/messages.pot
M web/pgadmin/translations/cs/LC_MESSAGES/messages.mo
M web/pgadmin/translations/cs/LC_MESSAGES/messages.po
M web/pgadmin/translations/de/LC_MESSAGES/messages.mo
M web/pgadmin/translations/de/LC_MESSAGES/messages.po
M web/pgadmin/translations/es/LC_MESSAGES/messages.mo
M web/pgadmin/translations/es/LC_MESSAGES/messages.po
M web/pgadmin/translations/fr/LC_MESSAGES/messages.mo
M web/pgadmin/translations/fr/LC_MESSAGES/messages.po
M web/pgadmin/translations/id/LC_MESSAGES/messages.mo
M web/pgadmin/translations/id/LC_MESSAGES/messages.po
M web/pgadmin/translations/it/LC_MESSAGES/messages.mo
M web/pgadmin/translations/it/LC_MESSAGES/messages.po
M web/pgadmin/translations/ja/LC_MESSAGES/messages.mo
M web/pgadmin/translations/ja/LC_MESSAGES/messages.po
M web/pgadmin/translations/ko/LC_MESSAGES/messages.mo
M web/pgadmin/translations/ko/LC_MESSAGES/messages.po
M web/pgadmin/translations/pl/LC_MESSAGES/messages.mo
M web/pgadmin/translations/pl/LC_MESSAGES/messages.po
M web/pgadmin/translations/pt_BR/LC_MESSAGES/messages.mo
M web/pgadmin/translations/pt_BR/LC_MESSAGES/messages.po
M web/pgadmin/translations/ru/LC_MESSAGES/messages.mo
M web/pgadmin/translations/ru/LC_MESSAGES/messages.po
M web/pgadmin/translations/zh/LC_MESSAGES/messages.mo
M web/pgadmin/translations/zh/LC_MESSAGES/messages.po

  Log Message:
  ---
  Update message catalog for v8.1

[pgadmin-org/pgadmin4] e207a8: Remove the 'Close Window' submenu specifically for...

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: e207a82dbbe30afe1d8c68e33d277aed4b124434
  
https://github.com/pgadmin-org/pgadmin4/commit/e207a82dbbe30afe1d8c68e33d277aed4b124434
  Author: Akshay Joshi 
  Date:   2023-12-05 (Tue, 05 Dec 2023)

  Changed paths:
M docs/en_US/release_notes_8_1.rst
M runtime/src/js/pgadmin.js
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/utils.py

  Log Message:
  ---
  Remove the 'Close Window' submenu specifically for OSX to prevent unintended 
closure of the entire application. #6814 (partial fixed)

[pgadmin-org/pgadmin4] 444f3a: Update release note.

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: 444f3a3189f87c458c09cf805e1decb828a5b5bc
  
https://github.com/pgadmin-org/pgadmin4/commit/444f3a3189f87c458c09cf805e1decb828a5b5bc
  Author: Akshay Joshi 
  Date:   2023-12-01 (Fri, 01 Dec 2023)

  Changed paths:
M docs/en_US/release_notes_8_1.rst

  Log Message:
  ---
  Update release note.

[pgadmin-org/pgadmin4] 2b2ff0: Ensure that indexes created by constraints are vis...

[Akshay Joshi]

  Branch: refs/heads/master
  Home:   https://github.com/pgadmin-org/pgadmin4
  Commit: 2b2ff0d26018a6d605d4a0fedb0d1a910de0cdc1
  
https://github.com/pgadmin-org/pgadmin4/commit/2b2ff0d26018a6d605d4a0fedb0d1a910de0cdc1
  Author: Akshay Joshi 
  Date:   2023-12-01 (Fri, 01 Dec 2023)

  Changed paths:
M docs/en_US/release_notes_8_1.rst
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/__init__.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/indexes/utils.py
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/indexes/sql/11_plus/properties.sql
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/indexes/sql/13_plus/properties.sql
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/indexes/sql/15_plus/properties.sql
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/indexes/sql/default/count.sql
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/indexes/sql/default/nodes.sql
M 
web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/indexes/sql/default/properties.sql

  Log Message:
  ---
  Ensure that indexes created by constraints are visible in the object explorer 
when "Show system objects" is enabled. #6717