the file you copied during this step:
- Code: Select all
cp /pgbak/pg_hba.conf /var/lib/pgsql/data/pg_hba.conf
is slightly out of date. Toward the bottom there should be one or more lines containing "ident sameuser". Try modifying that to say just "ident" (i.e. remove "sameuser") and then continue with your other steps:
- Code: Select all
chkconfig --level 35 postgresql on
service postgresql start
su - postgres
psql -f /pgbak/backup.sql postgres
vacuumdb -a -z
exit
Cheers,
~Josh