Hi all,
I've switched on log_statement in postgresql.conf
for debugging purposes. I tried logging connections
and pids as well, but I need to match up the logged statements
to specific connections.
The postmaster logs to a separate log file, but at the moment
it's impossible to tell which
Stef mentioned :
= The postmaster logs to a separate log file, but at the moment
= it's impossible to tell which sql comes from which connection.
= Is there an easy way to accomplish this?
Erm... sorry ,
It appears my postgresql.conf is not an original. It didn't have
the log_pid option in. :)
D'Arcy J.M. Cain wrote:
With the price of GigE adapters I wouldn't consider anything else.
I have a huge database that takes about an hour to copy. The netApp snapshot
feature is very nice because I can get a moment in time image of the
database. Even though I can't run from the snapshot
Anyone have good/bad experience using OpenGFS or the Sistina GFS?
Any other cluster file systems out there?
Greg
--
Greg Spiegelberg
Sr. Product Development Engineer
Cranel, Incorporated.
Phone: 614.318.4314
Fax: 614.431.8388
Email: [EMAIL PROTECTED]
Cranel. Technology. Integrity. Focus.
Hi,I have Installed Postgresql 7.3 for
linuxsuse8.2 and i try to connect topostgresql pass through
phpPgAdmin3.2 but i can't because i get message'php doesn't support
database connectivity', so how can i pass through
tophpPgAdmin?regards,
Charlie Schaubmair
Trying to install 7.3.4 on a Sparc 64 sunos 5.9 box, and have followed
the instructions on
http://techdocs.postgresql.org/v2/Guides/Installation%20Guides/
Compiling%20PostgreSQL%207.3.2%20on%20Solaris%208%209/view to the t.
However, when going to compile Postgres I'm getting the error on
Dear Ganesan,
pgautodoc (for dot output) + dot (from graphviz.org , creates
postscript) +
epssplit ( splits the postscript into multipage so that one can create
poster size
diagrams) works well for me.
I have 45 tables in the database though.
Regds
mallah.
Chris Travers wrote:
There is a
The postmaster logs to a separate log file, but at the moment
it's impossible to tell which sql comes from which connection.
Is there an easy way to accomplish this?
The PID of the connected process is prepended to every log statement.
You can make use of this to know which sql comes from