Note:   These notes come from playing around quickly with postgres installed for Spacewalk.

Important Files and Directories

FILE Description
/var/lib/pgsql Postgres DB Home – contains  DB, logs, data
 /var/lib/pgsql/data/pg_hba.conf User permissions to  the database
 /var/lib/pgsql/data/pg_ident.conf Map user1 to user2 when they connect
/var/lib/pgsql/data/pg_log Log Files for Postgres
 /var/lib/pgsql/data/postgres.conf DB Parameters – memory, connections …
/var/lib/pgsql/data/postmaster.opts postmaster is the master SQL daemon
/etc/rhn/rhn.conf | grep db_ Name, credentials of the SQL DB
/etc/sysconfig/rhn/up2date Configuration file for Spacewalk (proxy, RHN user, passwd)
/etc/sysconfig/rhn/rhn-entitlement-cert.xml RHN Auth certificate

Important Commands

COMMAND Description
echo “select login from web_contact;”| spacewalk-sql –select-mode – SQL command as root ( show Spacewalk users )
service postgresql start ; spacewalk-service start start postgres ; start Spacewalk
/usr/bin/satpasswd set password for Spacewalk user
 rpm -qlp Contains Oracle Linux repo, GPG Key
rpm -qlp Contains spacewalk repos (normal, source and nightly)