Query editor: replacing text issue

[androxkentaki]

Since version 6.8 of pgA You have change behavior of replacing text feature
in query editor. It is going in the right direction , but there are still
missing main feature (which was working till 6.7).

Till this version when I want to replace some text I mark it up and stroke
Ctrl + Shift + F.

String for replace was automatically putted in “for replace” field.

And I only need to insert text into the “replace to” field.



But since v. 6.8 when I stroke Ctrl + Shift + F the “for replace” field is
always empty and I need manually input values into both fields.

Can You change it? Or maybe there is an option in settings?





Second thing: why Ctrl + Shift + F and not Ctrl + H ?



-- 
Z wyrazami szacunku/ Best regards
Andrzej Gerasimuk

Re: pgadmin4 - query editor in separate window

[androxkentaki]

Simple way if File > Reset Layout
[image: obraz.png]


śr., 27 lip 2022 o 14:13 Graf Gerald 6080 ED 
napisał(a):

> Hi,
>
> could you please help?
>
> Thanks in advance.
>
> KR Gerald
>
>
>
>
>
> *From:* Dave Page 
> *Sent:* Mittwoch, 27. Juli 2022 10:40
> *To:* Graf Gerald 6080 ED 
> *Subject:* Re: pgadmin4 - query editor in separate window
>
>
>
> Hi
>
>
>
> Please address any support questions to the pgadmin-supp...@postgresql.org 
> mailing
> list (https://www.pgadmin.org/support/list/
> ).
> I am not able to provide support on a private basis.
>
>
>
> Regards, Dave.
>
>
>
> On Tue, 26 Jul 2022 at 10:40, Graf Gerald 6080 ED <
> gerald.g...@erstegroup.com> wrote:
>
> Dear Dave,
>
> I am using pgadmin4 (version 5.0) and somehow I managed that the query
> editor is not a section in the panel tab any more, but opens in a separate
> window in front of the panel tab (which shows now not query and result but
> only result).
>
> This is more then annoying but I could not undo this. Browsing through
> settings and documentation (
> https://www.pgadmin.org/docs/pgadmin4/development/query_tool_toolbar.html
> )
> didn’t help. I also didn’t find the correct question to ask google.
>
> How can I set this back, so that the query editor is part of the panel tab
> again?
>
>
>
> Please help.
>
> KR Gerald
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> --
>
> Dave Page
> Blog: https://pgsnake.blogspot.com
> 
> Twitter: @pgsnake
>
> EDB: https://www.enterprisedb.com
> 
>


-- 
Z wyrazami szacunku
Andrzej Gerasimuk

Re: pgAdmin 4 v6.12 Released

[androxkentaki]

Thank You


   -

   Allow users to search within the file/storage manager.


Finally :) That what was missing in pgA4 :)

Now pls resolve the right button click issue :)





czw., 28 lip 2022 o 09:10 Akshay Joshi 
napisał(a):

> The pgAdmin Development Team is pleased to announce pgAdmin 4 version 6.12.
>
> 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/6.12/release_notes_6_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 support for visualizing the graph using Stacked Line, Bar,
>Stacked Bar, and Pie charts in the query tool.
>
>
> With this feature, users can visualize the query result set as a Stacked
> Line, Bar, Stacked Bar, and Pie chart. A new button 'Graph Visualiser' has
> been added to the Data output panel.
>
>
>-
>
>Added option to trigger autocomplete on key press in the query tool.
>
>
> This feature allows autocomplete to be accessed with a key press in the
> query tool. One new parameter is added to Preferences -> Query Tool -> Auto
> completion -> ‘Autocomplete on key press’ to disable it.
>
>
>-
>
>Allow users to search within the file/storage manager.
>-
>
>Allow users to delete files/folders from the storage manager.
>
>
>
> Bugs/Housekeeping:
>
>-
>
>Port the file/storage manager to React.
>-
>
>Port change password, master password, and named restore point dialog
>to React.
>-
>
>Ensure that the splash screen can be moved.
>-
>
>Ensure that notices should not disappear from the messages tab.
>-
>
>Ensure that geometry should be shown for all the selected cells.
>-
>
>Preserve the settings set by the user in the import/export data dialog.
>-
>
>Fixed an issue where new folders cannot be created in the save dialog.
>
>
>
> 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
>
>

-- 
Z wyrazami szacunku
Andrzej Gerasimuk

Usability problem with pgAdmin4

[androxkentaki .]

Hello everyone

Recently I start my adventure with pgAdmin4 on Windows. (I have worked
several years on pgA3 bot I need to update postgresql from 9.3 to 11).



And now I have some issues with it. I hope that more practiced users can
help me with it.

Basically it is usability problems. Maybe You have the same problems and
found solution for it.

So main topics are:

1.   Finding proper SQL file to open in query tool: when I am preparing
some maintenance solution or report in our ERP system I am preparing SQL
script and save it into a file. When I want to come back to it. So I open
query tool > open file > select file. But main problem Is that I can’t find
it by part of a name. Is there any trick of plugin to filter files by part
of name? (in pgA3 it was explorer window so we can use search function)


[image: psaearch.png]





2.   Triggers on tables and its procedures. In pgAdmin3 I was able to
go on table > Triggers > Name_of_trigger and expand definition of procedure
to edit it. On pgA4 I can only read of its name and I must find it
separately to reedit it.



