Hi people,

I keep getting this message

"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.

I have checked network traffic, but there is none for port 5432. So it must=
be something local?

Thanks,


--
Geysir IT
dth [at] geysirit.dk
http://geysirit.dk
+45 31 51 60 00


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

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

On Mon, 2010-04-12 at 13:43 +0200, Dennis Thrys=C3=B8e 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=C3=9CND=C3=9CZ
PostgreSQL Dan=C4=B1=C5=9Fman=C4=B1/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--

On 12/04/2010, at 14.58, Devrim G=DCND=DCZ 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...
>
> 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 [at] geysirit.dk
http://geysirit.dk
+45 31 51 60 00


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

Dennis Thrys=F8e<dth [at] 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

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

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

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

On 12/04/2010, at 15.42, Kevin Grittner wrote:
> Dennis Thrys=F8e<dth [at] 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 incr=
ementing port numbers for each attempt.

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

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

Thanks,

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

Dennis Thrys=F8e<dth [at] 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

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

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 [at] geysirit.dk
http://geysirit.dk
+45 31 51 60 00

On 13/04/2010, at 15.44, Kevin Grittner wrote:

> Dennis Thrys=F8e<dth [at] 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


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