| From: | Mahendra Singh Thalor <mahi6run(at)gmail(dot)com> |
|---|---|
| To: | Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
| Cc: | jian he <jian(dot)universality(at)gmail(dot)com>, Srinath Reddy <srinath2133(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Non-text mode for pg_dumpall |
| Date: | 2025-02-20 06:43:54 |
| Message-ID: | CAKYtNAppgqMUjuyn7a8s-guvZuwyqt=nm99CkJ1gaME7K4eEKQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Thanks Álvaro for feedback.
On Thu, 20 Feb 2025 at 02:39, Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> wrote:
>
> Hello,
>
> I think the business with an evergrowing on_exit list needs a different
> solution than a gigantic array of entries. Maybe it would make sense to
> restructure that code so that there's a single on_exit item, but there
> exists a list of per-database entries to clean up which are all done in
> one call of the function. Then you don't need to change the hardcoded
> MAX_ON_EXIT_NICELY array size there.
>
In the latest patch, I added one new function to clean
index(on_exit_nicely_index) with each database restore.
> I think it would be better to have a preparatory 0001 patch that just
> moves the code to the new files, without touching anything else, and
> then the new feature is introduced as a separate 0002 commit.
Fixed.
>
> You still have a bunch of XXX items here and there which look to me like
> they need to be handled before this patch can be considered final, plus
Fixed.
> the TODOs in the commit message. Please pgindent.
I am facing some errors in pgindent. I will run pgindent in the next version.
Here, I am attaching updated patches for review and testing.
--
Thanks and Regards
Mahendra Singh Thalor
EnterpriseDB: http://www.enterprisedb.com
| Attachment | Content-Type | Size |
|---|---|---|
| v19_0001_move-common-code-of-pg_dumpall-and-pg_restore-to-new_file.patch | application/octet-stream | 19.4 KB |
| v19_0002_pg_dumpall-with-non-text_format-20th_feb.patch | application/octet-stream | 61.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shubham Khanna | 2025-02-20 06:44:27 | Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility. |
| Previous Message | Yuki Seino | 2025-02-20 06:27:19 | Re: Add “FOR UPDATE NOWAIT” lock details to the log. |