On Thu, 19 Jan 2006, Doug McNaught wrote:
Did you tell pg_restore to read from a file? Otherwise it will try to read from your terminal, which probably isn't what you want.
Doug, No, I didn't. I've no idea where the file was dumped, so I've no idea of the name or location. Reading in Douglas*2 PostgreSQL book (pages 872-873), they write nothing about giving pg_dumpall a file name/location nor that pg_restore needs that information. They do write that pg_restore wants a dump produced with -format=c or -format=t, without further explanation. Thanks, Rich -- Richard B. Shepard, Ph.D. | Author of "Quantifying Environmental Applied Ecosystem Services, Inc. (TM) | Impact Assessments Using Fuzzy Logic" <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
