From: Devin Whalen <devin@synapticvision.com>
To: olly@lfix.co.uk
Cc: pgsql-sql@postgresql.org
Subject: Re: Sending errors from psql to error file
Date: Thu, 12 Aug 2004 11:53:09 -0400
Message-ID: <1092325989.23985.52.camel@192.168.1.80> (raw)
In-Reply-To: <1092323361.11184.34.camel@braydb>
References: <1092320416.23985.24.camel@192.168.1.80>
<1092322233.11188.30.camel@braydb>
<1092322881.23985.38.camel@192.168.1.80>
<1092323361.11184.34.camel@braydb>
On Thu, 2004-08-12 at 11:09, Oliver Elphick wrote:
> On Thu, 2004-08-12 at 16:01, Devin Whalen wrote:
> > > zcat cli_postDataInserts.sql.gz |
> > > psql -d cli_post -U system --echo-queries -f - >trace.file 2>&1
> >
> > Just a few questions about your command. I tried it with one sql
> > statement that I know doesn't work and the error went into the right
> > file. However, I would like to know WHY it works...hope you don't mind
> > shedding some light on it :). Specifically, the - >trace.file 2>&1
> > part. I know...well actually think, that the > is redirecting the ouput to the trace.file. But what the hell is 2>&1 doing??
> > Also, the - ...it kinda just looks like a stray dash to me....although I know it must be doing something ;).
> > Will this put all output? Or just the errors.
>
> ">" redirects standard output
> "2>" redirects standard error
>
> Your command did not redirect standard error, so the errors didn't get
> to grep
>
> The syntax for -f is "-f filename"; the filename "-" means standard
> input. (Check the man page for psql!)
>
>
> Oliver
Thanks for you explanations. They are a big help. Now that I
understand it better I can modify it to suit my needs. I really only
want the errors because if I keep track of all the inserts then the file
will be too big. So I just have to use 2>, or rather 2>> so I can
append to the file.
The syntax for -f is "-f filename"; the filename "-" means standard
> input. (Check the man page for psql!)
I swear I read it like 15 times and I guess I just scanned over that part every time!! :)
Later
--
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: devin@synapticvision.com, olly@lfix.co.uk
Subject: Re: Sending errors from psql to error file
In-Reply-To: <1092325989.23985.52.camel@192.168.1.80>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox