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

[Cherio]

On the one hand angry emails like the one that started this thread reveal
how many of users don't realize they should be thankful and appreciative
they are given a free product to use. I personally was repelled by the
tone, but that's beyond the point.

On the other hand this specific question was raised  several times here
before.

In my mind it may not be a big lift to create a small [re]configuration
shell/python script that would take care of the most common settings like
this one. A simple command line "wizard" that simply asks to [re]define the
initial or existing configuration. This way the developers don't need to
worry about compromised security. I foresee variables like those below
(just a suggestion) to be a subject of such configuration script.

DATA_DIR
LOG_FILE
SQLITE_PATH
SESSION_DB_PATH
STORAGE_DIR
PGADMIN_INT_PORT
DEFAULT_SERVER_PORT
SERVER_MODE
MASTER_PASSWORD_REQUIRED


On Sun, Feb 28, 2021 at 6:08 PM richard coleman 
wrote:

> [ HOW TO DISABLE MASTER PASSWORD feature in pgAdmin4 ]
>
> Vladimir,
>
> I sympathize with you.  I have had some extensive discussions with the
> head developer, unfortunately it doesn't seem to be something that he is
> willing to address.  It's built to address a *remote* threat vector, one
> that the vast majority of users would not be susceptible to, nor would they
> agree that the minimal additional security provided warrants the lost time
> and inconvenience that having it entails.  Since he believes so strongly in
> this, it is set to a default of being on and not only is the setting *not*
> exposed in the configuration UI, but it makes use of a non-existent file in
> a location that typically only administrators have access to.  Since many
> (most) users who will be using this in desktop mode already have these
> permissions, all it does is force them to either; use a stupidly simple
> master password (a single space is sufficient), or research the
> byzantine instructions to create a config_local.py file with the magic
> line; "MASTER_PASSWORD_REQUIRED=False" .  It doesn't help that the official
> documentation located here
> https://www.pgadmin.org/docs/pgadmin4/5.0/config_py.html, gives a
> location for config_system.py.  It usually doesn't exist and more
> importantly is **not** the location where the config.py, config_distro.py,
> or the all important config_local.py (that you need to create to disable
> the MASTER PASSWORD feature) resides.  Of course, upgrading from pgAdmin4
> 4.x to pgAdmin4 5.0 re-enables the MASTER PASSWORD feature (⋋▂⋌).
>
> So, until the devs either; add the option to control the MASTER PASSWORD
> feature into the config UI where it belongs, or change things, here are the
> steps to disable it.
>
>1. Make sure pgAdmin4 is not running (if you are using pre-version 5,
>make sure it isn't running in the tray)
>2. Locate the pgadmin4 *config.py* file (it will be in a *web*
>sub-directory parallel to the directory containing the executable)
>3. Create a file named *config_local.py* in the same directory as the
>config.py file (you will probably need admin or equivalent permissions)
>4. Enter the line: MASTER_PASSWORD_REQUIRED=False into that file and
>save
>5. Start pgAdmin4 and enjoy your MASTER PASSWORD free life
>
> I hope that helps anyone else still struggling with this.
>
> rik.
>
> On Sun, Feb 28, 2021 at 5:47 AM Vladimir Nicolici 
> wrote:
>
>> Apparently, some parts of the message were lost when posting it through
>> postgresql-archive.org, so I attached a PDF version of my previous
>> message which includes the missing sections. Sorry about that.
>>
>>
>>
>> Sent from Mail  for
>> Windows 10
>>
>

Re: Query issue

[Aditya Toshniwal]

Hi Sachin,

As Ray mentioned, \d does not work with the query tool. Reason begin, \d is
psql utility and not a standard PostgresQL clause.
In pgAdmin, you can click on the table and go to the "SQL" tab for the DDL.

On Sat, Feb 27, 2021 at 7:19 PM Ray O'Donnell  wrote:

> On 27/02/2021 13:32, Sachin Kumar wrote:
> > Hi Team,
> >
> > Please help me out in running DESCRIBE TABLE in pgadmin 5.0,  which is
> > being used in psql with \d 
>
> I don't think you can run the backslash-commands in the query window in
> pgAdmin. Instead, just click on a table and look at the information
> given in the various tabs - all the data returned by \d (and lots more)
> is there.
>
> Ray.
>
> --
> Raymond O'Donnell // Galway // Ireland
> r...@rodonnell.ie
>
>
>

-- 
Thanks,
Aditya Toshniwal
pgAdmin hacker | Sr. Software Engineer | *edbpostgres.com*

"Don't Complain about Heat, Plant a TREE"

Re: Please HELP me! - pgAdmin 4 v4.x on macOS BigSuk

[Edson Richter]

"but it makes me feel so cool like I can be somebody."

Yes, I feel that way everytime I install a rack server with Linux-based OS and 
start pgAdmin in Docker container and turn all developers of my team able to 
run pgAdmin in their browsers with zero install on their machines.

Just my 2c...



Edson Richter
Soli Deo Gloria


Em 28 de fev de 2021, em 07:11, May Kue 
mailto:may@gmail.com>> escreveu:
Hello!

Thank you all so much! I was able to download the latest 5.0 version and got it 
to work. The download from EDB install for PostgreSQL 13.2 has the pgAdmin 4.3 
version in the package. It connected to all the Postgres servers after testing. 
Unfortunately, after running around like a chicken with no head for a few days, 
my elation was short-lived. SMITED! The other applications I  have to use, 
Tableau 2020.4 and Anaconda, do not support Postgres13.2. The drivers I had to 
install, rendered PostgreSQL and Tableau to just legit quick MacOS.

There are a few things going on with the different apps and versions from 
working with each other but the root cause is basically that Apple/macOS/Big 
Suk still wants to control all the third-vendors access. I am sure they have a 
good reason but for novice users, it is a nightmare because you have to 
configure each app, host, and server to run cohesively. Ironically, each 
app/server keeps overriding one another and rewriting the configuration/network 
files. I am sure it's me, not you...but I am not breaking up with you.  I have 
to go back to Windows now because Apple is a bully and the infighting is a 
nightmare. Don't worry. All SQL apps are dependent on pgAdmin GUI so you'll 
always be in my life. Forever...

I guess my dream to be a hacker (ethical, hello) is a little dim today as I 
have to grovel back to Windows like the rest of the herd. I seriously thought 
about throwing my Mac out the "window" (with gusto! dammit!) but seeing that I 
live on the first floor, it would just not be as satisfying. I'll still go back 
to the Mac because she's pretty but complicated...also expensive. Yeah, I do 
sometimes feel shallow with the Mac but it makes me feel so cool like I can be 
somebody...ya know? Besides, I'll have to go and pick up the mess I've made. I 
still want my lovely neighbors to like me and check up on me in case I catch 
"The Covid"... or a zombie apocalypse. They can all really cook...anyway, no 
one wants to be the crazy person on the block.

Thank you for all your help! If I can ever be of service, please let me know. I 
sincerely and greatly appreciate getting through the moderator and all of your 
help. Until we meet again, may the force be with you my dear friends!

Oh, and Darren, the class only supports Windows so Mac users are on their 
own...even though this is a Data Analyst/Science program...I don't know, 
it...it's complicated. Maybe because of Tableau? It keeps me up at night 
thinking about it toolike, why? But for now, I'll go with Mac is unstable 
and paranoid...? If I ever find the answer, you'll be the first to know.

Forever a newbie (and I am OK with that),
Kue



On Fri, Feb 26, 2021 at 4:47 AM Dave Page < 
dp...@pgadmin.org> wrote:


On Fri, Feb 26, 2021 at 9:45 AM Darren Duncan < 
dar...@darrenduncan.net> wrote:
On 2021-02-25 2:56 p.m., May Kue wrote:
> I am a student and have been trying to install pgAdmin for two weeks now on
> a MacOs BigSur (for personal reasons why I am using a Mac...I am an idiot and
> will conquer this dammit!). My other classmates with Macs just went back to
> Windows and have to buy new laptops - which is crazy. I am crazier by trying 
> to
> get it to work.

Can you explain this?  Why would your Mac-using classmates suddenly switch to
Windows en-masse?  What would that accomplish? -- Darren Duncan

I was assuming that was somewhat tongue-in-cheek.


--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EDB: http://www.enterprisedb.com

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

[richard coleman]

[ HOW TO DISABLE MASTER PASSWORD feature in pgAdmin4 ]

Vladimir,

I sympathize with you.  I have had some extensive discussions with the head
developer, unfortunately it doesn't seem to be something that he is willing
to address.  It's built to address a *remote* threat vector, one that the
vast majority of users would not be susceptible to, nor would they agree
that the minimal additional security provided warrants the lost time and
inconvenience that having it entails.  Since he believes so strongly in
this, it is set to a default of being on and not only is the setting *not*
exposed in the configuration UI, but it makes use of a non-existent file in
a location that typically only administrators have access to.  Since many
(most) users who will be using this in desktop mode already have these
permissions, all it does is force them to either; use a stupidly simple
master password (a single space is sufficient), or research the
byzantine instructions to create a config_local.py file with the magic
line; "MASTER_PASSWORD_REQUIRED=False" .  It doesn't help that the official
documentation located here
https://www.pgadmin.org/docs/pgadmin4/5.0/config_py.html, gives a location
for config_system.py.  It usually doesn't exist and more importantly is
**not** the location where the config.py, config_distro.py, or the all
important config_local.py (that you need to create to disable the MASTER
PASSWORD feature) resides.  Of course, upgrading from pgAdmin4 4.x to
pgAdmin4 5.0 re-enables the MASTER PASSWORD feature (⋋▂⋌).

So, until the devs either; add the option to control the MASTER PASSWORD
feature into the config UI where it belongs, or change things, here are the
steps to disable it.

   1. Make sure pgAdmin4 is not running (if you are using pre-version 5,
   make sure it isn't running in the tray)
   2. Locate the pgadmin4 *config.py* file (it will be in a *web*
   sub-directory parallel to the directory containing the executable)
   3. Create a file named *config_local.py* in the same directory as the
   config.py file (you will probably need admin or equivalent permissions)
   4. Enter the line: MASTER_PASSWORD_REQUIRED=False into that file and save
   5. Start pgAdmin4 and enjoy your MASTER PASSWORD free life

I hope that helps anyone else still struggling with this.

rik.

On Sun, Feb 28, 2021 at 5:47 AM Vladimir Nicolici  wrote:

> Apparently, some parts of the message were lost when posting it through
> postgresql-archive.org, so I attached a PDF version of my previous
> message which includes the missing sections. Sorry about that.
>
>
>
> Sent from Mail  for
> Windows 10
>

Re: Please HELP me! - pgAdmin 4 v4.x on macOS BigSuk

[May Kue]

Hello!

Thank you all so much! I was able to download the latest 5.0 version and
got it to work. The download from EDB install for PostgreSQL 13.2 has the
pgAdmin 4.3 version in the package. It connected to all the Postgres
servers after testing. Unfortunately, after running around like a chicken
with no head for a few days, my elation was short-lived. SMITED! The other
applications I  have to use, Tableau 2020.4 and Anaconda, do not support
Postgres13.2. The drivers I had to install, rendered PostgreSQL and Tableau
to just legit quick MacOS.

There are a few things going on with the different apps and versions from
working with each other but the root cause is basically that
Apple/macOS/Big Suk still wants to control all the third-vendors access. I
am sure they have a good reason but for novice users, it is a nightmare
because you have to configure each app, host, and server to run cohesively.
Ironically, each app/server keeps overriding one another and rewriting
the configuration/network files. I am sure it's me, not you...but I am not
breaking up with you.  I have to go back to Windows now because Apple is
a bully and the infighting is a nightmare. Don't worry. All SQL apps are
dependent on pgAdmin GUI so you'll always be in my life. Forever...

I guess my dream to be a hacker (ethical, hello) is a little dim today as I
have to grovel back to Windows like the rest of the herd. I seriously
thought about throwing my Mac out the "window" (with gusto! dammit!) but
seeing that I live on the first floor, it would just not be as satisfying.
I'll still go back to the Mac because she's pretty but complicated...also
expensive. Yeah, I do sometimes feel shallow with the Mac but it makes me
feel so cool like I can be somebody...ya know? Besides, I'll have to go and
pick up the mess I've made. I still want my lovely neighbors to like me and
check up on me in case I catch "The Covid"... or a zombie apocalypse. They
can all really cook...anyway, no one wants to be the crazy person on the
block.

Thank you for all your help! If I can ever be of service, please let me
know. I sincerely and greatly appreciate getting through the moderator and
all of your help. Until we meet again, may the force be with you my dear
friends!

Oh, and Darren, the class only supports Windows so Mac users are on their
own...even though this is a Data Analyst/Science program...I don't know,
it...it's complicated. Maybe because of Tableau? It keeps me up at night
thinking about it toolike, why? But for now, I'll go with Mac is
unstable and paranoid...? If I ever find the answer, you'll be the first to
know.

Forever a newbie (and I am OK with that),
Kue



On Fri, Feb 26, 2021 at 4:47 AM Dave Page  wrote:

>
>
> On Fri, Feb 26, 2021 at 9:45 AM Darren Duncan 
> wrote:
>
>> On 2021-02-25 2:56 p.m., May Kue wrote:
>> > I am a student and have been trying to install pgAdmin for two weeks
>> now on
>> > a MacOs BigSur (for personal reasons why I am using a Mac...I am an
>> idiot and
>> > will conquer this dammit!). My other classmates with Macs just went
>> back to
>> > Windows and have to buy new laptops - which is crazy. I am crazier by
>> trying to
>> > get it to work.
>>
>> Can you explain this?  Why would your Mac-using classmates suddenly
>> switch to
>> Windows en-masse?  What would that accomplish? -- Darren Duncan
>>
>
> I was assuming that was somewhat tongue-in-cheek.
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EDB: http://www.enterprisedb.com
>
>