Re: centos 7 / pgadmin 4.7

On Wed, Jun 5, 2019 at 8:16 PM Alex Williams wrote: > Hi Khushboo, > > Thanks! This is working after the update. I've put two outputs below, the > yum update / console output: > > Good to hear that everything is working fine. 1. [root@centos7dev output]# yum update > Loaded plugins: fastestmirro

Re: BUG #15831: pgadmin bug: add column and comment failure when you alter table

Hi Smeda, By description do you mean comments ? If that is the case, I'm able to do it. Could you please share screenshots ? > > From: PG Bug reporting form > Date: Mon, Jun 3, 2019 at 2:44 PM > Subject: BUG #15831: pgadmin bug: add column and comment failure when you > alter table > To: > Cc:

pgpool-II is not following new master node post master fail over

Hi , I am using repmgr to manage the auto fail over process at PostgreSQL Database layer in a 3 node master - slave replication . Also using pgpool-II to manage the load balancing and application connection routing. But when any master failover is happening at DB side and new master is promote

Re: pgAdmin4 4.8 Kubuntu issues

Dave, On Wed, Jun 5, 2019 at 12:13 PM Dave Page wrote: > Richard, > > On Wed, Jun 5, 2019 at 4:55 PM richard coleman < > rcoleman.ascen...@gmail.com> wrote: > >> Dave, >> >> Actually I thought I was being quite restrained in my assessment. With >> version 4.8 the developers completely upended t

Re: pgAdmin4 4.8 Kubuntu issues

Michel, I appreciate your taking the time to weigh in on this. As I mentioned previously, I can understand why this feature was added, other applications have a "*master password to protect other saved passwords*" feature. Chrome *used to* before they went to protecting it with your Google acco

Re: pgAdmin4 4.8 Kubuntu issues

Hi Richard, I am jumping-in specially because I am the guy to blame for this new feature. I identified the security risks and reported it, so I understand your frustration and feel bad that your work flow is not as comfortable as it was before. I hate when this happens to me. I also think that us

Re: pgAdmin4 4.8 Kubuntu issues

Michel, Thanks for jumping into the conversation. On Wed, Jun 5, 2019 at 12:18 PM Michel Feinstein wrote: > Let me just add some points to the discussion: > > 1 - Your use case is different than most people, you have a VPN in the > middle of your workflow. Besides, you are imaging someone break

Re: pgAdmin4 4.8 Kubuntu issues

Let me just add some points to the discussion: 1 - Your use case is different than most people, you have a VPN in the middle of your workflow. Besides, you are imaging someone breaking into your computer, but the attack vector is much simpler than that. Someone can craft a malware that will autom

Re: pgAdmin4 4.8 Kubuntu issues

Richard, On Wed, Jun 5, 2019 at 4:55 PM richard coleman wrote: > Dave, > > Actually I thought I was being quite restrained in my assessment. With > version 4.8 the developers completely upended the end user experience. > From pgAdmin3 through all versions of pgAdmin4 *prior to the current one*,

Re: pgAdmin4 4.8 Kubuntu issues

Dave, Actually I thought I was being quite restrained in my assessment. With version 4.8 the developers completely upended the end user experience. >From pgAdmin3 through all versions of pgAdmin4 *prior to the current one*, the end user could start pgAdmin and then get to work creating connection

Re: pgAdmin4 4.8 Kubuntu issues

Richard, On Wed, Jun 5, 2019 at 3:22 PM richard coleman wrote: > Dave, > > And where would *that* be? pgAdmin4 the executable and the shared > library is located in /usr/bin/. There are *no* entries in /etc/ for > pgAdmin4. There is a pgadmin4.db in /home/u/.pgadmin/ but *no* config > files

Re: [EXTERNAL] - Re: pgAdmin IV

I've rejected that I'm afraid, with the note: = Bug 2880 refers to what happens if you execute "EXPLAIN SELECT..." as the query, and that still works fine. We use JSON output when you use the EXPLAIN *button*, because we need to parse the output to render it in the graphical viewer. Whilst it

Re: [EXTERNAL] - Re: pgAdmin IV

Issue #4327 created. On Wed, Jun 5, 2019 at 12:27 AM Aditya Toshniwal < aditya.toshni...@enterprisedb.com> wrote: > Hi Michelle, > > On Wed, Jun 5, 2019 at 12:42 AM Michelle Schwan > wrote: > >> Aditya, >> >> >> >> That is not very intuitive! Why can

Re: pgAdmin4 4.8 Kubuntu issues

On Wed, Jun 5, 2019 at 2:44 PM richard coleman wrote: > Dave, > > Sorry, but after an e*xhaustive* search of the several terabytes on my > machine, there is *no* config_local.py file. Do you have any idea where > it's supposed to be located? > You need to create it if it doesn't exist, in the s

Re: pgAdmin4 4.8 Kubuntu issues

