Kevin,
Thank you for the reply.
I guess 60Sec is a valid option if this is the 'time period' we can tolerate.
PS pg_clearxlogtail I tried to lookup more info about it but could not find
much.
With regards to pglesslog I found the site which hosts the project, seems
interesting.
My question is
Hi Kevin,
I actually just realised I did not specifically said "Systems Administrator"
and this is what I was refereeing to.
Systems Admin x DBA.
Renato
Renato Oliveira
Systems Administrator
e-mail: renato.olive...@grant.co.uk
Tel: +44 (0)1763 260811
Fax: +44 (0)1763 262410
http://www.grant
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
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
I need to disconnect user in my database without creating inconsistencies. What
command should I use.
Grateful
Eduardo
2010/4/12 Eduardo Sá dos Reis :
> I need to disconnect user in my database without creating inconsistencies.
> What command should I use.
If you are using 8.4 then you can do pg_terminate_backend(pid)
function. For more info read
http://www.postgresql.org/docs/8.4/interactive/functions-admin.html
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
On 12-Apr-2010, at 6:00 PM, Eduardo Sá dos Reis wrote:
> I need to disconnect user in my database without creating inconsistencies.
> What command should I use.
>
> Grateful
>
> Eduardo
Which Version of PostgreSQL are you using?
In PostgreSQL 8.4, you can use pg_terminate_backend() functio
Dennis Thrysøe 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-a
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-adm
Hi,
I'm new on using SSL in PostgreSQL.
I've created a self-signed certificate using openssl and started the server
with ssl suport.
But I have some question, can you help me?
- There is any parameter to configure the path (and name) to certificate
(server.crt) and private key (server.key) like
Hi,
I'm new on using SSL in PostgreSQL.
I've created a self-signed certificate using openssl and started the server
with ssl suport.
But I have some question, can you help me?
- There is any parameter to configure the path (and name) to certificate
(server.crt) and private key (server.key) like
On 12/04/2010, at 15.42, Kevin Grittner wrote:
> Dennis Thrysøe 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.con
13 matches
Mail list logo