3.   Opening new Query tool from opened one. On pgA3 I can click NEW
and its done. On v4 I need go to main panel tab, expand Tools > Query tool


-- 
Z wyrazami szacunku
Andrzej Gerasimuk

Re: connect external app via pgadmin

[androxkentaki]

i don't know what id Qgis and why You want to do it via pgAdmin...

But did You consider using ODBC connection and its driver?

śr., 12 sie 2020 o 08:58 bw  napisał(a):

> Hi,
>
> As I do not like to open-up my postgresql port to the outside world and
> managing users via pgadmin is very user friendly. I was wondering if
> somehow it would be possible to give external applications like Qgis for
> instance access to the database via pgadmin?
>
> For example in qgis in order to access the database it needs to connect
> directly to the postgresql port and I have to create a linux user for them.
> I do not want that. I rather manage this inside pgadmin. If qgis would
> somehow be able to connect to the db via a pgadmin api that would be really
> great.
>
> regards,
> Bastiaan
>


-- 
Z wyrazami szacunku
Andrzej Gerasimuk

Re: connect external app via pgadmin

[androxkentaki]

But pgAdmin runs at the same ports, so You need them to be opened.

You can set in pgconf allowed IP pool.
You can change default port no por postgresql

Maybe You can consider "hardware" solution: on Your gateway make in
firewall rule for specific IP address with port mapping/triggering
e.g. If Your pg is on default port 5432 make an rule that from if somebody
from external will try to connect via 87654 port will be redirected to 5432


I don't know how Your infrastructure looks like so i can't give you more
detailed solution

śr., 12 sie 2020 o 12:41 bw  napisał(a):

> Andrzej,
>
> QGIS is just an example as I use it in combination with postgis in order
> to work in mapping GIS elements.
> With odbc I still need to open up the server ports to the outside world
> which is what I want to avoid.
>
> regards,
> Bastiaan
>
> On Wed, 12 Aug 2020 at 11:43, androxkentaki 
> wrote:
>
>> i don't know what id Qgis and why You want to do it via pgAdmin...
>>
>> But did You consider using ODBC connection and its driver?
>>
>> śr., 12 sie 2020 o 08:58 bw  napisał(a):
>>
>>> Hi,
>>>
>>> As I do not like to open-up my postgresql port to the outside world and
>>> managing users via pgadmin is very user friendly. I was wondering if
>>> somehow it would be possible to give external applications like Qgis for
>>> instance access to the database via pgadmin?
>>>
>>> For example in qgis in order to access the database it needs to connect
>>> directly to the postgresql port and I have to create a linux user for them.
>>> I do not want that. I rather manage this inside pgadmin. If qgis would
>>> somehow be able to connect to the db via a pgadmin api that would be really
>>> great.
>>>
>>> regards,
>>> Bastiaan
>>>
>>
>>
>> --
>> Z wyrazami szacunku
>> Andrzej Gerasimuk
>>
>

-- 
Z wyrazami szacunku
Andrzej Gerasimuk

Query editor lagging in 4.25

[androxkentaki]

Since couple of days I have noticed significant delays in the pgAdmin's
response.

Lags are noticed generally in query editor. SQL code from query id
displayed after 2-3 sec after scrolling down. It also appears even when I
am typing SQL  on keyboard (typed words are displayed on screen with 1s
delay).



Hardware id OK, I don’t see any RAM or CPU mass usage. Even other browser
tabs are working without aby lag’s. It is happening only in pgAdmin.

Any idea what could be wrong?



(pgAdmin v 4.25 x86, running on PC with W10 Pro 64bit, 32GB RAM, i7-6700K
and SSD and in Firefox 80.0.1)


-- 
Z wyrazami szacunku
Andrzej Gerasimuk

Re: pgAdmin 4 v4.30 released

[androxkentaki]

Where is x86 setup file for Windows?

czw., 28 sty 2021 o 14:14 Akshay Joshi 
napisał(a):

> The pgAdmin Development Team is pleased to announce pgAdmin 4 version 4.30.
> This release of pgAdmin 4 includes 38 bug fixes and new features. For
> more details please see the release notes at:
>
> https://www.pgadmin.org/docs/pgadmin4/4.30/release_notes_4_30.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:*
>
>- ERD Tool (Beta):
>
> The Entity-Relationship Diagram (ERD) tool is a database design tool that
> provides a graphical representation of database tables, columns, and
> inter-relationships. You can use the ERD tool to design a new schema and
> generate the SQL required to create it or to reverse engineer and diagram
> an existing database schema.
>
>
>- Kerberos Support:
>
> Kerberos support is added in pgAdmin 4 using SPNEGO for logging into
> pgAdmin, similar to the existing LDAP and "internal" options. Note that
> support for logging into database servers using Kerberos is not included in
> this release, but will be added in a future version.
>
>
>- Add a container option (PGADMIN_DISABLE_POSTFIX) to disable the
>Postfix server:
>
> Postfix (like other MTAs) must start as user 'root', and the pgAdmin
> container achieves this using 'sudo'. Whilst that works well in most
> environments, it can cause problems in some. This option allows you to
> completely disable Postfix to avoid these issues, though you will need to
> configure an external mail server to be used to send password reset emails.
>
>
> *Bugs/Housekeeping:*
>
>- Improve the explain plan details by showing a popup instead of a
>tooltip when clicking on plan nodes.
>- Ensure that verbose logs are visible for Utility (Backup,
>Maintenance etc.) jobs.
>- Added support for expressions in exclusion constraints.
>- Ensure that the 'template1' database is not visible after pg_upgrade.
>- Added appropriate help message and a placeholder for letting users
>know about the account password expiry for Login/Group Role.
>- Updated Flask-BabelEx to the latest version. Fixed extra parentheses
>issue around joins for Views.
>- Ensure that the current value of sequences is ignored while
>comparing using Schema Diff.
>- Fixed an issue when the user tries to delete multiple records in the
>data grid.
>- Fixed TypeError exception in schema diff when selecting two
>identical objects.
>- Include PostgreSQL 13 utilities in the container distribution.
>
>
> 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
>
>
>
>

