| From: | "Wang, Mary Y" <mary(dot)y(dot)wang(at)boeing(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | How to Output PSQL Errors to a Log File? |
| Date: | 2010-02-23 07:19:34 |
| Message-ID: | FA20D4C4FEBFD148B1C0CB09913825FC01EBDEF574@XCH-SW-06V.sw.nos.boeing.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 occurred. Because there were so many errors, and I wanted the errors to be logged to a log file so I ran this command 'psql -e template1 -f 21.bak > late22error.txt', but late22error.txt didn't log the errors, it just logged the transactions. What option should I use to tell psql to log all errors to a log file?
I'm running on RHEL 3.9.
Thanks
Mary
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2010-02-23 07:25:06 | Re: How to Output PSQL Errors to a Log File? |
| Previous Message | Yang Zhang | 2010-02-23 07:02:33 | Re: Sorting performance vs. MySQL |