June 16, 2003

Postgres

I need to see what SQL is being processed by Postgres. Starting Postgres from the command line like this will log it.

/usr/local/pgsql/bin/postmaster -i -d 2 -D/home/pgsql/data -N620 -B2048 -o -S65536 >> /home/pgsql/postgres.log 2> /home/pgsql/postgres.log

Next, to figure out what all the options mean.

Posted by stuartcw at June 16, 2003 01:07 PM
Comments