Nick, > To restore from a plain-text dump file, just pipe it into > psql like so: > > cat [filename] | psql [dbname]
To nit-pick, this is a "useless use of cat". In UNIX-land, simple input redirection will work much better: psql [dbname and various options] < [filename] It's also less to type! :) I also believe this works in certain Windows operating systems, which is what it appears Mago is using. -------------------------- David Olbersen iGuard Engineer St. Bernard Software 11415 West Bernardo Court San Diego, CA 92127 1-858-676-2277 x2152 > -----Original Message----- > From: Nick Fankhauser [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 22, 2003 1:30 PM > To: Marvin; [EMAIL PROTECTED] > Subject: Re: [ADMIN] pg_restore problem!!! > > > Mago- > > pg_restore is used to restore a dump file created in one of > the non-text > formats such as tar format. > > To restore from a plain-text dump file, just pipe it into > psql like so: > > cat [filename] | psql [dbname] > > -Nick > > --------------------------------------------------------------------- > Nick Fankhauser > > [EMAIL PROTECTED] Phone 1.765.965.7363 Fax 1.765.962.9788 > doxpop - Court records at your fingertips - http://www.doxpop.com/ > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Marvin > Sent: Tuesday, July 22, 2003 3:22 PM > To: [EMAIL PROTECTED] > Subject: [ADMIN] pg_restore problem!!! > > > I made a back up file with this sentence: > > pg_dump -U [superusername] -C -D -f [filename] [dbname] > > It seems to work fine. I opened the file and I saw all the commands to > insert every piece of data and reconstruct my schema. However > when I try to > restore that file it gets me the following error: > > C:\>pg_restore [filename] > pg_restore: [archiver] input file does not appear to be a > valid archive > > What I am doing wrong?? > Any ideas?? > > Thank you in advanced. > > > MAGO > > > _________________________________________________________________ > IncrediMail - El E-mail ha evolucionado finalmente - Haga clic aquí > > > ---------------------------(end of > broadcast)--------------------------- > TIP 8: explain analyze is your friend > ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
