X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1FCA63A4114 for ; Wed, 10 Nov 2004 15:19:58 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 84446-04 for ; Wed, 10 Nov 2004 15:19:42 +0000 (GMT) Received: from dobber.bastun.net (dobber.bastun.net [213.222.51.199]) by svr1.postgresql.org (Postfix) with ESMTP id 607EC3A3BE1 for ; Wed, 10 Nov 2004 15:19:44 +0000 (GMT) Received: from dobber.bastun.net (dobber@localhost [127.0.0.1]) by dobber.bastun.net (8.13.1/8.13.1/Debian-16) with ESMTP id iAAFJqmR030533 for ; Wed, 10 Nov 2004 17:19:52 +0200 Received: from localhost (localhost [[UNIX: localhost]]) by dobber.bastun.net (8.13.1/8.13.1/Submit) id iAAFJq8p030530 for pgsql-admin@postgresql.org; Wed, 10 Nov 2004 17:19:52 +0200 X-Authentication-Warning: dobber.bastun.net: dobber set sender to dobber@bastun.net using -f From: Ivan Dimitrov Reply-To: dobber@bastun.net To: pgsql-admin@postgresql.org Subject: Re: nscd [was] how do you run postgres without dns server Date: Wed, 10 Nov 2004 17:19:47 +0200 User-Agent: KMail/1.7 References: <200411101145.24279.dobber@bastun.net> <200411101215.42767.dobber@bastun.net> <1100095687.29685.89.camel@linda> In-Reply-To: <1100095687.29685.89.camel@linda> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart1428354.qZydxfQv6f"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200411101719.52463.dobber@bastun.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/92 X-Sequence-Number: 15477 --nextPart1428354.qZydxfQv6f Content-Type: text/plain; charset="windows-1251" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Yes that is true too. I've checked it all. It apears that postgres tries to= =20 resolve only through dns'...:( I think that the problem is in the postgresql, but I can't reproduce the=20 problem anymore, because I was forced to install a caching dns server, and= =20 I'm not allowed to play with it anymore (business must run). The nscd problem: I didn't post this before, because I thik this is not a postgres related=20 problem, but after a few hours playing with it I couldn't fix the problem I have nscd + pgsql backend I have=20 passwd: compat [NOTFOUND=3Dcontinue SUCCESS=3Dreturn] pgsql group: compat [NOTFOUND=3Dcontinue SUCCESS=3Dreturn] pgsql in /etc/nsswitch.conf The logic of this, from what I could understand from the documentation is: "Look in the standart files (/etc/passwd, /etc/group)" for username and=20 groups, if not found, search in pgsql databasee, else return successfull" The problem is that when I stop the database and I try to `id realuser` it= =20 gives: # id root Could not connect to database The system is Debian sarge with packages: nscd 2.3.2.ds1-18 libnss-pgsql1 1.0.2-1.2=20 postgresql 7.4.5-3 =CD=E0 10.11.2004 16:08 Oliver Elphick =ED=E0=EF=E8=F1=E0: > On Wed, 2004-11-10 at 12:15 +0200, Ivan Dimitrov wrote: > > Yes, it is there > > 127.0.0.1 localhost > > 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. =2D-=20 Hi! I'm your friendly neighbourhood signature virus. Copy me to your signature file and help me spread! --nextPart1428354.qZydxfQv6f Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (GNU/Linux) iD8DBQBBkjGYKBhoPewcguwRAlcqAJ44JJ44s4ORn1QRv7E3AnWyyR8/lwCfUE1A NoAHTCdoHK6AlsFvWF0gThA= =GQpJ -----END PGP SIGNATURE----- --nextPart1428354.qZydxfQv6f--