Here is a link to the doc you need.
http://www.postgresql.org/idocs/index.php?runtime-config.html#LOGGING
DEBUG_PRINT_QUERY (boolean)
DEBUG_PRINT_PARSE (boolean)
DEBUG_PRINT_REWRITTEN (boolean)
DEBUG_PRINT_PLAN (boolean)
DEBUG_PRETTY_PRINT (boolean)
Hope this helps
Phil
- Original Message -
Hi-
I'd like to set the logging or debug level so that the text of the queries
that are executed show up in the log file. It seems to me that I recall this
being discussed before, but I can't find any specific references in the
runtime-config portion of the docs.
Can someone tell me if this is p
Hi Steven ,
thanks for the reply and letting me know that a primary key is
essential for the replicated tables.
For your information pending.c used to crash postmaster even
when it was not in debug mode. (it was only then i defined
DEBUG_OUTPUT to see whats going on).
Thanks for the patch. But
Hi
Is anyone using dbmirror in production?
I Intend to replicate a set of tables between local and remote servers.
and plan to use dbmirror.
I observe that unless a table has a primary key the trigger recordchange()
which is supposed to be attached to a replicated table does not works properly
Yep i forgot to mention PgAdmin2.
PgAdmin2 is a great peice of s/w an i specially like its outputing
directly to excel. This is specially helpful in making printed reports.
but my answer was to the ques "is there any command line...?" which
pgadmin2 is difnitely not. what abt \d commands? in p
You could write a perl script; you'd need to install perl on the windows
box and then just wrap an execute() around each command entered. Not
exactly elegant but functional.
--
Andrew J Perrin - http://www.unc.edu/~aperrin
Assist
PgAdmin2 for windows has the ability to execute arbitrary SQL statememts
Rajesh Kumar Mallah. wrote:
nopes 1 have not come across any, does cygwin port of
psql work?
But i know a decent SSH/Telnet client called "PuTTy"
http://the.earth.li/~sgtatham/putty/latest/x86/putty.exe
U can always
Title: Message
Company name:
DataOne, Inc
Location: United States, Illinois, Northbrook (Chicago)
Description: DataOne requires experienced developers with deep knowledge of
development in the Linux environment. We build CRM solutions, delivered through
a browser based interface. The dev