Hi,
I am new to pgAdmin and PostgreSQL. I am configuring a new server
connection and I can see there's an option to save my server's password.
How secure is this option? Does it save my password as plaintext or does it
save inside Windows protection or other form of encryption?
Best wishes,
Mic
Wed, Apr 17, 2019 at 7:20 AM Michel Feinstein <
> michelfeinst...@gmail.com> wrote:
>
>> Hi,
>>
>> I am new to pgAdmin and PostgreSQL. I am configuring a new server
>> connection and I can see there's an option to save my server's password.
>&
I can't find a way to create an Expression Index such as:
CREATE UNIQUE INDEX idx_lower_unique
ON your_table (lower(the_column));
Am I missing something or does pgAdmin really doesn't support it?
Best wishes,
Michel.
I will...but just to add my 2 cents, it would be a lot better if you guys
could move to Github and use their Issue system instead.
On Wed, May 15, 2019 at 1:43 AM Aditya Toshniwal <
aditya.toshni...@enterprisedb.com> wrote:
> Hi,
>
> On Wed, May 15, 2019 at 7:46 AM M
gt;
>>
>> On Wed, May 15, 2019 at 1:43 AM Aditya Toshniwal <
>> aditya.toshni...@enterprisedb.com> wrote:
>>
>>> Hi,
>>>
>>> On Wed, May 15, 2019 at 7:46 AM Michel Feinstein <
>>> michelfeinst...@gmail.com> wrote:
>>&g
Yes, this doesn't affect me, but it just seems to be the wrong workflow,
but if you guys don't get annoyed about it, then it's fine I guess.
On Wed, May 15, 2019, 09:27 Dave Page wrote:
>
>
> On Wed, May 15, 2019 at 1:01 PM Michel Feinstein <
> michelfeinst...@gmai
Well, Github is a private company, but the vast majority of open-source
projects are there now, Microsoft owns it and made a statement about it...
I can't imagine this changing, it would be a huge PR nightmare for
Microsoft.
I am used to have Stackoverflow for questions and Github for issues, but
Hi guys, I am looking for opinions on how you use pgAdmin for dealing with
several accounts.
For example, I have an "admin" account with all the privileges for the
database and a "restricted" account for my application to use. I also have
some other accounts for other purposes and I was looking fo
gt;
> *Doug Easterbrook*
> *Arts Management Systems Ltd.*
> mailto:d...@artsman.com
> http://www.artsman.com
> Phone (403) 650-1978
>
> On May 18, 2019, at 3:19 PM, Michael Shapiro wrote:
>
> I'd like to know how people do this as well. I have been creating new
> Se
Sorry but the only thing I can help is about the .asc file. It's used for
verify that the .exe you downloaded is the original one, that no one
modified it, injected some malware or something like it.
It's a digital signature used in PGP. You can search more about it online
looking for PGP or GPG.
> users and roles CAN cross multiple databases.
> >
> > if you really want segmentation between development and production,
> creating
> > two different servers might be best.
> >
> >
> >
> > Doug Easterbrook
> > Arts Management Systems Ltd.
>
Hi,
In a previous email I suggested the use of a master password. Now I can see
at the pgAdmin 4.7 release notes that it was shipped, so I went to the
issue page (#4184), but I can't find it in the issue list, and I get a 403
error on the issue's link.
I wanted to see the implementation and since
Ok, thanks for the clarification.
On Wed, May 29, 2019, 11:46 Dave Page wrote:
>
>
> On Wed, May 29, 2019 at 5:57 AM Michel Feinstein <
> michelfeinst...@gmail.com> wrote:
>
>> Hi,
>>
>> In a previous email I suggested the use of a master password. Now
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.
On Tue, Jun 4, 2019, 18:06 Cherio wrote:
> Put "MASTER_PASSWORD_REQUIRED = False" line in
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
y if my input wasn't very helpful on your use case.
Michel.
On Wed, Jun 5, 2019, 14:03 richard coleman
wrote:
> Michel,
>
> Thanks for jumping into the conversation.
>
> On Wed, Jun 5, 2019 at 12:18 PM Michel Feinstein <
> michelfeinst...@gmail.com> wrote:
>
>&
*(if the malicious actor can steal the file they can also read the key from
memory)*
As far as I know it's a lot easier for a program to get access to all the
files in a system (specially on Windows) than to dump the memory, as there
are memory barriers protected by the OS (and address randomizati
hel,
>
> On Thu, Jun 6, 2019 at 9:15 AM Michel Feinstein
> wrote:
>
>> *(if the malicious actor can steal the file they can also read the key
>> from memory)*
>>
>> As far as I know it's a lot easier for a program to get access to all the
>> files in a sys
Look for it in the system tray bar, at the lower right corner of the
screen, right click it and see the option to exit.
On Thu, Jun 27, 2019, 10:42 George Weaver wrote:
> Good morning,
>
> I would like to know how to "really" close pgAdmin4.
>
> When I close the pgAdmin4 tab or the browser suppo
[image: image.png]
The last one at the bottom, I am still at pgAdmin 4.6 though.
On Thu, Jun 27, 2019 at 10:58 AM Michelle Schwan
wrote:
> Could you show a screen shot of that? I cannot find the option to exit.
>
>
>
> *From:* Michel Feinstein
> *Sent:* Thursday, June 27,
Google "windows system tray".
On Thu, Jun 27, 2019 at 11:09 AM Michelle Schwan
wrote:
> I do not see that icon at all in pgAdmin. Where is that ?
>
>
>
>
>
> *From:* richard coleman
> *Sent:* Thursday, June 27, 2019 10:07 AM
> *To:* Michelle Schwan
>
>
>
> *From:* Michel Feinstein
> *Sent:* Thursday, June 27, 2019 10:11 AM
> *To:* Michelle Schwan
> *Cc:* richard coleman ; George Weaver <
> gwea...@shaw.ca>; pgAdmin Support
> *Subject:* Re: [EXTERNAL] - Re: How to close pgAdmin4
>
>
>
> Google "wind
My pleasure, I am not a big fan of this either... But many applications
have this behavior, so I am kinda used to it.
On Thu, Jun 27, 2019, 11:34 George Weaver
wrote:
> Hi Michel,
>
> Thanks!
>
> (One more inconvenient thing about pgAdmin4.)
>
> George
> On 27/0
Is it there any reasons for autocomplete not to work? I am trying
Cntrl+Space on Windows 10, pgAdmin 4.6 and it just ignores it completely.
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
In that case I would say you need a "Save as..." button, whereas the "Save"
button will track changes and only save if there are any changes.
On Thu, Jul 18, 2019, 11:42 Michael Shapiro wrote:
> Dave,
>
> I'd like to make a feature request that PgAdmin4 add a save button (that
> is always enable
Avin,
There's a lengthy explanation about the vulnerabilies around the Master
Password, solution, if you can't find it on the list, please let me know.
In a nutshell, a malware downloaded into a machine (or a malicious browser
extension) could search for pgAdmin passwords and steal them.
Many pe
Also, I run Firefox with 4 windows, each one with hundreds of tabs (I have
easily 500+ tabs in total), I don't restart Windows 10 for months and I
don't have any issues here.
On Tue, Jul 30, 2019, 00:03 Avin Kavish wrote:
> Hey Mark,
>
> I find this hard to believe as chrome uses process isolati
I believe Firefox doesn't use one process per tab, but does use
multi-process on its own way.
On Tue, Jul 30, 2019, 00:08 Darren Duncan wrote:
> Yes, every modern browser uses a separate process per browser tab.
> Besides the
> mentioned Firefox and Chrome, Safari also does it. So generally a p
I always have one hand at the mouse and one at the keyboard, once I select
stuff with the mouse, I hit cntrl+c with the other hand, it's a lot
quicker. At least if you don't have any disabilities or are left handed,
ctrl+c is at the bottom right corner, where my left hand already rests.
On Tue, Ju
I think this would be a lot easier, as you are just basically wrapping a
browser with a fixed URL address.
On Fri, Aug 9, 2019, 01:39 Avin Kavish wrote:
> The people who want it don't want a browser window, they want an
> independent standalone application that is not affected by what they might
me sort of secret key
> exchange and context menus.
>
> On Fri, Aug 9, 2019 at 10:13 AM Michel Feinstein <
> michelfeinst...@gmail.com> wrote:
>
>> I think this would be a lot easier, as you are just basically wrapping a
>> browser with a fixed URL address.
&
One thing that helps with readability is intercalating the colors of the
table lines (white, light gray, white, light gray). That would be a
very nice addition.
On Fri, Aug 9, 2019, 09:17 Luther Goh Lu Feng wrote:
>
>
> Thanks for the note. I have created
> https://redmine.postgresql.org/iss
r: #f8f8f8; }
>
> I'm not suggesting that's that's a sensible user work-around, I'm just
> pointing out that that's how simple it would be... just add the above
> line to the .CSS file.
>
> Cheers,
> Dave
>
>
> On Fri, Aug 9, 2019 at 9:39
You can, click the record, not a cell, but the record itself, like a
leftmost click, then click the trash can, than click to save.
On Sun, Aug 11, 2019, 13:19 wrote:
> This is something that always drove me to insanity with the old pgAdmin
> III: that once you had made a SELECT query and got a b
Also, be aware that this is NOT the postgresql email list, but the pgAdmin
email list, you would get a lot more help about SQL there.
On Tue, Sep 3, 2019, 19:44 Jack Royal-Gordon wrote:
> Let me step back a bit, as I realize upon further reflection that the
> first method will not work.
>
> As f
Hi guys,
I am about to take down a database, so I want to make a backup before, in
case I need to turn it on again in the future. Are there any caveats I
should be aware of, when using pgAdmin for the backup?
Thanks in advance.
the pg_dump
> <https://www.postgresql.org/docs/current/app-pgdump.html>
> documentation if you require any specific details on backup process.
>
>
> --
> Regards,
> Murtuza Zabuawala
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
&
The backup docs at:
https://www.pgadmin.org/docs/pgadmin4/4.14/backup_dialog.html
say:
"Move the switch next to *$ quoting* to the* Yes position to enable* dollar
quoting within function bodies; if disabled, the function body will be
quoted using SQL standard string syntax.".
But those are the Di
; On 12-Nov-2019, at 3:29 PM, Dave Page wrote:
>
> Hi Abhilasha,
>
> Can you fix this and check for any related inconsistencies seeing as
> you're already working on the other issue we just discussed?
>
> Thanks!
>
> On Mon, Nov 11, 2019 at 10:54 PM Michel Feinstein <
&g
40 matches
Mail list logo
