pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed"the database system is starting up"
8+ messages / 4 participants
[nested] [flat]
* "the database system is starting up"
@ 2010-04-12 11:43 Dennis Thrysøe <dth@geysirit.dk>
2010-04-12 12:03 ` Re: "the database system is starting up" Devrim GÜNDÜZ <devrim@gunduz.org>
0 siblings, 1 reply; 8+ messages in thread
From: Dennis Thrysøe @ 2010-04-12 11:43 UTC (permalink / raw)
To: pgsql-admin
Hi people,
I keep getting this message
"the database system is starting up" in the postgres log while system is running in archive recovery mode (warm standby).
Stops when system enters production mode.
I have checked network traffic, but there is none for port 5432. So it must be something local?
Thanks,
--
Geysir IT
dth@geysirit.dk
http://geysirit.dk
+45 31 51 60 00
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: "the database system is starting up"
2010-04-12 11:43 "the database system is starting up" Dennis Thrysøe <dth@geysirit.dk>
@ 2010-04-12 12:03 ` Devrim GÜNDÜZ <devrim@gunduz.org>
2010-04-12 13:19 ` Re: "the database system is starting up" Dennis Thrysøe <dth@geysirit.dk>
0 siblings, 1 reply; 8+ messages in thread
From: Devrim GÜNDÜZ @ 2010-04-12 12:03 UTC (permalink / raw)
To: Dennis Thrysøe <dth@geysirit.dk>; +Cc: pgsql-admin
On Mon, 2010-04-12 at 13:43 +0200, Dennis Thrysøe wrote:
>
> "the database system is starting up" in the postgres log while system
> is running in archive recovery mode (warm standby).
That is ok. pg_standby always waits for the next WAL , so it is always
in startup mode.
-HTH.
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Attachments:
signature.asc (application/pgp-signature, 197B) download
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: "the database system is starting up"
2010-04-12 11:43 "the database system is starting up" Dennis Thrysøe <dth@geysirit.dk>
2010-04-12 12:03 ` Re: "the database system is starting up" Devrim GÜNDÜZ <devrim@gunduz.org>
@ 2010-04-12 13:19 ` Dennis Thrysøe <dth@geysirit.dk>
2010-04-12 13:42 ` Re: "the database system is starting up" Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 1 reply; 8+ messages in thread
From: Dennis Thrysøe @ 2010-04-12 13:19 UTC (permalink / raw)
To: pgsql-admin; +Cc: Devrim GÜNDÜZ <devrim@gunduz.org>
On 12/04/2010, at 14.58, Devrim GÜNDÜZ wrote:
> On Mon, 2010-04-12 at 14:04 +0200, Dennis Thrysøe wrote:
>> I know, but a log line each second becomes a lot if the system is like
>> this for weeks at a time...
>
> Definitely a client app which is trying to connect to the server...
Yeah. Are there any good tools or logging options for determining who/what?
As mentioned it seems to be local as there is no traffic on TCP port 5432.
Thanks,
-dennis
--
Geysir IT
dth@geysirit.dk
http://geysirit.dk
+45 31 51 60 00
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: "the database system is starting up"
2010-04-12 11:43 "the database system is starting up" Dennis Thrysøe <dth@geysirit.dk>
2010-04-12 12:03 ` Re: "the database system is starting up" Devrim GÜNDÜZ <devrim@gunduz.org>
2010-04-12 13:19 ` Re: "the database system is starting up" Dennis Thrysøe <dth@geysirit.dk>
@ 2010-04-12 13:42 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-04-12 14:04 ` Re: "the database system is starting up" Ray Stell <stellr@cns.vt.edu>
2010-04-13 06:54 ` Re: "the database system is starting up" Dennis Thrysøe <dth@geysirit.dk>
0 siblings, 2 replies; 8+ messages in thread
From: Kevin Grittner @ 2010-04-12 13:42 UTC (permalink / raw)
To: Dennis Thrysøe <dth@geysirit.dk>; pgsql-admin; +Cc: devrim@gunduz.org
Dennis Thrysøe<dth@geysirit.dk> wrote:
> Are there any good tools or logging options for determining
> who/what?
Are you on a recent enough version to have log_connections and
log_disconnections available? If so, I would turn those on in
postgresql.conf.
-Kevin
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: "the database system is starting up"
2010-04-12 11:43 "the database system is starting up" Dennis Thrysøe <dth@geysirit.dk>
2010-04-12 12:03 ` Re: "the database system is starting up" Devrim GÜNDÜZ <devrim@gunduz.org>
2010-04-12 13:19 ` Re: "the database system is starting up" Dennis Thrysøe <dth@geysirit.dk>
2010-04-12 13:42 ` Re: "the database system is starting up" Kevin Grittner <Kevin.Grittner@wicourts.gov>
@ 2010-04-12 14:04 ` Ray Stell <stellr@cns.vt.edu>
1 sibling, 0 replies; 8+ messages in thread
From: Ray Stell @ 2010-04-12 14:04 UTC (permalink / raw)
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>; +Cc: Dennis Thrys?e <dth@geysirit.dk>; pgsql-admin; devrim@gunduz.org
On Mon, Apr 12, 2010 at 08:42:32AM -0500, Kevin Grittner wrote:
> Dennis Thrys?e<dth@geysirit.dk> wrote:
>
> > Are there any good tools or logging options for determining
> > who/what?
maybe turn off the port while you are in maintenance mode?
tcpdump should show you the host in question.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: "the database system is starting up"
2010-04-12 11:43 "the database system is starting up" Dennis Thrysøe <dth@geysirit.dk>
2010-04-12 12:03 ` Re: "the database system is starting up" Devrim GÜNDÜZ <devrim@gunduz.org>
2010-04-12 13:19 ` Re: "the database system is starting up" Dennis Thrysøe <dth@geysirit.dk>
2010-04-12 13:42 ` Re: "the database system is starting up" Kevin Grittner <Kevin.Grittner@wicourts.gov>
@ 2010-04-13 06:54 ` Dennis Thrysøe <dth@geysirit.dk>
2010-04-13 13:44 ` Re: "the database system is starting up" Kevin Grittner <Kevin.Grittner@wicourts.gov>
1 sibling, 1 reply; 8+ messages in thread
From: Dennis Thrysøe @ 2010-04-13 06:54 UTC (permalink / raw)
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>; +Cc: pgsql-admin; devrim@gunduz.org
On 12/04/2010, at 15.42, Kevin Grittner wrote:
> Dennis Thrysøe<dth@geysirit.dk> wrote:
>
>> Are there any good tools or logging options for determining
>> who/what?
>
> Are you on a recent enough version to have log_connections and
> log_disconnections available? If so, I would turn those on in
> postgresql.conf.
Yes, that tells me that connection attempts are from the local host on incrementing port numbers for each attempt.
Are there any tools that will help me figure out which process is doing this?
lsof -i and netstat -p gave me nothing...
Thanks,
-dennis
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: "the database system is starting up"
2010-04-12 11:43 "the database system is starting up" Dennis Thrysøe <dth@geysirit.dk>
2010-04-12 12:03 ` Re: "the database system is starting up" Devrim GÜNDÜZ <devrim@gunduz.org>
2010-04-12 13:19 ` Re: "the database system is starting up" Dennis Thrysøe <dth@geysirit.dk>
2010-04-12 13:42 ` Re: "the database system is starting up" Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-04-13 06:54 ` Re: "the database system is starting up" Dennis Thrysøe <dth@geysirit.dk>
@ 2010-04-13 13:44 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-04-13 13:46 ` Re: "the database system is starting up" Dennis Thrysøe <dth@geysirit.dk>
0 siblings, 1 reply; 8+ messages in thread
From: Kevin Grittner @ 2010-04-13 13:44 UTC (permalink / raw)
To: Dennis Thrysøe <dth@geysirit.dk>; +Cc: devrim@gunduz.org; pgsql-admin
Dennis Thrysøe<dth@geysirit.dk> wrote:
> Yes, that tells me that connection attempts are from the local
> host on incrementing port numbers for each attempt.
Is the user your database superuser? When I start a warm standby I
get one such message per second from pg_ctl for one minute; then
they stop. Yours keep going indefinitely?
If you are using pg_ctl, can you show us the *exact* command used
(specifically including the -t parameter, if used)? Does your
process list show any pg_ctl instances running while this is
happening?
-Kevin
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: "the database system is starting up"
2010-04-12 11:43 "the database system is starting up" Dennis Thrysøe <dth@geysirit.dk>
2010-04-12 12:03 ` Re: "the database system is starting up" Devrim GÜNDÜZ <devrim@gunduz.org>
2010-04-12 13:19 ` Re: "the database system is starting up" Dennis Thrysøe <dth@geysirit.dk>
2010-04-12 13:42 ` Re: "the database system is starting up" Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-04-13 06:54 ` Re: "the database system is starting up" Dennis Thrysøe <dth@geysirit.dk>
2010-04-13 13:44 ` Re: "the database system is starting up" Kevin Grittner <Kevin.Grittner@wicourts.gov>
@ 2010-04-13 13:46 ` Dennis Thrysøe <dth@geysirit.dk>
0 siblings, 0 replies; 8+ messages in thread
From: Dennis Thrysøe @ 2010-04-13 13:46 UTC (permalink / raw)
To: pgsql-admin
Hi,
There was no user involved, as far as I can see. The connection attempts are refused at the door :)
Mine kept going indefinitely, but by trial-and-error I found the application process causing the connection attempts.
Thanks for the input though.
-dennis
--
Geysir IT
dth@geysirit.dk
http://geysirit.dk
+45 31 51 60 00
On 13/04/2010, at 15.44, Kevin Grittner wrote:
> Dennis Thrysøe<dth@geysirit.dk> wrote:
>
>> Yes, that tells me that connection attempts are from the local
>> host on incrementing port numbers for each attempt.
>
> Is the user your database superuser? When I start a warm standby I
> get one such message per second from pg_ctl for one minute; then
> they stop. Yours keep going indefinitely?
>
> If you are using pg_ctl, can you show us the *exact* command used
> (specifically including the -t parameter, if used)? Does your
> process list show any pg_ctl instances running while this is
> happening?
>
> -Kevin
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2010-04-13 13:46 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-04-12 11:43 "the database system is starting up" Dennis Thrysøe <dth@geysirit.dk>
2010-04-12 12:03 ` Devrim GÜNDÜZ <devrim@gunduz.org>
2010-04-12 13:19 ` Dennis Thrysøe <dth@geysirit.dk>
2010-04-12 13:42 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-04-12 14:04 ` Ray Stell <stellr@cns.vt.edu>
2010-04-13 06:54 ` Dennis Thrysøe <dth@geysirit.dk>
2010-04-13 13:44 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2010-04-13 13:46 ` Dennis Thrysøe <dth@geysirit.dk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox