Ivan wrote: Hi,
> Thursday, November 3, 2005, 3:28:41 PM, you wrote: > >> Perhaps you missed my previous message. > >> pg_dumpall has not -f command line option > >> to specify output file - it always send output > >> to standart output. But there is an issue with > >> it in Windows (I described it earlier) - function's > >> line endings are changed from 0D 0A to 0D 0D 0A. > > AH> Hmm, what do you need that for? Why don't you directly restore the > AH> binary dump to a database by using option -d? > > I don't need to restore binary dump. I need to make a dump of the > whole database cluster to plain sql file (what pg_dumpall does). > So I have to redirect pg_dumpall's output to a file > pg_dump [options] > cluster_dump.sql Hum, doh! I misread your message as thought it referred to pg_restore rather than pg_dumpall. Not sure why. Certainly pg_dumpall needs a redirecting feature. I imagine there must be a way to tell the shell not to do newline translation, but I wouldn't know it. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
