"the database system is starting up"

Hi people,

I keep getting this message=20

"the database system is starting up" in the postgres log while system is ru=
nning in archive recovery mode (warm standby).

Stops when system enters production mode.=20

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


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: "the database system is starting up"

--=-8J8sZuaw63HSF8HPdAvl
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Mon, 2010-04-12 at 13:43 +0200, Dennis Thrysøe wrote:
>=20
> "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.
--=20
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

--=-8J8sZuaw63HSF8HPdAvl
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iEYEABECAAYFAkvDDAEACgkQtl86P3SPfQ7pCQCfdeM79K0ObCcprgqCyuPG 0ff4
G54AoLVyxpcrMJ8IwsvcFF8o5DRkSS7I
=H+MY
-----END PGP SIGNATURE-----

--=-8J8sZuaw63HSF8HPdAvl--

Re: "the database system is starting up"

On 12/04/2010, at 14.58, Devrim GÜNDÜZ wrote:
> On Mon, 2010-04-12 at 14:04 +0200, Dennis Thrys=F8e wrote:
>> I know, but a log line each second becomes a lot if the system is like
>> this for weeks at a time...
>=20
> 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


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: "the database system is starting up"

Dennis Thrys=F8e wrote:
=20
> Are there any good tools or logging options for determining
> who/what?
=20
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.
=20
-Kevin

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: "the database system is starting up"

On Mon, Apr 12, 2010 at 08:42:32AM -0500, Kevin Grittner wrote:
> Dennis Thrys?e 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.

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: "the database system is starting up"

On 12/04/2010, at 15.42, Kevin Grittner wrote:
> Dennis Thrys=F8e wrote:
>=20
>> Are there any good tools or logging options for determining
>> who/what?
>=20
> 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 incr=
ementing port numbers for each attempt.

Are there any tools that will help me figure out which process is doing thi=
s?=20

lsof -i and netstat -p gave me nothing...

Thanks,

-dennis
--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: "the database system is starting up"

Dennis Thrys=F8e wrote:=20
=20
> Yes, that tells me that connection attempts are from the local
> host on incrementing port numbers for each attempt.
=20
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?
=20
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?
=20
-Kevin

--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: "the database system is starting up"

Hi,

There was no user involved, as far as I can see. The connection attempts ar=
e refused at the door :)

Mine kept going indefinitely, but by trial-and-error I found the applicatio=
n 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=F8e wrote:=20
>=20
>> Yes, that tells me that connection attempts are from the local
>> host on incrementing port numbers for each attempt.
>=20
> 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?
>=20
> 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?
>=20
> -Kevin


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin