On Thu, Dec 19, 2002 at 06:01:35PM +0530, Ajay wrote:
>Hi,
>
>When I tried to createuser, I got the message user 'root'
>not in 'pg_shadow'. How do I create the first user?
>
>Frankly I haven't read most of the help files, but please
>help ;-)
Reading the docs would have solved most of your problems :-)
Don't create postgres user from root login.
First login as postgres and than createuser.
The createuser script asks you question whether the concerned use should
be allowed to create new users and create databases. Say 'yes' than you
can do anything the postgres user can do from the newly created user.
Remember not to give every user this priviledge.
Peace
--
Rajesh
:
####[ GNU/Linux One Stanza Tip (LOST) ]#######################
Sub : Simple backup system (with tar) LOST #302
The simplest method is to make a listfile | Sample listfile:
containing what all you want to back up, |
and do: | /etc/passwd
tar -czvf backup.tar.gz -T listfile | /etc/group
[man tar for details of -T option] | /home/joe/project
####<[EMAIL PROTECTED]>####################################
:
-------------------------------------------------------
This SF.NET email is sponsored by: Geek Gift Procrastinating?
Get the perfect geek gift now! Before the Holidays pass you by.
T H I N K G E E K . C O M http://www.thinkgeek.com/sf/
_______________________________________________
linux-india-help mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/linux-india-help
