LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - General (http://www.linuxquestions.org/questions/linux-general-1/)
-   -   Changes in postgres without restarting postgres (http://www.linuxquestions.org/questions/linux-general-1/changes-in-postgres-without-restarting-postgres-570336/)

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


All times are GMT -5. The time now is 03:01 AM.