Discussion:
unable to add users
(too old to reply)
Pradeepkumar, Pyatalo (IE10)
2004-09-21 12:00:18 UTC
Permalink
Hi all,
I was just trying to add some users to my database....i followed the
createuser help and gave the following command
[root]#/usr/local/pgsql/bin/createuser -ADe epsadmin
I get the following error.....
createuser: could not connect to database template1: FATAL: could not open
file "/usr/local/pgsql/data/global/1262": Permission denied

Any help on this really appreciable.

With Best Regards,
Pradeep Kumar P.J


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Tom Lane
2004-09-21 14:10:50 UTC
Permalink
Post by Pradeepkumar, Pyatalo (IE10)
I get the following error.....
createuser: could not connect to database template1: FATAL: could not open
file "/usr/local/pgsql/data/global/1262": Permission denied
Looks like you started the postmaster as the wrong user (ie, not the
account that owns the database files).

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ***@postgresql.org)
Loading...