Re: pgAdmin commandLine

From: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
To: Saif Manai <manaisaif24(at)gmail(dot)com>
Cc: "pgadmin-support lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>, Ni Ne <nineoften(at)hotmail(dot)com>
Subject: Re: pgAdmin commandLine
Date: 2021-10-26 05:59:27
Message-ID: CAM9w-_=wZWr3tQ42fmyv2mqj8g7jfYCkqr86qJ+oMfdjZSyoqA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Yes you can disable the master password completely. Please refer -
https://www.pgadmin.org/docs/pgadmin4/6.1/master_password.html#master-password

On Tue, Oct 26, 2021 at 11:25 AM Saif Manai <manaisaif24(at)gmail(dot)com> wrote:

> I think the master pass is needed to save servers password. In my case, no
> need to save passwords. Is it possible not to use a master password
>
> Le mar. 26 oct. 2021 à 07:52, Saif Manai <manaisaif24(at)gmail(dot)com> a écrit :
>
>> Yes true.
>> Can I just not use a master password like the other version?
>>
>> Le mar. 26 oct. 2021 à 07:25, Aditya Toshniwal <
>> aditya(dot)toshniwal(at)enterprisedb(dot)com> a écrit :
>>
>>> Hi Saif,
>>>
>>> I think you did not set/enter the master password when it is asked when
>>> pgAdmin opens.
>>>
>>> On Tue, Oct 26, 2021 at 12:06 AM Saif Manai <manaisaif24(at)gmail(dot)com>
>>> wrote:
>>>
>>>> Now, when i open a create server dialog and fill these informations :
>>>> Name, address, port, database, username, password, ssl mode
>>>> After that when i click save i have this error : Crypt key is missing.
>>>> I am using v6.1, the same thing works fine on version 4.3
>>>> Do you know what would be the problem?
>>>> Thank you
>>>>
>>>> Le lun. 25 oct. 2021 à 20:27, Saif Manai <manaisaif24(at)gmail(dot)com> a
>>>> écrit :
>>>>
>>>>> I finally find a solution via keyboard shortcuts.
>>>>> Thank you
>>>>>
>>>>> Le lun. 25 oct. 2021 à 19:15, Saif Manai <manaisaif24(at)gmail(dot)com> a
>>>>> écrit :
>>>>>
>>>>>> This what i'm talking about, can't open server dialog.
>>>>>> Thank you in advance
>>>>>>
>>>>>> Le lun. 25 oct. 2021 à 19:06, Saif Manai <manaisaif24(at)gmail(dot)com> a
>>>>>> écrit :
>>>>>>
>>>>>>> For automation reason, i want to open the server dialog from
>>>>>>> "Object" list and not from "Servers" browser.
>>>>>>> This is does not worl for the first server connexion
>>>>>>>
>>>>>>> Le lun. 25 oct. 2021 à 11:36, Saif Manai <manaisaif24(at)gmail(dot)com> a
>>>>>>> écrit :
>>>>>>>
>>>>>>>> Got it, thanks!
>>>>>>>>
>>>>>>>> Le lun. 25 oct. 2021 à 06:08, Aditya Toshniwal <
>>>>>>>> aditya(dot)toshniwal(at)enterprisedb(dot)com> a écrit :
>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On Sat, Oct 23, 2021 at 5:09 AM Ni Ne <nineoften(at)hotmail(dot)com>
>>>>>>>>> wrote:
>>>>>>>>>
>>>>>>>>>> Saif,
>>>>>>>>>>
>>>>>>>>>> Try first to open a command terminal by typing cmd.exe from the
>>>>>>>>>> Windows Run prompt. Then from that window execute the psql commands.
>>>>>>>>>>
>>>>>>>>> Right. Sharing the screenshot.
>>>>>>>>> [image: image.png]
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Get Outlook for Android <https://aka.ms/AAb9ysg>
>>>>>>>>>> ------------------------------
>>>>>>>>>> *From:* Saif Manai <manaisaif24(at)gmail(dot)com>
>>>>>>>>>> *Sent:* Friday, October 22, 2021 7:38:07 AM
>>>>>>>>>> *To:* Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
>>>>>>>>>> *Cc:* pgadmin-support lists.postgresql.org <
>>>>>>>>>> pgadmin-support(at)lists(dot)postgresql(dot)org>
>>>>>>>>>> *Subject:* Re: pgAdmin commandLine
>>>>>>>>>>
>>>>>>>>>> Thank you for your reactivity.
>>>>>>>>>> When i double click psql a commandLine appear and disappear
>>>>>>>>>> directely without having the time to connect to server.
>>>>>>>>>> Is there anyway to use when comand psql with server, database
>>>>>>>>>> password, username and port in parameters?
>>>>>>>>>>
>>>>>>>>>> Le ven. 22 oct. 2021 à 13:18, Aditya Toshniwal <
>>>>>>>>>> aditya(dot)toshniwal(at)enterprisedb(dot)com> a écrit :
>>>>>>>>>>
>>>>>>>>>> Hi Saif,
>>>>>>>>>>
>>>>>>>>>> You can use PostgreSQL provided psql or pgAdmin shipped psql in
>>>>>>>>>> - C:\Program Files\pgAdmin 4\v6\runtime.
>>>>>>>>>>
>>>>>>>>>> On Fri, Oct 22, 2021 at 3:48 PM Saif Manai <manaisaif24(at)gmail(dot)com>
>>>>>>>>>> wrote:
>>>>>>>>>>
>>>>>>>>>> Hello,
>>>>>>>>>>
>>>>>>>>>> I had pgAdmin4 v4.3 and installed recently v6.1 (last one).
>>>>>>>>>>
>>>>>>>>>> Is there a way to launch a connection to a server (or database)
>>>>>>>>>> by command line without opening the UI, like this exemple for HeidiSQL on
>>>>>>>>>> Windows :
>>>>>>>>>> "D:\HeidiSQL\heidisql.exe" -n "8" -h "{Address}" -u "{UserName}"
>>>>>>>>>> -p "{Password}" -db "{Database}" -P "{Port}"
>>>>>>>>>>
>>>>>>>>>> Thank you in advance
>>>>>>>>>>
>>>>>>>>>> Best Regards,
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>>> Thanks,
>>>>>>>>>> Aditya Toshniwal
>>>>>>>>>> pgAdmin Hacker | Software Architect | *edbpostgres.com*
>>>>>>>>>> <http://edbpostgres.com>
>>>>>>>>>> "Don't Complain about Heat, Plant a TREE"
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> Thanks,
>>>>>>>>> Aditya Toshniwal
>>>>>>>>> pgAdmin Hacker | Software Architect | *edbpostgres.com*
>>>>>>>>> <http://edbpostgres.com>
>>>>>>>>> "Don't Complain about Heat, Plant a TREE"
>>>>>>>>>
>>>>>>>>
>>>
>>> --
>>> Thanks,
>>> Aditya Toshniwal
>>> pgAdmin Hacker | Software Architect | *edbpostgres.com*
>>> <http://edbpostgres.com>
>>> "Don't Complain about Heat, Plant a TREE"
>>>
>>

--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | *edbpostgres.com*
<http://edbpostgres.com>
"Don't Complain about Heat, Plant a TREE"

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message bw 2021-10-26 06:39:33 Re: Wonderful PgAdmin
Previous Message Saif Manai 2021-10-26 05:54:54 Re: pgAdmin commandLine