Re: create database, user

From: Thorsten Haude <postgresql(at)thorstenhau(dot)de>
To: PostgreSQL Novice ML <pgsql-novice(at)postgresql(dot)org>
Subject: Re: create database, user
Date: 2002-03-17 14:53:16
Message-ID: 20020317145316.GC963@eumel.yoo.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice pgsql-php

Hi,

* Josh Berkus <josh(at)agliodbs(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Thorsten Haude 2002-03-17 16:43:50 Re: create database, user
Previous Message Josh Berkus 2002-03-16 21:10:31 Re: Function problem

Browse pgsql-php by date

  From Date Subject
Next Message Thorsten Haude 2002-03-17 16:43:50 Re: create database, user
Previous Message ameen eetemadi 2002-03-17 13:32:26 postgres array type