pittgs <gabriela.pitt...@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.consult...@comcast.net p: 305.321.1144 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
