Re: [GENERAL] How to Output PSQL Errors to a Log File?

2010-02-25 Thread Wang, Mary Y
@postgresql.org Subject: Re: [GENERAL] How to Output PSQL Errors to a Log File? On Mon, 2010-02-22 at 23:32 -0800, Wang, Mary Y wrote: No. I dumped the 7.1 with the 7.1 version of pg_dump. Is it better to dump with the 8.3 version of pg_dump? Since you will be restoring your data to a 8.3 server, you

[GENERAL] How to Output PSQL Errors to a Log File?

2010-02-22 Thread Wang, Mary Y
Hi, I used 'pg_dumpall' to dump the database in Postgres 7.1.3 and I'm in the process of restoring the databases in Postgres 8.3.8. There were lots errors showed on the screen when I ran this command 'psql -e template1 -f 21.bak' and it actually displayed the line numbers where the errors

Re: [GENERAL] How to Output PSQL Errors to a Log File?

2010-02-22 Thread Joshua D. Drake
On Mon, 22 Feb 2010 23:19:34 -0800, Wang, Mary Y mary.y.w...@boeing.com wrote: Hi, I used 'pg_dumpall' to dump the database in Postgres 7.1.3 and I'm in the process of restoring the databases in Postgres 8.3.8. There were lots errors showed on the screen when I ran this command 'psql -e

Re: [GENERAL] How to Output PSQL Errors to a Log File?

2010-02-22 Thread John R Pierce
Wang, Mary Y wrote: Hi, I used 'pg_dumpall' to dump the database in Postgres 7.1.3 and I'm in the process of restoring the databases in Postgres 8.3.8. There were lots errors showed on the screen when I ran this command 'psql -e template1 -f 21.bak' and it actually displayed the line

Re: [GENERAL] How to Output PSQL Errors to a Log File?

2010-02-22 Thread Nilesh Govindarajan
On 02/23/2010 12:54 PM, Nilesh Govindarajan wrote: On 02/23/2010 12:49 PM, Wang, Mary Y wrote: Hi, I used 'pg_dumpall' to dump the database in Postgres 7.1.3 and I'm in the process of restoring the databases in Postgres 8.3.8. There were lots errors showed on the screen when I ran this command

Re: [GENERAL] How to Output PSQL Errors to a Log File?

2010-02-22 Thread Wang, Mary Y
:25 PM To: Wang, Mary Y Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] How to Output PSQL Errors to a Log File? On Mon, 22 Feb 2010 23:19:34 -0800, Wang, Mary Y mary.y.w...@boeing.com wrote: Hi, I used 'pg_dumpall' to dump the database in Postgres 7.1.3 and I'm in the process

Re: [GENERAL] How to Output PSQL Errors to a Log File?

2010-02-22 Thread Devrim GÜNDÜZ
On Mon, 2010-02-22 at 23:32 -0800, Wang, Mary Y wrote: No. I dumped the 7.1 with the 7.1 version of pg_dump. Is it better to dump with the 8.3 version of pg_dump? Since you will be restoring your data to a 8.3 server, you should use 8.3 pg_dump, yes. I thought I read it some where in the