Re: graceful reload

From: "Anh Ky Huynh" <xkyanh(at)gmail(dot)com>
To: v(dot)tolstov(at)selfip(dot)ru
Cc: PostgreSQL Admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: graceful reload
Date: 2010-06-03 07:45:28
Message-ID: 20100603144528.2234301e@icy.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, 03 Jun 2010 10:23:36 +0400
Vasiliy G Tolstov <v(dot)tolstov(at)selfip(dot)ru> wrote:

> Hello.
>
> I'm use linux and postgresql under xen vps. Vps supports memory
> balloon (i need to increase memory some time). Can postgresql
> server has ability to graceful reload itself after it configuration
> files changed? Thank You.

I'm afraid *NOT*. You can write a script / cronjob for this task. The script will check postgresql periodically and will restart posgresql daemon in case the configuration was changed. You can use `stat` command (try `stat --help`) to get the right information about file's modifcation. You should *check* if your configuration is valid before restart the daemon as any wrong modification can cause your server to stop :)

I know there's a tool that will do some tasks whenever a(ny) file in the system has been modified. But I can't remember the name of that tool.

Regards,

--
Anh Ky Huynh

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Vasiliy G Tolstov 2010-06-03 07:48:23 Re: graceful reload
Previous Message Vasiliy G Tolstov 2010-06-03 06:23:36 graceful reload