Return-Path: owner-postman Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id HAA16676 for postgres-dist; Thu, 10 Mar 1994 07:18:03 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199403101518.HAA16676@nobozo.CS.Berkeley.EDU> X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from cheviot.ncl.ac.uk (cheviot.ncl.ac.uk [128.240.2.10]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id HAA16667 for ; Thu, 10 Mar 1994 07:18:00 -0800 Received: from bowes.ncl.ac.uk by cheviot.ncl.ac.uk id (5.65cVUW/NCL-CMA.1.35 for ) with SMTP; Thu, 10 Mar 1994 15:17:48 GMT From: "David Alan Nelson" Message-Id: Subject: Setting up id's To: postgres@postgres.Berkeley.EDU (Postgres) Date: Thu, 10 Mar 1994 15:17:42 +0000 (GMT) X-Mailer: ELM [version 2.4 PL23] Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Length: 910 Resent-To: postgres-dist@postgres.Berkeley.EDU Resent-Date: Thu, 10 Mar 94 07:18:03 -0800 Resent-XMts: smtp Hi All I hope someone can help me. Postgres has just been installed on our system, and I've been given the job of administering it. I've started setting up user id's for using the system, but am unable to get a list of people I have registered. I've tried using the retrieve command as illustrated in the installation instructions 'retrieve (u.usename, u.usesysid) from u in pg_user' from the monitor program when logged in as postgres, but this just fails and says the database is non-existent. Presumably the monitor can not pick up these files, only those in the /data/base directory (it took a day to find this!), and therefore I can't see of any way to access this database. So can someone please tell me whether I can get a list of registered postgres users! Cheers Dave Nelson -- Mail ID : D.A.Nelson@newcastle.ac.uk Computing Science, University of Newcastle upon Tyne, UK. (091) 222 8789