Re: [ADMIN] reinstall postgreSQL same version while server up and running possible under linux ?

2010-11-02 Thread Robert Gravsjö
Re-sending to list since I forgot to include it on reply. On 2010-11-02 13.59, Gerhard Hintermayer wrote: Sorry for posting this again, but my last post regarding this problematic wasn't answered satisfyingly. (maybe I didn't find the right words for my question ;-) ) is this (or a minor

Re: [ADMIN] pg_ident.conf not working?

2010-10-18 Thread Robert Gravsjö
Joe Brenner skrev 2010-10-16 22.49: Joe Brennerd...@kzsu.stanford.edu wrote: I've noticed a difference in postgresql 8.3 and 9.0.1 that I suspect is a bug. pg_ident.conf isn't working the way it used to. 8 -- snip --- Though I see it is indeed explained where it should be, I just

Re: [ADMIN] Handling of images via Postgressql

2010-04-09 Thread Robert Gravsjö
Suresh Borse skrev 2010-04-07 14.50: How does PostGreSQL perform in case we have to store and use huge no of images: Eg 4000 – 1 images, each approx 2 MB size. The Questions that we have are: How do we handle such huge no of images so that the application does not slow down? How

Re: [ADMIN] Socket TCP connections

2010-03-30 Thread Robert Gravsjö
Nilesh Govindarajan skrev 2010-03-29 04.04: Hi, it seems to be working now. Can somebody explain to me how ? See this pg_hba.conf - Did you reload the config, i.e pg_ctl reload, after making changes the first time? Regards, roppert # local is for Unix domain socket connections only

Re: [ADMIN] permissions on system catalogs for non-superuser?

2007-10-12 Thread Robert Gravsjö
Kevin Kempter wrote: Hi List; we have some monitoring/alert scripts which run sql against the database (8.1.4) as a non-superuser. The problem is I get insufficient privilege when trying to access current_query from pg_stat_activity. I ran these grant statements but still no joy: grant