-   Linux - General (
-   -   Changes in postgres without restarting postgres (

venki 07-18-2007 04:18 AM

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

reddazz 07-18-2007 07:43 AM

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

#/etc/init.d/postgresql reload
If you run Redhat or related distros

#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


# "local" is for Unix domain socket connections only
local all all trust

# IPv4 local connections:
host nagesh venki 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.

All times are GMT -5. The time now is 11:40 PM.