File location (assuming you have python 3.5) is "lib/python3.5/site-packages/pgadmin4/config_local.py" relative to the pgadmin install directory. You may have to create it as the file is optional. You use it when you need to override default configuration. I like to keep pgadmin 4 configuration sep

Re: pgAdmin4 4.8 Kubuntu issues

Dave, Sorry, but after an e*xhaustive* search of the several terabytes on my machine, there is *no* config_local.py file. Do you have any idea where it's supposed to be located? Thanks, rik. On Wed, Jun 5, 2019 at 9:30 AM Dave Page wrote: > > > On Wed, Jun 5, 2019 at 1:16 PM richard coleman

Re: [EXTERNAL] - Re: pgAdmin4 4.8 Kubuntu issues

On Wed, Jun 5, 2019 at 1:26 PM Michelle Schwan wrote: > It’s not just on Kubuntu – it also occurs on Windows as well. > > > > There should be a user-friendly way to turn that off. > No there shouldn't, unless you like security problems, as I explained in my earlier email on the topic. > > > pg

Re: pgAdmin4 4.8 Kubuntu issues

On Wed, Jun 5, 2019 at 1:16 PM richard coleman wrote: > Cherio, > > I am sorry to inform you, but there is *no* mention of "config_local.py" > on that page, nor any indication of where I would find it. > https://www.pgadmin.org/docs/pgadmin4/4.x/desktop_deployment.html#configuration > > rik. >

RE: [EXTERNAL] - Re: pgAdmin4 4.8 Kubuntu issues

It’s not just on Kubuntu – it also occurs on Windows as well. There should be a user-friendly way to turn that off. pgAdmin III seems a lot better for functionality and usability. From: richard coleman Sent: Wednesday, June 05, 2019 8:17 AM To: Cherio Cc: pgAdmin Support Subject: [EXTERNAL]

Re: pgAdmin4 4.8 Kubuntu issues

Cherio, I am sorry to inform you, but there is *no* mention of "config_local.py" on that page, nor any indication of where I would find it. rik. On Tue, Jun 4, 2019 at 5:06 PM Cherio wrote: > Put "MASTER_PASSWORD_REQUIRED = False" line into your > "lib/python?.?/site-packages/pgadmin4/config_l

Re: pgAdmin4 4.8 Kubuntu issues

Christoph, pgAdmin4 updated itself this morning, and now the "?" on the Set Master Password dialog returns an actual page, not a 404. Unfortunately it isn't all that clear. It suggests; "You can disable the master password by setting the configuration parameter MASTER_PASSWORD_REQUIRED=False"

Re: pgAdmin4 4.8 Kubuntu issues

Re: Dave Page 2019-06-05 > > Second: When I click the "?" button on that dialog box it takes me to this > > page: > > "http://127.0.0.1:33681/help/help/master_password.html"; > > Which returns "404 Not Found" > > > > That sounds like an issue with the packaging - that file is certainly there > i

Re: Enter master password

Hi Christoph, We have a RM for that - https://redmine.postgresql.org/issues/4310 and the fix is underway. Should be available in next release. On Wed, Jun 5, 2019 at 2:42 PM Christoph Berg wrote: > Hi, > > in the master password entry popup, it would be awesome if I could > simply hit Enter to

Enter master password

Hi, in the master password entry popup, it would be awesome if I could simply hit Enter to confirm. Christoph

Re: 4.8 docs build error

Re: Dave Page 2019-06-05 > This just works around the problem, and will result in incomplete docs. The > correct solution is to ensure that you have the application dependencies > installed in the environment in which you build the docs (it's actually a > subset of them - you probably just need t

Re: pgAdmin IV

Hi On Tue, Jun 4, 2019 at 3:28 PM Michelle Schwan wrote: > From version pgAdmin IV 4.6 and up, I am now receiving the following error > message when I import a database into PostgreSQL. > > > > The database loads fine, but the error that public already exists seems > strange. Public is the defa

Re: pgAdmin4 4.8 Kubuntu issues

On Tue, Jun 4, 2019 at 9:41 PM richard coleman wrote: > Second: When I click the "?" button on that dialog box it takes me to this > page: > "http://127.0.0.1:33681/help/help/master_password.html"; > Which returns "404 Not Found" > That sounds like an issue with the packaging - that file is cert

Re: pgAdmin4 4.8 Kubuntu issues

Hi On Tue, Jun 4, 2019 at 10:54 PM Michel Feinstein wrote: > It would be easier if the system when prompting for the Master Password, > had a "I don't want to define a Master Password" or something like that, > which would set that config_local.py property automatically. > We very intentionally

Re: 4.8 docs build error

Hi On Tue, Jun 4, 2019 at 2:11 PM Christoph Berg wrote: > Re: To pgAdmin III support 2019-06-04 <20190604124400.ga4...@msg.df7cb.de> > > The problem is in docs/en_US/build_code_snippet.py: > This just works around the problem, and will result in incomplete docs. The correct solution is to ensur