I'm trying to setup PostgreSQL onto a CentOS (that I connect through SSH). I need to unzip a package (so not downloading through yum or rpm): http://get.enterprisedb.com/postgresql/postgresql-9.3.4-3-linux-x64-binaries.tar.gz and set this up.
I unzipped, and ran the following
./postgresql-9.3/bin/initdb -D data/ ./postgresql-9.3/bin/postgres -D data/
When I try to run
createuser I get asked for a password and I enter it, but get:
psql.bin: FATAL: password authentication failed for user "myusername"
Question: How can I make
./data/pg-hba.conf is as follows:
local all all trust host all all 127.0.0.1/32 trust host all all ::1/128 trust
Also, there doesn't seem to be a
postgres user in the system, which makes sense since I simply unzip the tar.gz