Re: Postgress installation...

2001-01-24 Thread Oliver Elphick
Andrew Perrin wrote: >First log in as the postgres super-user (generally, username is >postgres) and do: > >psql >create user nacho with password x createdb; > >which will allow user nacho to create databases. But note that the password will be completely ignored unless /etc/post

Re: Postgress installation...

2001-01-24 Thread will trillich
On Wed, Jan 24, 2001 at 09:37:38AM -0500, Andrew Perrin wrote: > First log in as the postgres super-user (generally, username is > postgres) and do: best way to do that is from root, just "su postgres" where no password will be needed. (don't hafta mess with your /etc/passwd file at all in this ca

Re: Postgress installation...

2001-01-24 Thread Andrew Perrin
First log in as the postgres super-user (generally, username is postgres) and do: psql create user nacho with password x createdb; which will allow user nacho to create databases. There's a lot of good documentation for postgresql in the postgres-doc package, or via www.postgresql.org. There