Postgres Pro
Downloads
Home   >   mailing lists

Re: Creating users in a second postgres server. - Mailing list pgsql-admin

From Tom Lane
Subject Re: Creating users in a second postgres server.
Date
Msg-id 2070.1068045482@sss.pgh.pa.us
Whole thread Raw
In response to Creating users in a second postgres server.  ("skennedy" <skennedy@tissat.es>)
Responses Re: Creating users in a second postgres server.  ("skennedy" <skennedy@tissat.es>)
List pgsql-admin
Tree view 
"skennedy" <skennedy@tissat.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

pgsql-admin by date:

Previous
From: Jeff
Date:
Subject: Re: performance problem - 10.000 databases
Next
From: Marek Florianczyk
Date:
Subject: Re: performance problem - 10.000 databases