Re: [ADMIN] graceful reload

2010-06-03 Thread Vasiliy G Tolstov
В Чтв, 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

Re: [ADMIN] graceful reload

2010-06-03 Thread 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" This will sort out which settings are in which category defini

Re: [ADMIN] graceful reload

2010-06-03 Thread Shoaib Mir
On Thu, Jun 3, 2010 at 6:01 PM, Vasiliy G Tolstov wrote: > > 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 exists co

Re: [ADMIN] graceful reload

2010-06-03 Thread Vasiliy G Tolstov
В Чтв, 03/06/2010 в 17:54 +1000, Shoaib Mir пишет: > On Thu, Jun 3, 2010 at 5:48 PM, Vasiliy G Tolstov > wrote: > Sorry for incorrect question. I mean: does postgresql can be > reloaded > without breaking current connections? > For example: > I need to incre

Re: [ADMIN] graceful reload

2010-06-03 Thread Shoaib Mir
On Thu, Jun 3, 2010 at 5:48 PM, Vasiliy G Tolstov wrote: > 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 running server, can

Re: [ADMIN] graceful reload

2010-06-03 Thread Vasiliy G Tolstov
В Чтв, 03/06/2010 в 14:45 +0700, Anh Ky Huynh пишет: > On Thu, 03 Jun 2010 10:23:36 +0400 > Vasiliy G Tolstov 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 gr

Re: [ADMIN] graceful reload

2010-06-03 Thread Anh Ky Huynh
On Thu, 03 Jun 2010 10:23:36 +0400 Vasiliy G Tolstov 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 Yo

[ADMIN] graceful reload

2010-06-02 Thread Vasiliy G Tolstov
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 Selfip.Ru -- Sent via pgsql-admin mailing li