![]() |
Changes in postgres without restarting postgres
Hi all,
presently we are using postgreSql database. I had make changes in my config file, i don't want to restart again and again when ever i am making any changes in database. automatically this shuld be done! ex: for yahoo there will be 1000 clicks per sec, if they are rstarting their server frequently it will stop and then start. this is not the correct method! I am maintaing server with postgreSql database! plz help me |
If you are referring to configuration changes, then you can try something like
Code:
#/etc/init.d/postgresql reloadCode:
#service postgresql reload |
Hi reddazz, thks thats working but i found another bug,
the below is by pg_bha.conf file # TYPE DATABASE USER CIDR-ADDRESS METHOD # "local" is for Unix domain socket connections only local all all trust # IPv4 local connections: host nagesh venki 192.168.1.0/24 password here nagesh is database , venki is username and nagesh is password. but when i am loging into phpPgadmin, iam giving venki and wrong password ,still it is entering into database!! where is the security? plz help me! i have to do any more changes?? |
Unfortunately I can't help with the last questions, but maybe someone a bit more familiar with postgres will help out.
|
| All times are GMT -5. The time now is 11:40 AM. |