I've installed the all the postgresql rpms on my RHL 9 machine and I've run the command "service postgresql start". My question is:
What do I do now?
1) su to the postgres user and create a new user with the "createuser" command.
If this is a multi-user system:
2) set passwords on both the postgres user and your new user. 3) adjust your security settings in /var/lib/pgsql/data/pg_hba.conf
How do I log in a database?
# su postgres -c "psql template1"
Once you've created a new user, he can just execute 'psql'.
What is the password to su to postgres?
There isn't one, unless you set one yourself.
Do the createdb and createuser programs do anything other than output error messages?
Yes. If you find the other documentation a little thick, try the book:
http://www.postgresql.org/docs/awbook.html http://www.postgresql.org/docs/aw_pgsql_book/index.html
It's been helpful to me.
-- redhat-list mailing list unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=unsubscribe https://www.redhat.com/mailman/listinfo/redhat-list
