yum install postgresql-server
postgresql-setup initdb
postgresql-setup --upgrade
Edit /var/lib/pgsql/data/pg_hba.conf
host all all 127.0.0.1/32 md5
CREATE USER username login PASSWORD 'password';
CREATE DATABASE databasename WITH OWNER = username;
pg_dump -U username -h 127.0.0.1 dbname -t tablename --schema-only