-- 
Z wyrazami szacunku
Andrzej Gerasimuk

Re: pgAdmin 4 v4.30 released

[androxkentaki]

Hello

Thanks for fast response
So is there any fast way to migrate all settings from x86 to x64 of pgAdmin?

pon., 1 lut 2021 o 09:38 Fahar Abbas 
napisał(a):

> Hi,
>
> We have dropped the support for x86 installer for pgadmin4
>
> 32 bit Windows support is available for versions up to v4.29.
> https://www.pgadmin.org/download/pgadmin-4-windows/
>
> On Mon, Feb 1, 2021 at 1:14 PM androxkentaki 
> wrote:
>
>> Where is x86 setup file for Windows?
>>
>> czw., 28 sty 2021 o 14:14 Akshay Joshi 
>> napisał(a):
>>
>>> The pgAdmin Development Team is pleased to announce pgAdmin 4 version
>>> 4.30.
>>> This release of pgAdmin 4 includes 38 bug fixes and new features. For
>>> more details please see the release notes at:
>>>
>>> https://www.pgadmin.org/docs/pgadmin4/4.30/release_notes_4_30.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:*
>>>
>>>- ERD Tool (Beta):
>>>
>>> The Entity-Relationship Diagram (ERD) tool is a database design tool
>>> that provides a graphical representation of database tables, columns, and
>>> inter-relationships. You can use the ERD tool to design a new schema and
>>> generate the SQL required to create it or to reverse engineer and diagram
>>> an existing database schema.
>>>
>>>
>>>- Kerberos Support:
>>>
>>> Kerberos support is added in pgAdmin 4 using SPNEGO for logging into
>>> pgAdmin, similar to the existing LDAP and "internal" options. Note that
>>> support for logging into database servers using Kerberos is not included in
>>> this release, but will be added in a future version.
>>>
>>>
>>>- Add a container option (PGADMIN_DISABLE_POSTFIX) to disable the
>>>Postfix server:
>>>
>>> Postfix (like other MTAs) must start as user 'root', and the pgAdmin
>>> container achieves this using 'sudo'. Whilst that works well in most
>>> environments, it can cause problems in some. This option allows you to
>>> completely disable Postfix to avoid these issues, though you will need to
>>> configure an external mail server to be used to send password reset emails.
>>>
>>>
>>> *Bugs/Housekeeping:*
>>>
>>>- Improve the explain plan details by showing a popup instead of a
>>>tooltip when clicking on plan nodes.
>>>- Ensure that verbose logs are visible for Utility (Backup,
>>>Maintenance etc.) jobs.
>>>- Added support for expressions in exclusion constraints.
>>>- Ensure that the 'template1' database is not visible after
>>>pg_upgrade.
>>>- Added appropriate help message and a placeholder for letting users
>>>know about the account password expiry for Login/Group Role.
>>>- Updated Flask-BabelEx to the latest version. Fixed extra
>>>parentheses issue around joins for Views.
>>>- Ensure that the current value of sequences is ignored while
>>>comparing using Schema Diff.
>>>- Fixed an issue when the user tries to delete multiple records in
>>>the data grid.
>>>- Fixed TypeError exception in schema diff when selecting two
>>>identical objects.
>>>- Include PostgreSQL 13 utilities in the container distribution.
>>>
>>>
>>> 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
>>>
>>>
>>>
>>>
>>
>> --
>> Z wyrazami szacunku
>> Andrzej Gerasimuk
>>
>
>
> --
> Fahar Abbas
> EnterpriseDB Corporation
> Phone Office: +92-51-835-8874
> Phone Direct: +92-51-8466803
> Mobile: +92-333-5409707
> Skype ID: *live:fahar.abbas*
> Website: www.enterprisedb.com
>


-- 
Z wyrazami szacunku
Andrzej Gerasimuk

Re: pgAdmin 4 v4.30 released

[androxkentaki]

Hi Aditya

Thank You.
I will try that

pon., 1 lut 2021 o 09:59 Aditya Toshniwal 
napisał(a):

