Re: BUG #1926: /etc/init.d/postgresql - script version 7.4.5

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Devrim GUNDUZ <devrim(at)gunduz(dot)org>
Cc: Kevin Waldron <kevin(at)zazzybob(dot)com>, pgsql-bugs(at)postgresql(dot)org, pgsqlrpms-hackers(at)postgresql(dot)org
Subject: Re: BUG #1926: /etc/init.d/postgresql - script version 7.4.5
Date: 2005-09-30 14:31:01
Message-ID: 20729.1128090661@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Devrim GUNDUZ <devrim(at)gunduz(dot)org> writes:
> See : https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=152931

> I've increased the sleep time from 1 to 2 for PGDG 8.1 beta RPMs. Let's
> see what will happen in next beta.

I've been using 2 in Red Hat's RPMs for some time. The whole thing is
pretty mystifying though, because there's no way it should take any
significant amount of time for the postmaster to get to the point of
writing its pid-file. It doesn't really do anything except parse its
command-line arguments and the postgresql.conf file before it does that.
I've certainly never been able to reproduce the problem.

It'd be useful to try running the "su" command that launches the
postmaster under "strace -f -tt" to try to gather some information
about why it's so slow. It might be the su rather than the postmaster
per se that's at fault?

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2005-09-30 14:58:40 Re: Bug?: Text after right paren in query is ignored
Previous Message Devrim GUNDUZ 2005-09-30 14:16:04 Re: BUG #1926: /etc/init.d/postgresql - script version 7.4.5