public inbox for [email protected]
help / color / mirror / Atom feedFrom: Yogesh Mahajan <[email protected]>
To: Dave Page <[email protected]>
Cc: pgadmin-hackers <[email protected]>
Subject: Re: Regarding feature #3319
Date: Thu, 13 Mar 2025 17:11:15 +0530
Message-ID: <CAMa=N=MNejaxVf9=t-vqv2ixfnfmgqYi9ESswqYyDsVKX_vvZw@mail.gmail.com> (raw)
In-Reply-To: <CA+OCxozw9GqRuHPuLoJo4B1h1JdfqGyn46J6N6U43WhnHpvC7w@mail.gmail.com>
References: <CAO+oWtC0aHG_7D69OiHvjHfpt9fJt=Q0LhPu_2oLCD71c1QORw@mail.gmail.com>
<CA+OCxoz=3WbRzir+sP9qba97Tn4YrRV0bq5CFcVNtFsNKZ+5Lw@mail.gmail.com>
<CAO+oWtAS2D3G_+rTOn2iY0HJLkJMjr2D6WNui+X8jZ_CSGiT_w@mail.gmail.com>
<CAM9w-_=Y4ht5P9-PeDz++Sk5EAKU9jKkvTTNBU+mQEzWo0BoPw@mail.gmail.com>
<CAO+oWtDjAydE7p8XSj4pW3WnXtgdoB+vQxC5AxsfdTsaVBRwbw@mail.gmail.com>
<CAM9w-_n-Uh=rvV6CTESUnoiiUaUa2vxao7SJBVrrv1E0uMWRpQ@mail.gmail.com>
<CAO+oWtCjn=0QCdXU1eXUk_zGqEn_qWQDAmoOadNkZwiUT58Jfg@mail.gmail.com>
<CAM9w-_=42-JBrLX=-SB_6GyWC7PO1-T8MhvYn5r0aQcyZ+xt0w@mail.gmail.com>
<CA+OCxozyK0z=UF+V1ypLxh0kJxW=NsgEObKSiJ-CZGdRfH5_Tw@mail.gmail.com>
<CAMa=N=PGM2e3k0Vs7P_0O2sgsvU5HO2PgJVF6jWDarjvE2EXQA@mail.gmail.com>
<CA+OCxoyXBn+heMWc7Jg_b+sB=+KnTwcwGBYj2Tx8bzSNNqV8Uw@mail.gmail.com>
<CAM9w-_=aB30i4Ev=Xj_jR1ysB+y_yNRXsLC2-3fJ1fd6f2CRDg@mail.gmail.com>
<CA+OCxozGMt+GjOSn7XZ24mfde+=vAXvNYtJEJ8WR6=fda-LP=g@mail.gmail.com>
<CAM9w-_=gM8+yMc9EYdeJzfRd5=PisE45VJhetFX3XQb9hjm65Q@mail.gmail.com>
<CA+OCxoyjonfAsU5G5m231Cq3TU2+OJkQNewqt12Ce1fkfPfDfA@mail.gmail.com>
<CAMa=N=MGTEJ9YxkY-enFV2QoTR5E0vusdqiSx19=zDX0M_7w1Q@mail.gmail.com>
<CA+OCxoz8Yn3AkZ-OjX3==-qwiazZDdpvwUuh6_TFNuxeov3yhQ@mail.gmail.com>
<CAMa=N=PmMgwfu034PK3ggxuzPKp_J=p5rPR9x+Xo=qYAW2XabQ@mail.gmail.com>
<CA+OCxozU15HwPYsJ9B5567QfAnxWQdgb=-3fo5NXT7Eq-EU+Rw@mail.gmail.com>
<CAMa=N=NRcj96jnbBbpgtOgQBDn4YeKwuHCzoEv-76QH8uXL-UA@mail.gmail.com>
<CA+OCxozw9GqRuHPuLoJo4B1h1JdfqGyn46J6N6U43WhnHpvC7w@mail.gmail.com>
Hi Dave,
Yes, we can store connection info. We might need to tweak how we create the
query tool connections.
Thanks for the inputs.
Thanks,
Yogesh Mahajan
EnterpriseDB
On Thu, Mar 13, 2025 at 5:07 PM Dave Page <[email protected]> wrote:
> Hi
>
> On Thu, 13 Mar 2025 at 11:35, Yogesh Mahajan <
> [email protected]> wrote:
>
>> Hi Dave,
>>
>> What about the query tools opened with an ad-hoc server, should we just
>> open a query tool with data without connections?
>>
>
> Can we not save the connection parameters used in the JSON (excluding the
> password that we can prompt for of course)?
>
>
>>
>> Thanks,
>> Yogesh Mahajan
>> EnterpriseDB
>>
>>
>> On Thu, Mar 13, 2025 at 4:59 PM Dave Page <[email protected]> wrote:
>>
>>> Hi
>>>
>>> On Thu, 13 Mar 2025 at 11:20, Yogesh Mahajan <
>>> [email protected]> wrote:
>>>
>>>> Hi Dave,
>>>>
>>>> Couple of follow up questions -
>>>>
>>>> Thanks,
>>>> Yogesh Mahajan
>>>> EnterpriseDB
>>>>
>>>>
>>>> On Thu, Mar 13, 2025 at 4:37 PM Dave Page <[email protected]> wrote:
>>>>
>>>>>
>>>>>
>>>>> On Tue, 11 Mar 2025 at 08:31, Yogesh Mahajan <
>>>>> [email protected]> wrote:
>>>>>
>>>>>> Hello Team,
>>>>>>
>>>>>> Couple of more questions arose during discussion -
>>>>>>
>>>>>> 1.What all tools should we reopen while restoration? It could be
>>>>>> Query tool, ERD, Psql, Schema diff as of now may get additional in future.
>>>>>>
>>>>>
>>>>> Yes :-). Ideally, as much of the original state as possible should be
>>>>> restored.
>>>>>
>>>>
>>>> So, should we open the psql without data and schema diff without
>>>> comparison results?
>>>>
>>>
>>> I don't see that we have any choice for psql. We absolutely should *not*
>>> attempt to automatically re-run user queries.
>>>
>>> For the schema diff, yes, that could be very expensive. The user can
>>> press the button if they want to incur that cost.
>>>
>>>
>>>> Also for the query tools open with an ad-hoc server, should we just
>>>> open a query tool with data without connections?
>>>>
>>>>
>>>>>
>>>>>> 2.Can we use an existing crypt key to encrypt the query data or
>>>>>> simply json encoding should be enough?
>>>>>>
>>>>>
>>>>> We're already storing the query history, so we should follow the
>>>>> precedent there.
>>>>>
>>>> Currently we are storing this data with json encoding done by the
>>>> request module.
>>>>
>>>>
>>>>> --
>>>>> Dave Page
>>>>> pgAdmin: https://www.pgadmin.org
>>>>> PostgreSQL: https://www.postgresql.org
>>>>> pgEdge: https://www.pgedge.com
>>>>>
>>>>>
>>>
>>> --
>>> Dave Page
>>> pgAdmin: https://www.pgadmin.org
>>> PostgreSQL: https://www.postgresql.org
>>> pgEdge: https://www.pgedge.com
>>>
>>>
>
> --
> Dave Page
> pgAdmin: https://www.pgadmin.org
> PostgreSQL: https://www.postgresql.org
> pgEdge: https://www.pgedge.com
>
>
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Regarding feature #3319
In-Reply-To: <CAMa=N=MNejaxVf9=t-vqv2ixfnfmgqYi9ESswqYyDsVKX_vvZw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox