On Fri, Aug 03, 2001 at 11:33:59AM +0800, Emerson P. Oatis wrote:
> pano ko i-aadd ang username sa postgres.. i mean yong trusted user
> to use the database.. sang file doon? sa pg_shadow? or pg_pwd?, kasi pag
> e-nedit mo naman yong pg_shadow eh garbage... ;(, pano po ba yon mga bro..
> and sis.. thankz for the help ;)
As the postgres user or any other trusted user, you can use the
createuser script.
Or in psql you can use:
CREATE USER foo [WITH
[SYSID uid]
[PASSWORD 'password'] ]
[CREATEDB | NOCREATEDB] [ CREATEUSER | NOCREATEUSER]
[ IN GROUP groupname [, ...] ]
[ VALID UNTIL 'abstime' ]
H'wag mong galawin yun pg_shadow o pg_pwd system tables kung hindi mo
sigurado ang ginagawa mo.
--
___ eric pareja ([EMAIL PROTECTED]) - "We're all crazy. No one wants to admit it."
\@/ http://gra.ph/~xenos/xenos.pgp | http://plug.linux.org.ph [O(///)O]======+
v "Even the smallest person can change the course of the future." / Clue |
[ Chiba City: A Cyberpunk MUSH | http://chibacity.erisian.net ] +-------+
_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
To subscribe to the Linux Newbies' List: send "subscribe" in the body to
[EMAIL PROTECTED]