> Hi Andrej,
>
> You can uninstall the 32 bit version and install the 64 bit. The settings
> will stay.
> Just to be safe, make a copy of the file - %APPDATA%/ Roaming>/pgAdmin/pgadmin4.db, which contains all the settings.
> You do not need to take backup of PostgreSQL database.
>
> On Mon, Feb 1, 2021 at 2:18 PM Fahar Abbas 
> wrote:
>
>> Hi,
>>
>> On Mon, Feb 1, 2021 at 1:39 PM androxkentaki 
>> wrote:
>>
>>> Hello
>>>
>>> Thanks for fast response
>>> So is there any fast way to migrate all settings from x86 to x64 of
>>> pgAdmin?
>>>
>> Can you please take a database backup from x86 and restore it into the
>> x64 machine?
>> https://www.pgadmin.org/docs/pgadmin4/development/backup_dialog.html
>> Kind Regards,
>>
>>>
>>> pon., 1 lut 2021 o 09:38 Fahar Abbas 
>>> napisał(a):
>>>
>>>> Hi,
>>>>
>>>> We have dropped the support for x86 installer for pgadmin4
>>>>
>>>> 32 bit Windows support is available for versions up to v4.29.
>>>> https://www.pgadmin.org/download/pgadmin-4-windows/
>>>>
>>>> On Mon, Feb 1, 2021 at 1:14 PM androxkentaki 
>>>> wrote:
>>>>
>>>>> Where is x86 setup file for Windows?
>>>>>
>>>>> czw., 28 sty 2021 o 14:14 Akshay Joshi 
>>>>> napisał(a):
>>>>>
>>>>>> The pgAdmin Development Team is pleased to announce pgAdmin 4 version
>>>>>> 4.30.
>>>>>> This release of pgAdmin 4 includes 38 bug fixes and new features.
>>>>>> For more details please see the release notes at:
>>>>>>
>>>>>>
>>>>>> https://www.pgadmin.org/docs/pgadmin4/4.30/release_notes_4_30.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:*
>>>>>>
>>>>>>- ERD Tool (Beta):
>>>>>>
>>>>>> The Entity-Relationship Diagram (ERD) tool is a database design tool
>>>>>> that provides a graphical representation of database tables, columns, and
>>>>>> inter-relationships. You can use the ERD tool to design a new schema and
>>>>>> generate the SQL required to create it or to reverse engineer and diagram
>>>>>> an existing database schema.
>>>>>>
>>>>>>
>>>>>>- Kerberos Support:
>>>>>>
>>>>>> Kerberos support is added in pgAdmin 4 using SPNEGO for logging into
>>>>>> pgAdmin, similar to the existing LDAP and "internal" options. Note that
>>>>>> support for logging into database servers using Kerberos is not included 
>>>>>> in
>>>>>> this release, but will be added in a future version.
>>>>>>
>>>>>>
>>>>>>- Add a container option (PGADMIN_DISABLE_POSTFIX) to disable the
>>>>>>Postfix server:
>>>>>>
>>>>>> Postfix (like other MTAs) must start as user 'root', and the pgAdmin
>>>>>> container achieves this using 'sudo'. Whilst that works well in most
>>>>>> environments, it can cause problems in some. This option allows you to
>>>>>> completely disable Postfix to avoid these issues, though you will need to
>>>>>> configure an external mail server to be used to send password reset 
>>>>>> emails.
>>>>>>
>>>>>>
>>>>>> *Bugs/Housekeeping:*
>>>>>>
>>>>>>- Improve the explain plan details by showing a popup instead of
>>>>>>a tooltip when clicking on plan nodes.
>>>>>>- Ensure that verbose logs are visible for Utility (Backup,
>>>>>>Maintenance etc.) jobs.
>>>>>>- Added support for expressions in exclusion constraints.
>>>>>>- Ensure that the 'template1' database is not visible after
>>>>>>pg_upgrade.
>>>>>>

Re: pgAdmin 4 v4.30 released

[androxkentaki]

Works automatically and almost perfect.
It didn't restore one setting: to open query tool in new tab in browser (i
was updating 4.27 to 4.30)





pon., 1 lut 2021 o 10:04 androxkentaki  napisał(a):

