Re: BUG #1926: /etc/init.d/postgresql - script version 7.4.5 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1926: /etc/init.d/postgresql - script version 7.4.5
Date
Msg-id 20729.1128090661@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #1926: /etc/init.d/postgresql - script version 7.4.5  (Devrim GUNDUZ <devrim@gunduz.org>)
List pgsql-bugs
Devrim GUNDUZ <devrim@gunduz.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

pgsql-bugs by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: BUG #1925: upper() and lower() fails with non-english char.
Next
From: Steve Peterson
Date:
Subject: Bug?: Text after right paren in query is ignored