pgAdmin 4 v2.1 released!
The pgAdmin Development Team are pleased to announce pgAdmin 4 version 2.1. This release of pgAdmin 4 includes nearly 90 bug fixes and new features. For more details please see the release notes at https://www.pgadmin.org/docs/pgadmin4/dev/release_notes_2_1.html. Notable changes in this release include: * Support for colouring connections in the treeview and query tool * Configurable formatting for CSV and clipboard datasets * Editing of table data for tables with OIDs but no primary keys * Immediately retrieve default column values when saving new/edited rows in the query tool We've also added a new distribution in the form of a Docker Container. See the Docker Hub repo for more information: https://hub.docker.com/r/dpage/pgadmin4/ Download your copy of pgAdmin here: https://www.pgadmin.org/download Regards, Dave -- Dave Page pgAdmin Development Team
Re: pgAdmin 4 v2.1 released!
is there a 64-bit version available for MS-Windows..??
Re: pgAdmin 4 v2.1 released!
On Thu, Jan 11, 2018 at 3:13 PM, André Verwijs wrote: > is there a 64-bit version available for MS-Windows..?? > No, just use the 32bit version. There's no real benefit from having it be built as 64bit - just the downside of having to maintain 2 builds instead of 1. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Re: pgAdmin 4 v2.1 released!
What happens when it’s installed via the EDB PostgreSQL 64-bit Windows package? On January 11, 2018 at 10:15:35 AM, Dave Page (dp...@pgadmin.org) wrote: On Thu, Jan 11, 2018 at 3:13 PM, André Verwijs wrote: > is there a 64-bit version available for MS-Windows..?? > No, just use the 32bit version. There's no real benefit from having it be built as 64bit - just the downside of having to maintain 2 builds instead of 1. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Re: pgAdmin 4 v2.1 released!
On Thu, Jan 11, 2018 at 3:19 PM, Anthony DeBarros wrote: > What happens when it’s installed via the EDB PostgreSQL 64-bit Windows > package? > I assume you get a 64bit version, but to be honest, I've never looked. Sandeep, can you confirm please? > > > On January 11, 2018 at 10:15:35 AM, Dave Page (dp...@pgadmin.org) wrote: > > > > On Thu, Jan 11, 2018 at 3:13 PM, André Verwijs > wrote: > >> is there a 64-bit version available for MS-Windows..?? >> > > No, just use the 32bit version. There's no real benefit from having it be > built as 64bit - just the downside of having to maintain 2 builds instead > of 1. > > -- > Dave Page > Blog: http://pgsnake.blogspot.com > Twitter: @pgsnake > > EnterpriseDB UK: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
pgadmin Windows has no option to edit configuration files...
pgadmin Windows has no option to edit configuration files "C:\Program Files\PostgreSQL 10\data\pg_hba.conf" "C:\Program Files\PostgreSQL 10\data\postgresql.conf" i don't recommend doing this by hand, is it possible to add this option? André
Re: pgadmin Windows has no option to edit configuration files...
On Thu, Jan 11, 2018 at 2:35 PM, André Verwijs wrote: > pgadmin Windows has no option to edit configuration files > > "C:\Program Files\PostgreSQL 10\data\pg_hba.conf" > "C:\Program Files\PostgreSQL 10\data\postgresql.conf" > > i don't recommend doing this by hand, is it possible to add this option? To my understanding pgAdmin is limited to communicating with PostgreSQL via a session - there is no guarantee that the two programs are even on the same machine. IOW, editing server boot configuration files seems outside of pgAdmin's charter. Administration of the contents of databases it what is targeted, not getting the server up and running in the first place. Configuration management tools cover the later. I suppose it could wrap a UI on top of "ALTER SYSTEM"... As of now there is no SQL-means to edit pg_hba.conf You might need to accept that you are in the minority that those files should not be hand edited - ALTER SYSTEM provides for specialized usage but at the end of the day the desire for UI tools for those two (three: ident) files is pretty limited (at least relative to the cost to develop one). David J.
Re: pgadmin Windows has no option to edit configuration files...
PgAdminIII did/does have the facility to edit the postgresql.conf & pg_hba.conf. However, as David G. Johnston pointed out, it was limited to editing _local_ versions of those files. >i don't recommend doing this by hand, ... That statement implies that you feel that using a GUI will protect you from making errors. That is untrue. If you use a GUI to change the authentication method in the pg_hba.conf (not to mention other critical parameters), you could easily lock out many users upon reloading/restart. Likewise, the same applies for changing values in postgresql.conf. Simply having an easy way to change values does not mean you will be protected from setting them too high(or wrong). EG: setting work_mem to 1GB will be very bad.It is better to learn and understand WHY you need to change values, than just having an easy way to do so. Melvin Davidson 🎸 I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you. www.youtube.com/unusedhero/videos Folk Alley - All Folk - 24 Hours a day www.folkalley.com On Thursday, January 11, 2018, 4:49:47 PM EST, David G. Johnston wrote: On Thu, Jan 11, 2018 at 2:35 PM, André Verwijs wrote: pgadmin Windows has no option to edit configuration files "C:\Program Files\PostgreSQL 10\data\pg_hba.conf" "C:\Program Files\PostgreSQL 10\data\postgresql.conf" i don't recommend doing this by hand, is it possible to add this option? To my understanding pgAdmin is limited to communicating with PostgreSQL via a session - there is no guarantee that the two programs are even on the same machine. IOW, editing server boot configuration files seems outside of pgAdmin's charter. Administration of the contents of databases it what is targeted, not getting the server up and running in the first place. Configuration management tools cover the later. I suppose it could wrap a UI on top of "ALTER SYSTEM"... As of now there is no SQL-means to edit pg_hba.conf You might need to accept that you are in the minority that those files should not be hand edited - ALTER SYSTEM provides for specialized usage but at the end of the day the desire for UI tools for those two (three: ident) files is pretty limited (at least relative to the cost to develop one). David J.
