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 case.) curious: would psql -u template1 User: postgres Password: <none> work? > psql > create user nacho with password xxxxx 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's a new book by Bruce Momjian > which is available online via the website. -- See, if you were allowed to keep the money, you wouldn't create jobs with it. You'd throw it in the bushes or something. But the government will spend it, thereby creating jobs. -- Dave Barry [EMAIL PROTECTED] *** http://www.dontUthink.com/ volunteer to document your experience for next week's newbies -- http://www.eGroups.com/messages/newbieDoc