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 6BC0432A060 for ; Sun, 3 Oct 2004 06:45:49 +0100 (BST) 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 75243-09 for ; Sun, 3 Oct 2004 05:45:44 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 6B282329EFF for ; Sun, 3 Oct 2004 06:45:44 +0100 (BST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id i935jhmR029104; Sun, 3 Oct 2004 01:45:43 -0400 (EDT) To: Michael Long Cc: pgsql-admin@postgresql.org Subject: Re: Users and multiple server environment In-reply-to: <415F8EC5.9040504@datalong.com> References: <415F87D7.5000800@datalong.com> <28880.1096780739@sss.pgh.pa.us> <415F8EC5.9040504@datalong.com> Comments: In-reply-to Michael Long message dated "Sun, 03 Oct 2004 01:31:49 -0400" Date: Sun, 03 Oct 2004 01:45:42 -0400 Message-ID: <29103.1096782342@sss.pgh.pa.us> From: Tom Lane 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: 200410/61 X-Sequence-Number: 15054 Michael Long writes: > I had just discovered that I need to specify the port when creating a > database. I had thought that I had read in the documentation that if I > built the server from source and specified the port to use that the > client would be bound to that by default. The client *that you built along with the server* will bind to that port by default. It's not going to somehow magically propagate to other clients built with other default port numbers. The default port number on the client side is actually built into libpq, not psql. So one possible explanation if you think you've covered the obvious bases is that you're invoking the correct version-specific psql programs, but they are all binding to the same libpq.so. Check LD_LIBRARY_PATH, ldconfig configuration, etc. regards, tom lane