Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-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

pgsql-novice by date

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

pgsql-php by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group