hi all
I use FreeBSD 4.10. I downloaded the packages for PostGRE SQL (7.4.2), and installed the packages.
I also happened to see the messages "created user postgres" & "created group postgres".
Then executed the initdb and started the postgres server.
Now when I do a ps, postgres shows up.

How do I go about creating a sample database (does a preconfigured sample DB exist)?
regardless of whether I issue createdb or createuser, I get the error: userxxx not found.

Thanks for any help

Tk

Visit our website at http://www.ubs.com

This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.

E-mail transmission cannot be guaranteed to be secure or error-free
as information could be intercepted, corrupted, lost, destroyed,
arrive late or incomplete, or contain viruses. The sender therefore
does not accept liability for any errors or omissions in the contents
of this message which arise as a result of e-mail transmission. If
verification is required please request a hard-copy version. This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities or
related financial instruments.


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

On Mon, 2004-08-30 at 15:38, Kesav.Tadimeti (AT) ubs (DOT) com wrote:
The newly-created user postgres will be th eone which owns the database
and the only user to exist in the new database cluster.

You must create yourself as an administrator user first, by becoming the
postgres user:

$ su
# su - postgres
$ createuser -a -d yourself
$ exit
# exit
$ creatdb your_database

Sorry for reading this without permission.

....
--
Oliver Elphick olly (AT) lfix (DOT) co.uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
"For what shall it profit a man, if he shall gain the
whole world, and lose his own soul?" Mark 8:36


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org