Re: pg_dump seems to be broken in regards to the "--exclude-table-data" option on Windows.

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: pg_dump seems to be broken in regards to the "--exclude-table-data" option on Windows.
Дата
Msg-id CAKFQuwaw17Xs5cteqBy1G8n2x4cHUK-XQYL3SXrBs6Cy-HdreQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_dump seems to be broken in regards to the "--exclude-table-data" option on Windows.  (tutiluren@tutanota.com)
Список pgsql-bugs
Дерево обсуждения
On Tue, Jul 28, 2020 at 3:40 PM <tutiluren@tutanota.com> wrote: 
(I don't now how I'd link to it.)

Messages and threads in the mailing list archive I mentioned before can be linked to.

https://www.postgresql.org/list/

There I go through everything with full commands and a minimal test database (which I also describe how I created).

I don't see how I could possibly create a smaller or clearer example of the issue.

A psql script for setup would increase the self-contained nature of the test.  In Linux I'd also use something like grep to test the output file and/or script outputs.  More generally the test script should probably include pg_restore and then various psql commands to check that the resulting restored database contains the expected data.

That said, If I was setup for experimenting in Windows, probably including compiling, the provided information is enough to put together a complete test case to experiment with.

Whatever "strange things" cmd.exe does clearly doesn't show up for my cross-platform PHP CLI script. (I guess it's theoretically possible that PHP for Windows does some sort of "processing" automatically which pg_dump lacks, but I doubt it.)

The PHP script you show is a pure client-only script.  The observed behavior is occurring in a client-server architecture, specifically in the communication interface between the two.  It's also, quite probably, not restricted to pg_dump (a more useful test script would include trying to demonstrate the problem using just psql, probably using the -v option).

David J.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: tutiluren@tutanota.com
Дата:
Сообщение: Re: pg_dump seems to be broken in regards to the "--exclude-table-data" option on Windows.
Следующее
От: Oleksandr Shulgin
Дата:
Сообщение: Re: pg_dump seems to be broken in regards to the "--exclude-table-data" option on Windows.