From: | Devin Whalen <devin(at)synapticvision(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Sending errors from psql to error file |
Date: | 2004-08-12 14:20:17 |
Message-ID: | 1092320416.23985.24.camel@192.168.1.80 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hello,
I am trying to migrate a client from one database to another. Basically
we designed a web application for them using Postgresql but we have made
many changes to the design of our application since version 1. Now they
want to upgrade. So basically I have to pg_dump their current data and
then import it into our new schema. Now, of course I realize that there
are going to be errors. But they have a lot and I mean a lot of data.
I don't want to have to sit there and watch the import go by, I want to
run a command and then look in a file for any errors after the import is
complete. I tried this command but it didn't work:
gunzip -c cli_postDataInserts.sql.gz | psql cli_post -U system | grep
"ERROR:*" > import_errors
Any help is appreciated.
Thanks.
--
Devin Whalen
Programmer
Synaptic Vision Inc
Phone-(416) 539-0801
Fax- (416) 539-8280
1179A King St. West
Toronto, Ontario
Suite 309 M6K 3C5
Home-(416) 653-3982
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-08-12 14:30:41 | Re: function expression in FROM may not refer to other relations of same query level |
Previous Message | Fabio Ferrero | 2004-08-12 13:42:40 | duplicate table in two databases |