Changes in postgres without restarting postgres

venki · 07-18-2007, 04:18 AM

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

reddazz · 07-18-2007, 07:43 AM

If you are referring to configuration changes, then you can try something like

Code:

#/etc/init.d/postgresql reload

If you run Redhat or related distros

Code:

#service postgresql reload

venki · 07-19-2007, 12:26 AM

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??

reddazz · 07-19-2007, 01:06 AM

Unfortunately I can't help with the last questions, but maybe someone a bit more familiar with postgres will help out.