Yes dos2unix <postgres.sql> worked absolutely fine. I got the solution of my problem. Thanks alot for your co-operation. I am using Linux Red hat 9 and my client is also using the same platform but when he emailed me this sql file he first saved file on windows and then I saved it on windows and saved n run on linux So I think this procedure leads to carriage return. but dos2unix command sorted out the problem.
----- Original Message ----- From: "Michael Fuhr" <[EMAIL PROTECTED]> To: "Inpreet Singh" <[EMAIL PROTECTED]> Cc: <pgsql-admin@postgresql.org> Sent: Friday, January 28, 2005 11:18 AM Subject: Re: [ADMIN] Restore postgres database problem > On Fri, Jan 28, 2005 at 11:00:44AM +0530, Inpreet Singh wrote: > > > Yes it returning carriage returns. I am pasting below the output to the > > command u send to me > > > > *******Linux Prompt********************** > > [EMAIL PROTECTED] inpreet]# head postgres.sql | cat -v > > --^M > > -- PostgreSQL database cluster dump^M > > --^M > > You could strip the carriage returns with tr, sed, perl, dos2unix, > etc. Here's an example: > > tr -d '\r' < postgres.sql > fixed.sql # or pipe into psql > > What kind of system did you create the dump on? How did you transfer > the file? If you can figure out how the carriage returns got there > then you might be able to prevent it from happening in the future. > > -- > Michael Fuhr > http://www.fuhr.org/~mfuhr/ > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
