Default Ubuntu post-install Qs (PG v7.4)
1) Am I right when I assume an init.d type of start/kill scenario is
used?
2) The ps -ef shows the process:
/usr/lib/postgresql/7.4/postmaster -D /var/lib/postgresql/7.4/main
postgres: stats buffer process
postgres: stats collector process
I see no logfile explicitly defined. Where is that specified?
3) In /var/log/postgresql I am getting logging, but not enough. How
can I get more details?
4) User postgres keeps getting the following showing up:
postgres@smithrn-ltb2:/tmp$ 2007-10-08 20:02:01 LOG: incomplete
startup packet
2007-10-08 20:07:29 LOG: recycled transaction log file
"000000010000007D"
2007-10-09 00:02:02 LOG: incomplete startup packet
2007-10-09 05:02:01 LOG: incomplete startup packet
2007-10-09 10:02:01 LOG: incomplete startup packet
Thank you!
Ralph Smith
smithrn@u.washington.edu
=====================
On 10/11/07, Ralph Smith <smithrn@u.washington.edu> wrote:
1) Am I right when I assume an init.d type of start/kill scenario is used?
Aye
2) The ps -ef shows the process:
/usr/lib/postgresql/7.4/postmaster -D
/var/lib/postgresql/7.4/main
postgres: stats buffer process
postgres: stats collector process
I see no logfile explicitly defined. Where is that specified?
Have a look in
/etc/postgresql/7.4/main/postgresql.conf
3) In /var/log/postgresql I am getting logging, but not enough. How can I
get more details?
See above. Specifically postgresql.conf
Thank you!
Ralph Smith
Cheers,
Andrej
--
Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.