Thread: Redirect ERROR, FATAL and other messages
Hello! I'm executing a postgres command from a C code, the command that I introduce is the following: "sudo -u pgsql psql -p 3306 -d triage_dump -c 'insert into control select *from uuid ' > logfile" In the logfile, the output is introduced, but certain lines are not, like for example: *ERROR: duplicate key value violates unique constraint "control_pkey" DETAIL: Key (uuid)=(10000717) already exists. could not find a "psql" to execute* I understand the error messages, but I don't want them to appear in the screen (stdout), is there any way to send this messages to a log file? I need all messages from postgres goes to a logfile, but seems is not enough with "> logfile" Can somebody give me a hint to solve my issue? Thanks in advance Gabs -- View this message in context: http://postgresql.1045698.n5.nabble.com/Redirect-ERROR-FATAL-and-other-messages-tp5154551p5154551.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
pittgs <gabriela.pittari@triagnosys.com> writes: > Hello! > > I'm executing a postgres command from a C code, the command that I introduce > is the following: > > "sudo -u pgsql psql -p 3306 -d triage_dump -c 'insert into control select > *from uuid ' > logfile" > > In the logfile, the output is introduced, but certain lines are not, like > for example: > *ERROR: duplicate key value violates unique constraint "control_pkey" > DETAIL: Key (uuid)=(10000717) already exists. > could not find a "psql" to execute* > > I understand the error messages, but I don't want them to appear in the > screen (stdout), is there any way to send this messages to a log file? I > need all messages from postgres goes to a logfile, but seems is not enough > with "> logfile" > Can somebody give me a hint to solve my issue? See the 2 settings; client_min_messages log_min_messages > Thanks in advance > Gabs > > -- > View this message in context: http://postgresql.1045698.n5.nabble.com/Redirect-ERROR-FATAL-and-other-messages-tp5154551p5154551.html > Sent from the PostgreSQL - general mailing list archive at Nabble.com. > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Jerry Sievers Postgres DBA/Development Consulting e: postgres.consulting@comcast.net p: 305.321.1144
On Wed, Jan 18, 2012 at 03:20:05AM -0800, pittgs wrote: > with "> logfile" > Can somebody give me a hint to solve my issue? errors are written not to stdout (which is redirected with >), but to stderr. which means, that you can redirect them, as with any other program, with 2>, like: psql ... > logfile 2>&1 depesz -- The best thing about modern society is how easy it is to avoid contact with it. http://depesz.com/