At 08:40 AM 3/25/03, Christopher Shaffer wrote:
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?
Could be postgres
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
it's probably postgres.
If there is a password allocated as well and you don't know what it is,
(blowed if I can remember) try su root then su postgres :o)
As postgres you are the main postgresql user and can create other users -
including yourself.
There are huge volumes of notes available
Answer to one :
Postgres is the user account that the postgres DBMS in run as a service. You
can create a user account for yourself from the command line using
createuser
Synopsis
createuser [options...] [username]
Inputs
-h, --host host
Specifies the