Thread: Default Ubuntu post-install Qs (PG v7.4)

Default Ubuntu post-install Qs (PG v7.4)

From
Ralph Smith
Date:
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
=====================


Re: Default Ubuntu post-install Qs (PG v7.4)

From
"Andrej Ricnik-Bay"
Date:
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.

http://www.american.edu/econ/notes/htmlmail.htm