Re: create database, user - Mailing list pgsql-novice

From Thorsten Haude
Subject Re: create database, user
Date
Msg-id 20020317145316.GC963@eumel.yoo.net
Whole thread Raw
In response to Re: create database, user  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-novice
Hi,

* Josh Berkus <josh@agliodbs.com> [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

pgsql-novice by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: Function problem
Next
From: Thorsten Haude
Date:
Subject: Re: create database, user