> Hi Aditya
>
> Thank You.
> I will try that
>
> pon., 1 lut 2021 o 09:59 Aditya Toshniwal <
> aditya.toshni...@enterprisedb.com> napisał(a):
>
>> Hi Andrej,
>>
>> You can uninstall the 32 bit version and install the 64 bit. The settings
>> will stay.
>> Just to be safe, make a copy of the file - %APPDATA%/> Roaming>/pgAdmin/pgadmin4.db, which contains all the settings.
>> You do not need to take backup of PostgreSQL database.
>>
>> On Mon, Feb 1, 2021 at 2:18 PM Fahar Abbas 
>> wrote:
>>
>>> Hi,
>>>
>>> On Mon, Feb 1, 2021 at 1:39 PM androxkentaki 
>>> wrote:
>>>
>>>> Hello
>>>>
>>>> Thanks for fast response
>>>> So is there any fast way to migrate all settings from x86 to x64 of
>>>> pgAdmin?
>>>>
>>> Can you please take a database backup from x86 and restore it into the
>>> x64 machine?
>>> https://www.pgadmin.org/docs/pgadmin4/development/backup_dialog.html
>>> Kind Regards,
>>>
>>>>
>>>> pon., 1 lut 2021 o 09:38 Fahar Abbas 
>>>> napisał(a):
>>>>
>>>>> Hi,
>>>>>
>>>>> We have dropped the support for x86 installer for pgadmin4
>>>>>
>>>>> 32 bit Windows support is available for versions up to v4.29.
>>>>> https://www.pgadmin.org/download/pgadmin-4-windows/
>>>>>
>>>>> On Mon, Feb 1, 2021 at 1:14 PM androxkentaki 
>>>>> wrote:
>>>>>
>>>>>> Where is x86 setup file for Windows?
>>>>>>
>>>>>> czw., 28 sty 2021 o 14:14 Akshay Joshi 
>>>>>> napisał(a):
>>>>>>
>>>>>>> The pgAdmin Development Team is pleased to announce pgAdmin 4
>>>>>>> version 4.30.
>>>>>>> This release of pgAdmin 4 includes 38 bug fixes and new features.
>>>>>>> For more details please see the release notes at:
>>>>>>>
>>>>>>>
>>>>>>> https://www.pgadmin.org/docs/pgadmin4/4.30/release_notes_4_30.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:*
>>>>>>>
>>>>>>>- ERD Tool (Beta):
>>>>>>>
>>>>>>> The Entity-Relationship Diagram (ERD) tool is a database design tool
>>>>>>> that provides a graphical representation of database tables, columns, 
>>>>>>> and
>>>>>>> inter-relationships. You can use the ERD tool to design a new schema and
>>>>>>> generate the SQL required to create it or to reverse engineer and 
>>>>>>> diagram
>>>>>>> an existing database schema.
>>>>>>>
>>>>>>>
>>>>>>>- Kerberos Support:
>>>>>>>
>>>>>>> Kerberos support is added in pgAdmin 4 using SPNEGO for logging into
>>>>>>> pgAdmin, similar to the existing LDAP and "internal" options. Note that
>>>>>>> support for logging into database servers using Kerberos is not 
>>>>>>> included in
>>>>>>> this release, but will be added in a future version.
>>>>>>>
>>>>>>>
>>>>>>>- Add a container option (PGADMIN_DISABLE_POSTFIX) to disable
>>>>>>>the Postfix server:
>>>>>>>
>>>>>>> Postfix (like other MTAs) must start as user 'root', and the pgAdmin
>>>>>>> container achieves this using 'sudo'. Whilst that works well in most
>>>>>>> environments, it can cause problems in some. This option allows you to
>>>>>>> completely disable Postfix to avoid these issues, though you will need 
>>>>>>> to
>>>>>>> configure an external mail serv

Re: v4.30 windows x86 version

[androxkentaki .]

I can confirm that
X86 to x64 migration of pgAdmin is very simple now


Pozdrawiam
Andrzej Gerasimuk

From: Dave Page 
Sent: Monday, February 8, 2021 7:50:42 PM
To: Steve Martin 
Cc: pgadmin-support@lists.postgresql.org 
Subject: Re: v4.30 windows x86 version

Hi

On Mon, 8 Feb 2021 at 17:06, Steve Martin  wrote:
i've been using the x86 version of PGAdmin on windows. it looks like the 4.30 
release doesn't have an x86 version. is that intentional?

Yes.


because there's no easy way that i can see to export my current connections and 
groups, i'm trying to avoid moving to the x64 version if i don't have to.

You don’t need to. Just uninstall the 32 bit version and then install the 64 
bit. The same config database will be used.



thanks.


--
Steve Martin
Director of Engineering

