Hello all,
I forgot to mention the version of Postgresql I am using ... it is 7.3.2.
Thanks.
Regards,
Partha Sur
(Somerset, NJ 08873, USA)
----- Original Message -----
From: "Partha Sur" <p.sur@worldnet.att.net>
To: <pgsql-novice@postgresql.org>
Sent: Friday, September 26, 2003 11:27 PM
Subject: createuser problem
> Hello,
>
> I am new to PostgreSQL (but not new to SQL; I am an experienced Oracle
> Programmer). Any help to resolve my problem will be greatly appreciated.
>
> I am trying to create a new database user and use PostgreSQL server from
> this account and not the "postgres" (supervisor) userid. I fail to do
this.
> Please tell me how to do this successfully. Many thanks.
>
> Logged in to Red Hat Linux 9.0 as root.
>
> Tried to start postgresql server from "postgres" userid (as suggested in
> "Beginning Databases with Postgresql" - Stones & Matthew).
> I used the supplied init script called /etc/rc.d/init.d/postgresql. I
did
> not use pg_ctl to start the server.
>
> [root@localhost root] su - postgres
> -bash-2.05b$
> -bash-2.05b$ /etc/rc.d/init.d/postgresql start
> starting postgresql service: standard in must be a tty [FAILED]
> -bash-2.05b$
>
> Ah well ... maybe I have to do this from ~root (as shown in "Postgresql
> Developer's Handbook" - Geshwinde & Schonig) - I wish these authors would
> make their mind up ...
>
> -bash-2.05b$ exit
>
> [root@localhost root] /etc/rc.d/init.d/postgresql start
> starting postgresql service [OK]
> [root@localhost root]
>
> SUCCESS !
>
> (By the way I did not see anywhere in the /etc/rc.d/init.d/postgresql
script
> the executable initdb is executed ... where is this done ? Or is not
> required ?)
>
> [root@localhost root] su - postgres
> -bash-2.05b$
>
> Create database "mytest"
>
> -bash-2.05b$ createdb mytest
> CREATE DATABASE
> -bash-2.05b$
>
> Check new database created
>
> -bash-2.05b$ psql -l
>
> List of databases
> Name | Owner | Encoding
> -------------------------------------
> mytest | postgres | SQL_ASCII
> template0 | postgres | SQL_ASCII
> template1 | postgres | SQL_ASCII
>
> (3 rows)
> -bash-2.05b$
>
> Create new database user "psur"
>
> -bash-2.05b$ createuser -d -P psur
> Enter password for user "psur"
> Enter it again:
> Shall the new user be allowed to create more new users ? (y/n) n
> CREATE USER
> -bash-2.05b$
>
> Check that PostgreSQL user "psur" has been created
>
> -bash-2.05b$ psql mytest
> Welcome to psql ...
> ...
> mytest=#
> mytest=# select * from pg_user ;
>
> usename | usesysid | ...
> ----------------------------
> postgres | ...
> psur | ...
>
> (2 rows)
>
> mytest=#
> mytest=# \q
>
> Now try to connect to database "mytest" as user "psur"
>
> -bash-2.05b$ psql -U psur mytest
> psql:FATAL:IDENT authentication failed for user "psur"
> -bash-2.05b$
>
> Perhaps database user "psur" not allowed to attach to database "mytest"
> (which was created under CURRENT_USER = "postgres") ... Is this true ?
>
> In that case ... try to create database "psurtest" so that user "psur" can
> connect to it.
>
> -bash-2.05b$ createdb -U psur psurtest
> psql:FATAL:IDENT authentication failed for user "psur"
> createdb: database creation failed.
> -bash-2.05b$
>
> HELP !
>
> Although the user "psur" seems to be successfully created, I AM UNABLE TO
> LOG IN TO Postgresql server under "psur" userid. (I only want to use
> "postgres" userid to do DBA type work.)
>
> Please help. Thanks again.
>
> Regards,
>
> Partha Sur
>
>
>
>