Re: [ADMIN] Restore postgres database problem

2005-01-29 Thread Inpreet Singh
ime of insertion of record and I am trying to insert earlier date time. Regards Inpreet Singh - Original Message - From: "Michael Fuhr" <[EMAIL PROTECTED]> To: "Inpreet Singh" <[EMAIL PROTECTED]> Cc: Sent: Wednesday, January 26, 2005 3:08 AM Subject: Re: [A

Re: [ADMIN] Restore postgres database problem

2005-01-29 Thread Inpreet Singh
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: Sent: Friday, January 28, 2005 11:18 AM Subje

Re: [ADMIN] Restore postgres database problem

2005-01-29 Thread Inpreet Singh
^M --^M ^M *** Now what should I do? Regards Inpreet Singh - Original Message - From: "Michael Fuhr" <[EMAIL PROTECTED]> To: "Inpreet Singh" <[EMAIL PROTECTED]> Cc: Sent: Friday, January 28, 2005 10:34 AM Subject: Re: [ADMIN

Re: [ADMIN] Restore postgres database problem

2005-01-27 Thread Michael Fuhr
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 cl

Re: [ADMIN] Restore postgres database problem

2005-01-27 Thread Michael Fuhr
On Thu, Jan 27, 2005 at 11:03:43AM +0530, Inpreet Singh wrote: > *Taken Dump :* /usr/bin/pg_dumpall > /home/inpreet/postgres.sql /*which > was taken at client site*/ > > *Restoring Dump :* su - postgres /*This process I am doing at local site > so thats why psql and dumpall are in diff direc

Re: [ADMIN] Restore postgres database problem

2005-01-27 Thread Luis Sousa
To: "Inpreet Singh" <[EMAIL PROTECTED]> Sent: Wednesday, January 26, 2005 3:38 PM Subject: Re: [ADMIN] Restore postgres database problem Which options did you use to dump data? And which options did you use to restore it? Please submit the command lines used. Luis Sousa Inp

Re: [ADMIN] Restore postgres database problem

2005-01-26 Thread Luis Sousa
Which options did you use to dump data? And which options did you use to restore it? Please submit the command lines used. Luis Sousa Inpreet Singh wrote: Hello, I am using postgres 7.3.4. I am trying to restore database dump using psql command but getting following error. *Taken Dump :* /usr/

Re: [ADMIN] Restore postgres database problem

2005-01-25 Thread Michael Fuhr
On Tue, Jan 25, 2005 at 10:26:25AM +0530, Inpreet Singh wrote: > > I am using postgres 7.3.4. I am trying to restore database dump using > psql command but getting following error. > > Taken Dump : /usr/bin/pg_dumpall > /home/inpreet/postgres.sql > Restoring Dump : su - postgres > /usr/local

[ADMIN] Restore postgres database problem

2005-01-25 Thread Inpreet Singh
Hello, I am using postgres 7.3.4. I am trying to restore database dump using psql command but getting following error.   Taken Dump :   /usr/bin/pg_dumpall > /home/inpreet/postgres.sql Restoring Dump :   su - postgres /usr/local/pgsql/bin/psql -d template1 < /home/inpreet/postgres.sql   b