[https://i.ibb.co/XY2tQ4J/Sapient-Wordmark.png]
--
--
Dave Page
https://pgsnake.blogspot.com

EDB Postgres
https://www.enterprisedb.com

Re: PgAdmin 4 V5.0

[androxkentaki .]

Great worka.
But still there are sobie things to improve. eg:
No icon in tray on Windows start bar when i work on query editor in separate 
window (and Windows dont Group edito with PG admin. IT treats it as a different 
separate thread)

And searching is still very unusable (in browser i have a substitute of ctrl+F) 
.

But regard of that. Great job

Pozdrawiam
Andrzej Gerasimuk

From: Ray O'Donnell 
Sent: Sunday, March 7, 2021 11:46:47 AM
To: Paulo Toledo ; 
pgadmin-support@lists.postgresql.org 
Subject: Re: PgAdmin 4 V5.0

On 06/03/2021 21:14, Paulo Toledo wrote:
> Hello,
> I write only to thank the excellent work you have done in pgAdmin v5.0 4.
> Everyone is to be congratulated.

Amen to this! I particularly like the fact that it's no longer confined
to the browser. Well done Dave and all the team!

Ray.


--
Raymond O'Donnell // Galway // Ireland
r...@rodonnell.ie

Re: pgAdmin 4 v5.1 Released

[androxkentaki]

Great job Guys.

But pls make some searching tool for opening SQL query file
Feature #5296

czw., 25 mar 2021 o 13:31 Akshay Joshi 
napisał(a):

> The pgAdmin Development Team is pleased to announce pgAdmin 4 version 5.1.
>
> This release of pgAdmin 4 includes 42 bug fixes and new features. For
> more details please see the release notes at:
>
> https://www.pgadmin.org/docs/pgadmin4/5.1/release_notes_5_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:
>
>-
>
>Zoom scaling options with keyboard shortcuts in runtime:
>
> This feature includes the zoom scaling (Zoom In, Zoom Out, Actual Size)
> options along with Enter/Exit Full-Screen mode. We have added the options
> in Menu as well as using keyboard shortcuts users can perform the desired
> operation.
>
>-
>
>Show the login roles that are members of a group role be shown when
>examining a group role.
>-
>
>Added '--replace' option in Import server to replace the list of
>servers with the newly imported one.
>-
>
>Make the container distribution a multi-arch build with x86_64 and
>Arm64 support.
>-
>
>Make 'Kerberos an optional feature in the Python wheel, to avoid the
>need to install MIT Kerberos on the system by default.
>
> Bugs/Housekeeping:
>
>-
>
>Fixed an issue where hanging symlinks in a directory caused the select
>file dialog to break.
>-
>
>Make the 'Save Data Changes' icon to be more intuitive.
>-
>
>Ensure that cell content being auto-selected when editing the cell
>data.
>-
>
>Ensure that SQL formatter should not add extra tabs and format the SQL
>correctly.
>-
>
>Ensure that SQL formatter should not use tab size if 'Use spaces?' set
>to false.
>-
>
>Fixed encoding issue when database encoding set to SQL_ASCII and name
>of the column is in ASCII character.
>-
>
>Ensure that the user should be able to kill the session from Dashboard
>if the user has a 'pg_signal_backend' role.
>-
>
>Ensure PGADMIN_DEFAULT_EMAIL looks sane when initializing a container
>deployment.
>-
>
>Fixed an issue where the user is not able to change the connection in
>Query Tool when any SQL file is opened.
>-
>
>Fixed an issue where copy/paste rows in view data paste the wrong
>value for boolean type.
>-
>
>Ensure that toggle buttons are accessible by most screen readers.
>
> 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
>
>

-- 
Z wyrazami szacunku
Andrzej Gerasimuk

pgAdmin 4 v5 Crashes on right click in Query window

[androxkentaki]

Hi

Can You tell me is it planned feature or is it an bug.
I have installed pgA 4 v5.2 (and on v5.1 was the same)
OS is W10 Pro 64 bit (PL)
SLQ Query form is configured to open as a separate window.
I have dark mode activated.

And when I open the Query window there are two issues
1. BIG one. When i click on any area of the query editor by right button of
mouse pgAdmnin crashes (i think). Query window and main pgAdmin window
disappear and nwjs process is killed.


[image: obraz.png]

I have tested with v5.1 - the same
I have tested on other computer with W10 and similar configuration of
pgAdmin - the same
So it is not an environmental problem.



2. The query editor is treated by W10 as a separate app in the same
process. This separate app doesn't have an icon so it is displayed on the
taskbar as a red square. (this is only a visual issue, not a bug :) )


[image: obraz.png]


Can You pls help me with this first problem

-- 
Z wyrazami szacunku
Andrzej Gerasimuk

Re: pgAdmin 4 v5 Crashes on right click in Query window

[androxkentaki]

Thanks for the fast reply :)

So i assume, that You are working to resolve the issue

Do You need any info or make an test?

If Yes, feel free to contact me.
I will provide to You everything that You want.

wt., 11 maj 2021 o 12:10 Akshay Joshi 
napisał(a):

