LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices

Reply
 
Search this Thread
Old 07-18-2007, 04:18 AM   #1
venki
Member
 
Registered: Sep 2006
Location: India
Distribution: suse10.2
Posts: 128

Rep: Reputation: 15
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
 
Old 07-18-2007, 07:43 AM   #2
reddazz
Guru
 
Registered: Nov 2003
Location: N. E. England
Distribution: Fedora, CentOS, Debian
Posts: 16,298

Rep: Reputation: 73
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
 
Old 07-19-2007, 12:26 AM   #3
venki
Member
 
Registered: Sep 2006
Location: India
Distribution: suse10.2
Posts: 128

Original Poster
Rep: Reputation: 15
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??
 
Old 07-19-2007, 01:06 AM   #4
reddazz
Guru
 
Registered: Nov 2003
Location: N. E. England
Distribution: Fedora, CentOS, Debian
Posts: 16,298

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


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Postgres Hiper1 Linux - Newbie 8 04-10-2005 05:43 PM
postgres and mysql varun_33 Linux - Software 1 02-12-2005 07:54 AM
Postgres DBMS??! Hady Linux - Newbie 4 04-27-2004 03:19 PM
starting postgres 7.2.2 lolmc Linux - Software 4 02-26-2003 03:30 PM
postgres connect richard22 Linux - Software 4 01-29-2003 12:42 PM


All times are GMT -5. The time now is 04:06 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration