Received: from post.webmailer.de (natwar.webmailer.de [192.67.198.70]) by postgresql.org (Postfix) with ESMTP id 57844475D82 for ; Sun, 17 Mar 2002 09:38:28 -0500 (EST) Received: from eumel.yoo.net (p50859C52.dip.t-dialin.net [80.133.156.82]) by post.webmailer.de (8.9.3/8.8.7) with ESMTP id PAA07107 for ; Sun, 17 Mar 2002 15:38:28 +0100 (MET) Received: by eumel.yoo.net (Postfix on SuSE Linux 7.2 (i386), from userid 500) id 4B6ED1262C; Sun, 17 Mar 2002 15:53:16 +0100 (CET) Date: Sun, 17 Mar 2002 15:53:16 +0100 From: Thorsten Haude To: PostgreSQL Novice ML Subject: Re: create database, user Message-ID: <20020317145316.GC963@eumel.yoo.net> Mail-Followup-To: PostgreSQL Novice ML References: <20020310200445.GT808@eumel.yoo.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.3.24i X-Warning: Email may contain unsmilyfied humor and/or satire. Keywords: Netz gegen Kinderporno Organization: Ministry of Information, Department of Works X-Archive-Number: 200203/151 X-Sequence-Number: 3278 Hi, * Josh Berkus [02-03-10 20:58]: >> The other problem is a password though. I changed one line in your >> example to: >> CREATE USER junk_user encrypted password 'secret'; >> And it fails: >> ERROR: parser: parse error at or near "encrypted" >> What's wrong here? >You're probably using PostgreSQL 7.1, or you compiled PostgreSQL 7.2 > without current encryption libraries installed on your machine. Indeed, I use 7.1 and was not aware that encrypted passwords are a new feature of 7.2. I should have checked more carefully. So I will rather install 7.2 right away instead of upgrading later. Let's see where that will get me. Thanks a lot! Thorsten -- Auch Hunger ist Krieg. - Willy Brandt