> Hi Androxkentaki
>
> On Tue, May 11, 2021 at 3:32 PM androxkentaki 
> wrote:
>
>> Hi
>>
>> Can You tell me is it planned feature or is it an bug.
>> I have installed pgA 4 v5.2 (and on v5.1 was the same)
>> OS is W10 Pro 64 bit (PL)
>> SLQ Query form is configured to open as a separate window.
>> I have dark mode activated.
>>
>> And when I open the Query window there are two issues
>> 1. BIG one. When i click on any area of the query editor by right button
>> of mouse pgAdmnin crashes (i think). Query window and main pgAdmin window
>> disappear and nwjs process is killed.
>>
>>
>> [image: obraz.png]
>>
>> I have tested with v5.1 - the same
>> I have tested on other computer with W10 and similar configuration of
>> pgAdmin - the same
>> So it is not an environmental problem.
>>
>
> Yes, this is a known issue (https://redmine.postgresql.org/issues/6301).
> We have also asked for help in
> https://gitter.im/nwjs/nw.js?at=57bd5e09cd00bdff6e760a4d.
> What is the setting of Query Tool, try to open it in the same window
> instead of the new window.
>
>>
>>
>>
>> 2. The query editor is treated by W10 as a separate app in the same
>> process. This separate app doesn't have an icon so it is displayed on the
>> taskbar as a red square. (this is only a visual issue, not a bug :) )
>>
>>
>> [image: obraz.png]
>>
>>
>> Can You pls help me with this first problem
>>
>
> This is also a known issue (https://redmine.postgresql.org/issues/6258)
> we have logged the issue to the NWjs community
> https://github.com/nwjs/nw.js/issues/7236.
>
>>
>> --
>> Z wyrazami szacunku
>> Andrzej Gerasimuk
>>
>
>
> --
> *Thanks & Regards*
> *Akshay Joshi*
> *pgAdmin Hacker | Principal Software Architect*
> *EDB Postgres <http://edbpostgres.com>*
>
> *Mobile: +91 976-788-8246*
>


-- 
Z wyrazami szacunku
Andrzej Gerasimuk

Re: pgAdmin 4 v5 Crashes on right click in Query window

[androxkentaki]

With NWjs i can't help

but with second one
when i delete query tool and debugger from "Open in new browser tab" the
right button click has stopped. The menu prompt form RBC displayed properly.

When i add again QT and Debg to  Open in new browser tab the problem didn't
came back.
Even after pgA restart it is working properly

Is this some kind of temporary solution for this issue??

I will monitor and when it comes back I will inform You about it.

wt., 11 maj 2021 o 13:13 Akshay Joshi 
napisał(a):

>
>
> On Tue, May 11, 2021 at 4:37 PM androxkentaki 
> wrote:
>
>> Thanks for the fast reply :)
>>
>> So i assume, that You are working to resolve the issue
>>
>
> We have started to fix it but the problem is NWjs is crashing and we
> are waiting to get the correct information on "How to decode crash dump?".
>
>>
>> Do You need any info or make an test?
>>
>
> Have you tested it with Query Tool opens in the same window as a
> separate tab? I am assuming the application is crashed when we have open
> Query Tool in a separate window.
>
>>
>> If Yes, feel free to contact me.
>> I will provide to You everything that You want.
>>
>> wt., 11 maj 2021 o 12:10 Akshay Joshi 
>> napisał(a):
>>
>>> Hi Androxkentaki
>>>
>>> On Tue, May 11, 2021 at 3:32 PM androxkentaki 
>>> wrote:
>>>
>>>> Hi
>>>>
>>>> Can You tell me is it planned feature or is it an bug.
>>>> I have installed pgA 4 v5.2 (and on v5.1 was the same)
>>>> OS is W10 Pro 64 bit (PL)
>>>> SLQ Query form is configured to open as a separate window.
>>>> I have dark mode activated.
>>>>
>>>> And when I open the Query window there are two issues
>>>> 1. BIG one. When i click on any area of the query editor by right
>>>> button of mouse pgAdmnin crashes (i think). Query window and main pgAdmin
>>>> window disappear and nwjs process is killed.
>>>>
>>>>
>>>> [image: obraz.png]
>>>>
>>>> I have tested with v5.1 - the same
>>>> I have tested on other computer with W10 and similar configuration of
>>>> pgAdmin - the same
>>>> So it is not an environmental problem.
>>>>
>>>
>>> Yes, this is a known issue (
>>> https://redmine.postgresql.org/issues/6301). We have also asked for
>>> help in https://gitter.im/nwjs/nw.js?at=57bd5e09cd00bdff6e760a4d.
>>> What is the setting of Query Tool, try to open it in the same window
>>> instead of the new window.
>>>
>>>>
>>>>
>>>>
>>>> 2. The query editor is treated by W10 as a separate app in the same
>>>> process. This separate app doesn't have an icon so it is displayed on the
>>>> taskbar as a red square. (this is only a visual issue, not a bug :) )
>>>>
>>>>
>>>> [image: obraz.png]
>>>>
>>>>
>>>> Can You pls help me with this first problem
>>>>
>>>
>>> This is also a known issue (
>>> https://redmine.postgresql.org/issues/6258) we have logged the issue to
>>> the NWjs communityhttps://github.com/nwjs/nw.js/issues/7236.
>>>
>>>>
>>>> --
>>>> Z wyrazami szacunku
>>>> Andrzej Gerasimuk
>>>>
>>>
>>>
>>> --
>>> *Thanks & Regards*
>>> *Akshay Joshi*
>>> *pgAdmin Hacker | Principal Software Architect*
>>> *EDB Postgres <http://edbpostgres.com>*
>>>
>>> *Mobile: +91 976-788-8246*
>>>
>>
>>
>> --
>> Z wyrazami szacunku
>> Andrzej Gerasimuk
>>
>
>
> --
> *Thanks & Regards*
> *Akshay Joshi*
> *pgAdmin Hacker | Principal Software Architect*
> *EDB Postgres <http://edbpostgres.com>*
>
> *Mobile: +91 976-788-8246*
>


-- 
Z wyrazami szacunku
Andrzej Gerasimuk

Re: pgAdmin 4 v5 Crashes on right click in Query window

[androxkentaki]

Hi guys.

Unfortunately I don't have good news.
This workaround solution is working till OS restart.

Today, after reboot the right click button issue came back again...


wt., 11 maj 2021 o 13:25 androxkentaki  napisał(a):

> With NWjs i can't help
>
> but with second one
> when i delete query tool and debugger from "Open in new browser tab" the
> right button click has stopped. The menu prompt form RBC displayed properly.
>
> When i add again QT and Debg to  Open in new browser tab the problem
> didn't came back.
> Even after pgA restart it is working properly
>
> Is this some kind of temporary solution for this issue??
>
> I will monitor and when it comes back I will inform You about it.
>
> wt., 11 maj 2021 o 13:13 Akshay Joshi 
> napisał(a):
>
>>
>>
>> On Tue, May 11, 2021 at 4:37 PM androxkentaki 
>> wrote:
>>
>>> Thanks for the fast reply :)
>>>
>>> So i assume, that You are working to resolve the issue
>>>
>>
>> We have started to fix it but the problem is NWjs is crashing and we
>> are waiting to get the correct information on "How to decode crash dump?".
>>
>>>
>>> Do You need any info or make an test?
>>>
>>
>> Have you tested it with Query Tool opens in the same window as a
>> separate tab? I am assuming the application is crashed when we have open
>> Query Tool in a separate window.
>>
>>>
>>> If Yes, feel free to contact me.
>>> I will provide to You everything that You want.
>>>
>>> wt., 11 maj 2021 o 12:10 Akshay Joshi 
>>> napisał(a):
>>>
>>>> Hi Androxkentaki
>>>>
>>>> On Tue, May 11, 2021 at 3:32 PM androxkentaki 
>>>> wrote:
>>>>
>>>>> Hi
>>>>>
>>>>> Can You tell me is it planned feature or is it an bug.
>>>>> I have installed pgA 4 v5.2 (and on v5.1 was the same)
>>>>> OS is W10 Pro 64 bit (PL)
>>>>> SLQ Query form is configured to open as a separate window.
>>>>> I have dark mode activated.
>>>>>
>>>>> And when I open the Query window there are two issues
>>>>> 1. BIG one. When i click on any area of the query editor by right
>>>>> button of mouse pgAdmnin crashes (i think). Query window and main pgAdmin
>>>>> window disappear and nwjs process is killed.
>>>>>
>>>>>
>>>>> [image: obraz.png]
>>>>>
>>>>> I have tested with v5.1 - the same
>>>>> I have tested on other computer with W10 and similar configuration of
>>>>> pgAdmin - the same
>>>>> So it is not an environmental problem.
>>>>>
>>>>
>>>> Yes, this is a known issue (
>>>> https://redmine.postgresql.org/issues/6301). We have also asked for
>>>> help in https://gitter.im/nwjs/nw.js?at=57bd5e09cd00bdff6e760a4d.
>>>> What is the setting of Query Tool, try to open it in the same
>>>> window instead of the new window.
>>>>
>>>>>
>>>>>
>>>>>
>>>>> 2. The query editor is treated by W10 as a separate app in the same
>>>>> process. This separate app doesn't have an icon so it is displayed on the
>>>>> taskbar as a red square. (this is only a visual issue, not a bug :) )
>>>>>
>>>>>
>>>>> [image: obraz.png]
>>>>>
>>>>>
>>>>> Can You pls help me with this first problem
>>>>>
>>>>
>>>> This is also a known issue (
>>>> https://redmine.postgresql.org/issues/6258) we have logged the issue
>>>> to the NWjs communityhttps://github.com/nwjs/nw.js/issues/7236.
>>>>
>>>>>
>>>>> --
>>>>> Z wyrazami szacunku
>>>>> Andrzej Gerasimuk
>>>>>
>>>>
>>>>
>>>> --
>>>> *Thanks & Regards*
>>>> *Akshay Joshi*
>>>> *pgAdmin Hacker | Principal Software Architect*
>>>> *EDB Postgres <http://edbpostgres.com>*
>>>>
>>>> *Mobile: +91 976-788-8246*
>>>>
>>>
>>>
>>> --
>>> Z wyrazami szacunku
>>> Andrzej Gerasimuk
>>>
>>
>>
>> --
>> *Thanks & Regards*
>> *Akshay Joshi*
>> *pgAdmin Hacker | Principal Software Architect*
>> *EDB Postgres <http://edbpostgres.com>*
>>
>> *Mobile: +91 976-788-8246*
>>
>
>
> --
> Z wyrazami szacunku
> Andrzej Gerasimuk
>


-- 
Z wyrazami szacunku
Andrzej Gerasimuk

Re: pgAdmin 4 v6.0 Released

[androxkentaki]

great work!

But still i don't see any update with fatal error v5 right clicking in SQL
Editor kills pgAdmin https://redmine.postgresql.org/issues/6301

czw., 7 paź 2021 o 14:35 Akshay Joshi 
napisał(a):

> The pgAdmin Development Team is pleased to announce pgAdmin 4 version 6.0.
>
>
>
> This release of pgAdmin 4 includes 18 bug fixes and new features. For
> more details please see the release notes at:
>
>
>
> https://www.pgadmin.org/docs/pgadmin4/6.0/release_notes_6_0.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:
>
> Introduction to ReactJS Framework in pgAdmin 4:
>
> ReactJS has a strong developer community and popularity. It has grown to a
> level where its performance is comparable to that of desktop applications.
> Migrating pgAdmin to use ReactJS has proven to boost pgAdmin's performance
> and user experience.
>
> In this release, we have ported the browser Tree, all the object dialogs,
> and the Grant Wizard.
>
> Features:
>
>-
>
>Added support for OWNED BY Clause for sequences.
>
>
>
> This feature adds the OWNED BY clause for the sequences. The OWNED BY
> option causes the sequence to be associated with a specific table column,
> such that if that column (or its whole table) is dropped, the sequence will
> be automatically dropped as well.
>
> Bugs/Housekeeping:
>
>-
>
>Port object nodes and properties dialogs to React.
>-
>
>Port browser tree to React.
>-
>
>Port Grant Wizard to react.
>-
>
>Remove GPDB support completely.
>-
>
>Added support to create the Partitioned table using COLLATE and
>opclass.
>-
>
>Fixed keyerror issue in schema diff for 'attnum' and 'edit_types'
>parameter.
>-
>
>Fixed an issue where the Execute button of the query tool gets
>disabled once we change anything in the data grid.
>-
>
>Ensure that SQL help should work for EPAS servers.
>-
>
>Fixed an issue where the grant wizard is unresponsive if the database
>size is huge.
>
>
>
> *Note: The publication of the python package to PyPi has been delayed and
> will be completed as soon as possible.*
>
> 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
>
>

-- 
Z wyrazami szacunku
Andrzej Gerasimuk