Request help for installation

[Renata Halim]

Hi,

My name is renata and I'm a student in one of the university in Indonesia.
Right now I'm doing my final project to get my degree. My subject is about
making database for a company and right now I'm using postgreSQL but I'm
facing a hard time to install it. Can you help me with this issue? The
point is I can't set the passowrd for my database.
I'm looking forward to your reply.

Thank you.

Re: Request help for installation

[Ray O'Donnell]

On 09/07/2019 05:39, Renata Halim wrote:

Hi,

My name is renata and I'm a student in one of the university in 
Indonesia. Right now I'm doing my final project to get my degree. My 
subject is about making database for a company and right now I'm using 
postgreSQL but I'm facing a hard time to install it. Can you help me 
with this issue? The point is I can't set the passowrd for my database.

I'm looking forward to your reply.


Hi there,

This list is for pgAdmin, which is a management tool for PostgreSQL - 
you probably want the pgsql-general mailing list which is for PostgreSQL 
itself.


Useful information to include with your post:

- What platform? - Linux, Windows, etc?

- How did you try to install? - OS package manager, build from source?

- What have you tried so far, and what error or other messages did you get?

Ray.

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

Re: Request help for installation

[Ashesh Vashi]

Hi Renata,

This is not the correct mailing list. This is dedicated mailing list for
the pgAdmin 4.
Please share your concerns on pgsql-gene...@postgresql.org.

You may want to give more details about:
- What version of operating system?
- How did you install the postgresql?
- What is the exact issue in detail?
- Please share error message (if you're getting any).

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company



*http://www.linkedin.com/in/asheshvashi*



On Tue, Jul 9, 2019 at 6:58 PM Renata Halim  wrote:

> Hi,
>
> My name is renata and I'm a student in one of the university in Indonesia.
> Right now I'm doing my final project to get my degree. My subject is about
> making database for a company and right now I'm using postgreSQL but I'm
> facing a hard time to install it. Can you help me with this issue? The
> point is I can't set the passowrd for my database.
> I'm looking forward to your reply.
>
> Thank you.
>

How do I remove this stupid "master password"?

[tutiluren]

Not long ago, I updated pgAdmin 4 as I did every time a new version was 
available (because it wouldn't stop pestering me about it), even though this 
was a massive chore and not automated in any way. Anyway, with some recent 
version, it started popping up this obnoxious, pointless "master password" 
idiocy, every single time I tried to click or load anything. It just wouldn't 
shut up about it. I tried setting an empty password, but of course it wouldn't 
even accept that.

Eventually, after wasting countless hours on trying to find out how to disable 
this unwanted "feature", realizing that there was no way to do so (the supposed 
instructions were incomplete/nonsensical), I was forced to downgrade to the 
last version. From that point on, I stopped running my script which checks for 
new versions of pgAdmin 4 and downloads them for me (to save some time and 
energy every time it wants to update).

The other day, I decided that my pgAdmin is getting too old, and hopefully they 
will have removed this stupidity by now. Alas, I found that it was still there, 
but I think it looked different this time. I'm not sure. Either way, furious 
that it wouldn't go away (this kind of thing is just as bad as, if not *worse* 
than, ads), I made a single space the "master password".

Now, I'm forced to waste my time, energy and focus every single time I need to 
admin my databases by needlessly inputting a single space and click a button 
before it lets me in. And no, it doesn't remember this because I clear all 
browser data many times a day (out of necessity). It really does "add up" and 
makes me despise the software and look at it at a chore rather than something 
useful. I thought it was already bad enough that it requires a browser and has 
a "warmup time" (the first time each time the computer boots)...

How do I turn this off? How do I make it never appear ever again? How do I 
disable it? I have no idea who thought that this was a good idea, but I 
strongly suspect that nobody did, and it was just added to piss people off. 
I've dealt with enough "bizarre" decisions made by software authors to still 
believe that they don't know what they're doing. They know. If they use the 
software themselves, they know. This has literally *no* practical purpose that 
I can think of, and wasn't even explained. It just appeared randomly one day 
with an update. "Here's some random unwanted change for the worse. Deal with 
it, user." ... you'd almost think that Microsoft had a finger in the 
development of this program.

If there is some sort of edge-case scenario where this actually makes sense (I 
cannot think of any, and I have excellent imagination...), why not make this 
OPTIONAL? Why put it there BY DEFAULT, and why FORCE us to pick a "master 
password" even if we have no need for it and it's nothing but unwanted 
stupidity that makes us hate the authors of the software and swear to never, 
ever donate or help out the project in any way? Why turn your users into 
enemies?

PS: Man, I long back to the days when pgAdmin III still worked and was 
maintained. It got so bad in the end that I had to click away countless error 
boxes before I could do anything in it...

PS 2: This stuff about requiring people to create an account and submit all our 
data to Google to send e-mails to this list is just insanity. What is wrong 
with you people?! You apparently have done anything to shield yourselves from 
people contacting you. This lengthy, 48-step process of actually getting to 
send this damn e-mail is incredibly tiresome and insulting...

Re: How do I remove this stupid "master password"?

[richard coleman]

tutiluren,

I feel your pain.  Here's the *short* answer I passed along to someone
else.  There's a *much* longer discussion between myself and the dev that
thought this was a good idea that I can share if you are ever interested.

rik.

---
Welcome to the nanny state that pgAdmin4 has become.

There is a way to disable this feature. You need to add this string to a
config.py, config_distro.py, or config_local.py;
MASTER_PASSWORD_REQUIRED=False

Other than config.py, the other files, may or may not exist, so you'll have
to create at least one of them, if you want to use it.

The help page is here:
https://www.pgadmin.org/docs/pgadmin4/dev/master_password.html

Here's another link were people are looking for how to disable it.
https://askubuntu.com/questions/1150778/pgadmin4-disable-master-password

If you've accidentally enabled it, it may scramble all of your saved
passwords, so you'll have to enter them again.  At least you won't have to
keep entering the MASTER PASSWORD though.

Good luck,


On Tue, Jul 9, 2019 at 1:21 PM  wrote:

> Not long ago, I updated pgAdmin 4 as I did every time a new version was
> available (because it wouldn't stop pestering me about it), even though
> this was a massive chore and not automated in any way. Anyway, with some
> recent version, it started popping up this obnoxious, pointless "master
> password" idiocy, every single time I tried to click or load anything. It
> just wouldn't shut up about it. I tried setting an empty password, but of
> course it wouldn't even accept that.
>
> Eventually, after wasting countless hours on trying to find out how to
> disable this unwanted "feature", realizing that there was no way to do so
> (the supposed instructions were incomplete/nonsensical), I was forced to
> downgrade to the last version. From that point on, I stopped running my
> script which checks for new versions of pgAdmin 4 and downloads them for me
> (to save some time and energy every time it wants to update).
>
> The other day, I decided that my pgAdmin is getting too old, and hopefully
> they will have removed this stupidity by now. Alas, I found that it was
> still there, but I think it looked different this time. I'm not sure.
> Either way, furious that it wouldn't go away (this kind of thing is just as
> bad as, if not *worse* than, ads), I made a single space the "master
> password".
>
> Now, I'm forced to waste my time, energy and focus every single time I
> need to admin my databases by needlessly inputting a single space and click
> a button before it lets me in. And no, it doesn't remember this because I
> clear all browser data many times a day (out of necessity). It really does
> "add up" and makes me despise the software and look at it at a chore rather
> than something useful. I thought it was already bad enough that it requires
> a browser and has a "warmup time" (the first time each time the computer
> boots)...
>
> How do I turn this off? How do I make it never appear ever again? How do I
> disable it? I have no idea who thought that this was a good idea, but I
> strongly suspect that nobody did, and it was just added to piss people off.
> I've dealt with enough "bizarre" decisions made by software authors to
> still believe that they don't know what they're doing. They know. If they
> use the software themselves, they know. This has literally *no* practical
> purpose that I can think of, and wasn't even explained. It just appeared
> randomly one day with an update. "Here's some random unwanted change for
> the worse. Deal with it, user." ... you'd almost think that Microsoft had a
> finger in the development of this program.
>
> If there is some sort of edge-case scenario where this actually makes
> sense (I cannot think of any, and I have excellent imagination...), why not
> make this OPTIONAL? Why put it there BY DEFAULT, and why FORCE us to pick a
> "master password" even if we have no need for it and it's nothing but
> unwanted stupidity that makes us hate the authors of the software and swear
> to never, ever donate or help out the project in any way? Why turn your
> users into enemies?
>
> PS: Man, I long back to the days when pgAdmin III still worked and was
> maintained. It got so bad in the end that I had to click away countless
> error boxes before I could do anything in it...
>
> PS 2: This stuff about requiring people to create an account and submit
> all our data to Google to send e-mails to this list is just insanity. What
> is wrong with you people?! You apparently have done anything to shield
> yourselves from people contacting you. This lengthy, 48-step process of
> actually getting to send this damn e-mail is incredibly tiresome and
> insulting...
>

Re: How do I remove this stupid "master password"?

[Michel Feinstein]

Hi tutiluren,

I understand your frustration and I am sorry about how you feel. I am not
the developer who implemented this, but I am the guy who reported the
security vulnerability this addresses.

If you look into some past messages you will understand the issue and what
was behind the decisions by the devs. In a nutshell, it prevents malware
(either in the browser itself or in your machine, or a junior dev machine
and etc.) to scan for postgresql credentials and send them to an attacker.
It can be more then that so I advise you to read the thread if you are
further interested.

Again, I am sorry about how you feel, but this decision was definitely not
taken without a lot of thought and not by any Microsoft employees that I
know of :)

Best wishes,

Michel.


On Tue, Jul 9, 2019, 14:21  wrote:

> Not long ago, I updated pgAdmin 4 as I did every time a new version was
> available (because it wouldn't stop pestering me about it), even though
> this was a massive chore and not automated in any way. Anyway, with some
> recent version, it started popping up this obnoxious, pointless "master
> password" idiocy, every single time I tried to click or load anything. It
> just wouldn't shut up about it. I tried setting an empty password, but of
> course it wouldn't even accept that.
>
> Eventually, after wasting countless hours on trying to find out how to
> disable this unwanted "feature", realizing that there was no way to do so
> (the supposed instructions were incomplete/nonsensical), I was forced to
> downgrade to the last version. From that point on, I stopped running my
> script which checks for new versions of pgAdmin 4 and downloads them for me
> (to save some time and energy every time it wants to update).
>
> The other day, I decided that my pgAdmin is getting too old, and hopefully
> they will have removed this stupidity by now. Alas, I found that it was
> still there, but I think it looked different this time. I'm not sure.
> Either way, furious that it wouldn't go away (this kind of thing is just as
> bad as, if not *worse* than, ads), I made a single space the "master
> password".
>
> Now, I'm forced to waste my time, energy and focus every single time I
> need to admin my databases by needlessly inputting a single space and click
> a button before it lets me in. And no, it doesn't remember this because I
> clear all browser data many times a day (out of necessity). It really does
> "add up" and makes me despise the software and look at it at a chore rather
> than something useful. I thought it was already bad enough that it requires
> a browser and has a "warmup time" (the first time each time the computer
> boots)...
>
> How do I turn this off? How do I make it never appear ever again? How do I
> disable it? I have no idea who thought that this was a good idea, but I
> strongly suspect that nobody did, and it was just added to piss people off.
> I've dealt with enough "bizarre" decisions made by software authors to
> still believe that they don't know what they're doing. They know. If they
> use the software themselves, they know. This has literally *no* practical
> purpose that I can think of, and wasn't even explained. It just appeared
> randomly one day with an update. "Here's some random unwanted change for
> the worse. Deal with it, user." ... you'd almost think that Microsoft had a
> finger in the development of this program.
>
> If there is some sort of edge-case scenario where this actually makes
> sense (I cannot think of any, and I have excellent imagination...), why not
> make this OPTIONAL? Why put it there BY DEFAULT, and why FORCE us to pick a
> "master password" even if we have no need for it and it's nothing but
> unwanted stupidity that makes us hate the authors of the software and swear
> to never, ever donate or help out the project in any way? Why turn your
> users into enemies?
>
> PS: Man, I long back to the days when pgAdmin III still worked and was
> maintained. It got so bad in the end that I had to click away countless
> error boxes before I could do anything in it...
>
> PS 2: This stuff about requiring people to create an account and submit
> all our data to Google to send e-mails to this list is just insanity. What
> is wrong with you people?! You apparently have done anything to shield
> yourselves from people contacting you. This lengthy, 48-step process of
> actually getting to send this damn e-mail is incredibly tiresome and
> insulting...
>

Strange "empty dialog" in workspace

[Edson Richter]

PgAdmin 4.10 on Windows 2008r2 64 bit. User access server using RDS.

One developer, which uses pgAdmin to create/alter/delete tables in development 
database, now has a strange “empty dialog” in his workspace.
All other developers are working normally.
There is no title, no content, just a White ghost dialog box:

Attached there is the screen shot showing the problem.

I would appreciate your guidance.

Atenciosamente,

Edson Richter



Soli Deo Gloria.

Re: Strange "empty dialog" in workspace

[Khushboo Vashi]

Hi Edson,

On Wed, Jul 10, 2019 at 12:33 AM Edson Richter 
wrote:

> PgAdmin 4.10 on Windows 2008r2 64 bit. User access server using RDS.
>
>
>
> One developer, which uses pgAdmin to create/alter/delete tables in
> development database, now has a strange “empty dialog” in his workspace.
>
> All other developers are working normally.
>
> There is no title, no content, just a White ghost dialog box:
>
>
>
We have not seen this type of issue, still, you can try below steps:
- Clear the browser cache
- Restart the server
- Reset the layout via File > Reset Layout menu.

After following the above steps, if the issue still persists, then please
send the browser console errors if any and provide the pgAdmin logs. To
enable the logging, please refer https://www.pgadmin.org/faq/#8

Thanks,
Khushboo

> Attached there is the screen shot showing the problem.
>
>
>
> I would appreciate your guidance.
>
>
>
> Atenciosamente,
>
>
>
> Edson Richter
>
>
>
>
>
>
>
> Soli Deo Gloria.
>
>
>