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 sq
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 sn
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
linux suse8.2 and i try to connect topostgresql pass through
phpPgAdmin 3.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 fre
> 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