Re: Creating users in a second postgres server.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: skennedy(at)tissat(dot)es
Cc: "[ADMIN]" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Creating users in a second postgres server.
Date: 2003-11-05 15:18:02
Message-ID: 2070.1068045482@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"skennedy" <skennedy(at)tissat(dot)es> writes:
> however, when I try and create a user I get
> bash-2.03$ createuser idip_734
> Shall the new user be allowed to create databases? (y/n) y
> Shall the new user be allowed to create more new users? (y/n) n
> psql: FATAL 1: user "p_sql734" does not exist

Looks to me like you are talking to the old server. Perhaps you have
PGPORT set to 5432 in your environment? Or you got your PATH wrong,
so that you are invoking the older copy of createuser, which will
naturally default to port 5432?

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message skennedy 2003-11-05 15:35:44 Re: Creating users in a second postgres server.
Previous Message Marek Florianczyk 2003-11-05 15:14:59 Re: performance problem - 10.000 databases