Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tsgcO-004cXq-Dw for pgadmin-hackers@arkaria.postgresql.org; Thu, 13 Mar 2025 11:20:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tsgcM-00B3Au-Rs for pgadmin-hackers@arkaria.postgresql.org; Thu, 13 Mar 2025 11:20:50 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tsgcM-00B39q-GH for pgadmin-hackers@lists.postgresql.org; Thu, 13 Mar 2025 11:20:50 +0000 Received: from mail-yb1-xb36.google.com ([2607:f8b0:4864:20::b36]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tsgcJ-002bRs-0z for pgadmin-hackers@postgresql.org; Thu, 13 Mar 2025 11:20:48 +0000 Received: by mail-yb1-xb36.google.com with SMTP id 3f1490d57ef6-e60aef2711fso625341276.2 for ; Thu, 13 Mar 2025 04:20:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1741864846; x=1742469646; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=Ju8VYNiHFUeHOwNsQgllv7xcZJnJBkdRauKRkZak6Dk=; b=iZuJqr5PTAYJB3ufBrw0PbjdR5sDd9KKM4xP0lwnuZXSQ9gS+P1oI11buVMSUXm25R +P5sirBfFRkJV5lMjuBmvKskxpUCkkasRmgYT9OtsH9wfraexjS+M4BBrFYzwYrbxMR1 ZAvRs+T7MtaYaZMAk0fk6xUtWORVWM+ToKX1C69yNoKHw3O/TXNbsahTOO98pqRZEvTE pHB9aVHfHwcApokdrG0F62q6YWjGoF2cqeGAMB72jDMHHYckxD71mK2lOep4gRwo49V1 U4/8Gw1M+wIAzLPCFGxAr685OAr9VZ7i+vcmEoME3ieSjXfhC2HW3tYmvOPkjzRJFNx+ lfUA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1741864846; x=1742469646; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=Ju8VYNiHFUeHOwNsQgllv7xcZJnJBkdRauKRkZak6Dk=; b=QGNycuDZ6pQKZWAHzJ2k23FR3L/VnJSwL8Ubm67wYSRmmrL8QfEZNn4EeT35ZwUbc3 FkMVAa7GG5mcg70+bsi39oeuDtzUjHKzok/Cd506zaZEgjE4+yjoJMM9HNsprJMbNL9E Afhh+oiYY2CxdAnV6REgsYsIgTTgIffCMreZ2YRBzWUyTJ0BEctHH15nLcAKGv8GMHxi DmmJi8WxXfb9gP641wp80hmCw9pcpdeWNyYRTSia1awaEGt2mAq97hNn0ooSFpO7exp+ IJ09iBxYTv+Oac3d/16du+egfuK/CYwhpuDIaiD6BDhmXQytiA3LuX+fyjshWYvZtVEF JRZg== X-Gm-Message-State: AOJu0Yx40UyJoye5tJwOZ1qo9RWBuX3IOPPLB6tjCcrM8haY0s/V2N+G +6PgEjtLN/DbgReAFnFijLqJZ+UIVw/UhYhbodKmg0E5xInnCn+DztFT62S+qQq3LRr2Zs7KDct XEdhuHY3TREDCf5fYSRppIkyYHP6medlAtTV5SG19Mg7Zbiw= X-Gm-Gg: ASbGncu90sBlWHs/HsvsV+zPopTFR1cn25DznAgaeu6rnU+djZYyTcBklIwQftV83x5 BTK3WSbFFCbteXzEYX0qBsdc9vbzlLHY32Ek7XDKfnzpfAPosAXj24nqz9Zhz1gPWdvTulfa2pW CofSReSDd573+IlKWX3Vl7SMi9f87COgTsBiYzbXRJYlmrB3OLw1D88dAJDNg= X-Google-Smtp-Source: AGHT+IErLVFDW6lkKC20/KBUm5aIzJ3/G+w33uLcBVczlWYWVv5pioumNaMk9RMiGhQeHqqxyrmsgnpCWfMSyPoYPVQ= X-Received: by 2002:a05:6902:e0e:b0:e57:fd58:ad51 with SMTP id 3f1490d57ef6-e635c100a20mr33335820276.1.1741864846492; Thu, 13 Mar 2025 04:20:46 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Yogesh Mahajan Date: Thu, 13 Mar 2025 16:50:10 +0530 X-Gm-Features: AQ5f1JrootSyG3b-PstHMnWVZk2w7gAMXRU98bPcrCobJ91e8mNOe1dSWI51d2w Message-ID: Subject: Re: Regarding feature #3319 To: Dave Page Cc: pgadmin-hackers Content-Type: multipart/alternative; boundary="0000000000006c26600630378320" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000006c26600630378320 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Dave, Couple of follow up questions - Thanks, Yogesh Mahajan EnterpriseDB On Thu, Mar 13, 2025 at 4:37=E2=80=AFPM Dave Page wrote= : > > > On Tue, 11 Mar 2025 at 08:31, Yogesh Mahajan < > yogesh.mahajan@enterprisedb.com> 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? 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 preceden= t > 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 > > --0000000000006c26600630378320 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Dave,

Couple of follow up questions -=C2=A0

Thanks,
Yogesh Mahajan
EnterpriseDB


On Thu, Mar 13, 2025 at 4:37=E2=80=AFPM Dave Page <dpage@pgadmin.org> wrote:


On Tue, 11 Mar 2025 at 08:31= , Yogesh Mahajan <yogesh.mahajan@enterprisedb.com> wrote:
Hello Team,

Couple of more questions arose duri= ng discussion -=C2=A0

1.What all tools should we reopen while restoration? It could be= Query tool, ERD, Psql, Schema diff as of now may get additional=C2=A0in fu= ture.

Yes :-). Idea= lly, as much of the original state as possible should be restored.=C2=A0

So, should we op= en the psql without data and schema diff without comparison results?
<= div style=3D"font-family:verdana,sans-serif;font-size:small" class=3D"gmail= _default">Also for the query tools open with an ad-hoc server, should=C2=A0= we just open a query tool with data without=C2=A0connections?

<= div>=C2=A0
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 the= re.
Currently we are storin= g this data with json encoding done by the request=C2=A0module.

--0000000000006c26600630378320--