Home > mailing lists

getting "shell command argument contains a newline or carriage return:" error with pg_dumpall when db name have new line in double quote - Mailing list pgsql-hackers

From	Mahendra Singh Thalor
Subject	getting "shell command argument contains a newline or carriage return:" error with pg_dumpall when db name have new line in double quote
Date	January 29 19:24:58
Msg-id	CAKYtNApkOi4FY0S7+3jpTqnHVyyZ6Tbzhtbah-NBbY-mGsiKAQ@mail.gmail.com Whole thread Raw
Responses	Re: getting "shell command argument contains a newline or carriage return:" error with pg_dumpall when db name have new line in double quote
List	pgsql-hackers

Hi,

While doing some testing with pg_dumpall, I noticed one weird behaviour.

While we create the database, we are allowing the database name with a new line (if name is in double quote).

For example:

postgres=# create database "dbstr1;
dbstr 2";
CREATE DATABASE
postgres=#

Here, the database name is in 2 lines.

With the help of pg_dumpall, I tried to dump but I am getting an error for the new line.

--
-- Database "dbstr1;
dbstr 2" dump
--

shell command argument contains a newline or carriage return: " dbname='dbstr1;
dbstr 2'"

After this message, we are stopping the dump.

I think, if we are allowing new lines in the db name, then we should dump it.

Please let me know your thoughts about this error.

--
Thanks and Regards
Mahendra Singh Thalor
EnterpriseDB: http://www.enterprisedb.com

From: Nazir Bilal Yavuz
Date: 29 January, 18:24:45
Subject: Re: Windows CFBot is broken because ecpg dec_test.c error

From: Melanie Plageman
Date: 29 January, 19:34:55
Subject: Re: Eagerly scan all-visible pages to amortize aggressive vacuum