[ADMIN] how do you run postgres without dns server

2004-11-10 Thread Ivan Dimitrov
I have a database on a machine that does not know what localhost is. Yes, I have 127.0.0.1, but I can't resolve localhost to it. I don't want to start a caching dns, and don't want to change resolve.conf. Upon starting, postgres gives error cannot bind to localhost. then starts accepting

Re: [ADMIN] how do you run postgres without dns server

2004-11-10 Thread Ivan Dimitrov
Yes, it is there 127.0.0.1localhost but when i strace postmaster on startup it never looks in /etc/hosts 10.11.2004 12:05 : localhost should be defined in your hosts file, which in most unixoid environments is /etc/hosts. It is not an error. Hal On Wed, 10 Nov 2004, Ivan Dimitrov

Re: [ADMIN] nscd [was] how do you run postgres without dns server

2004-11-10 Thread Ivan Dimitrov
-10 at 12:15 +0200, Ivan Dimitrov wrote: Yes, it is there 127.0.0.1localhost but when i strace postmaster on startup it never looks in /etc/hosts Look at the hosts: line in /etc/nsswitch.conf. It needs to have the word files in there. -- Hi! I'm your friendly neighbourhood

[ADMIN] pg_autovacuum is not working

2004-10-29 Thread Ivan Dimitrov
Hi list This is my first post here, and I've searched google but couldn't find the solution. I'm trying to run pg_autovacuum on all my databases. All my Debian sarge machines use version 7.4.5-3 postgresql install postgresql-client

Re: [ADMIN] pg_autovacuum is not working

2004-10-29 Thread Ivan Dimitrov
The problem was in my resolve.conf, the nameserver I've set is my datacenter provider who have localhost.provider.net point to 127.0.0.1 and postmaster couldn't bind to that host. For whatever reason. It does not check /etc/hosts too so I'll play with it on Mondey. 29.10.2004 18:20 : Ivan