To access postgresql (assuming everything has been set up correctly).. 1. $su postgres from su. 2. createuser -e --pwprompt user (where user is the name your using) Enter password for user "user":***** Enter it again: Shall the new user be allowed to create database? (y/n) Shall the new user be allowed to create more new users? (y/n)n CREATE USER "user" .....
Since I don't like using postgres as my standard user this does the ticket for creating a semi Postgresql admin. Also make sure in your in your pg_hba.conf file that you add the following line. host all (ip address optional) (mask optional) ident sameuser If you have configured your postgresql.conf file correctly you can access the db from other computers with pgadmin or another pgsql session. cheers neenja -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Christopher Shaffer Sent: Tuesday, March 25, 2003 5:41 AM To: [EMAIL PROTECTED] Subject: [newbie] PostgreSQL Forgive my silly question, but I'm trying to experiment with PostgreSQL (all I've used till now is MySQL...) on Mandrake 9.0, but I have know idea what the default username/password is. Is it kind of like MySQL, with a root user? Thanks, Chris __________________________________________________ Do you Yahoo!? Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop! http://platinum.yahoo.com
Want to buy your Pack or Services from MandrakeSoft? Go to http://www.mandrakestore.com