| From: | Mahendra Singh Thalor <mahi6run(at)gmail(dot)com> |
|---|---|
| To: | Nathan Bossart <nathandbossart(at)gmail(dot)com> |
| Cc: | Andrew Dunstan <andrew(at)dunslane(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Srinath Reddy <srinath2133(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: getting "shell command argument contains a newline or carriage return:" error with pg_dumpall when db name have new line in double quote |
| Date: | 2026-01-20 06:29:24 |
| Message-ID: | CAKYtNArwMfw1OSTSucZz1ei829xpzMKL50rXDDV02-5Z61Yv-w@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, 24 Jun 2025 at 11:37, Mahendra Singh Thalor <mahi6run(at)gmail(dot)com> wrote:
>
> On Fri, 11 Apr 2025 at 20:17, Nathan Bossart <nathandbossart(at)gmail(dot)com> wrote:
> >
> > On Thu, Apr 10, 2025 at 11:58:41PM +0530, Mahendra Singh Thalor wrote:
> > > As per above discussions, for v18, we will not do any change to server
> > > side to fix the issue of \n\r in database names. But as a cleanup
> > > patch, we can give an alert to the user by "pg_upgrade --check". As
> > > per current code, pg_dump and pg_upgrade will fail with "shell
> > > command" error but in the attached patch, we will give some extra info
> > > to the user by "pg_upgrade --check" so that they can fix database
> > > names before trying to upgrade.
> > >
> > > Here, I am attaching a patch which will give a list of invalid
> > > database names in "pg_upgrade --check". We can consider this as a
> > > cleanup patch.
> >
> > Are you proposing this for v18? I think this is all v19 material at this
> > point. Perhaps we could argue this is a bug fix that should be
> > back-patched, but IMHO that's a bit of a stretch. I don't sense a
> > tremendous amount of urgency, either.
> >
> > --
> > nathan
>
> Thanks Nathan for the review.
>
> I want to re-start this thread for v19. I posted v06* patches in my previous updates[1]. Please someone review it and let me know feedback.
>
> v06 patches: v06_patches
>
> [1] : https://www.postgresql.org/message-id/CAKYtNAqC5pkjmh8UgvbNLtMyEVeKUtDF3_%2B9dvG9zb8YrhTJQQ%40mail.gmail.com
>
> --
> Thanks and Regards
> Mahendra Singh Thalor
> EnterpriseDB: http://www.enterprisedb.com
Hi,
Here I am attaching updated patches for the review. Please someone review it.
--
Thanks and Regards
Mahendra Singh Thalor
EnterpriseDB: http://www.enterprisedb.com
| Attachment | Content-Type | Size |
|---|---|---|
| v07_0001_don-t-allow-newline-or-carriage-return-in-db-user-role-names.patch | application/octet-stream | 7.9 KB |
| v07_0002-add-handling-to-pg_upgrade-to-report-alert-for-invalid-names.patch | application/octet-stream | 3.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Smith | 2026-01-20 06:29:35 | Re: Proposal: Conflict log history table for Logical Replication |
| Previous Message | Chao Li | 2026-01-20 06:23:55 | Re: heap_create_with_catalog comments |