В Чтв, 03/06/2010 в 13:07 -0400, Greg Smith пишет:
Vasiliy G Tolstov wrote:
In config file some in of this settings exists comment line like
changes require restart. This is mean exactly restart or reload can do
this?
Run this:
$ psql -c select name,context from pg_settings
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.
--
Vasiliy G Tolstov v.tols...@selfip.ru
Selfip.Ru
--
Sent via
On Thu, 03 Jun 2010 10:23:36 +0400
Vasiliy G Tolstov v.tols...@selfip.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
В Чтв, 03/06/2010 в 14:45 +0700, Anh Ky Huynh пишет:
On Thu, 03 Jun 2010 10:23:36 +0400
Vasiliy G Tolstov v.tols...@selfip.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
On Thu, Jun 3, 2010 at 5:48 PM, Vasiliy G Tolstov v.tols...@selfip.ruwrote:
Sorry for incorrect question. I mean: does postgresql can be reloaded
without breaking current connections?
For example:
I need to increate some values in postgresql conf file and want to this
valies applied on
В Чтв, 03/06/2010 в 17:54 +1000, Shoaib Mir пишет:
On Thu, Jun 3, 2010 at 5:48 PM, Vasiliy G Tolstov
v.tols...@selfip.ru wrote:
Sorry for incorrect question. I mean: does postgresql can be
reloaded
without breaking current connections?
For example:
I
On Thu, Jun 3, 2010 at 6:01 PM, Vasiliy G Tolstov v.tols...@selfip.ruwrote:
Memory related:
max_connections
shared_buffers
temp_buffers
max_prepared_transactions
work_mem
maintenance_work_mem
max_stack_depth
max_files_per_process
wal_buffers
In config file some in of this settings
Vasiliy G Tolstov wrote:
In config file some in of this settings exists comment line like
changes require restart. This is mean exactly restart or reload can do
this?
Run this:
$ psql -c select name,context from pg_settings
This will sort out which settings are in which category