postgresql does not run on openSUSE 13.1, maybe missing password

English Applications
1

I have been trying to run postgresql server on the first time on my PC. It actually had a prior installation but I removed it and reinstalled it.

Now my pg_hba and postgresql.conf files can be found here…
http://paste.opensuse.org/14045101
http://paste.opensuse.org/29265877

Whenever, I run su postgres -c psql postgres, it asks for a password, I am not sure what should I enter over here.
Is there a default password or is there a way to reset the password again.


_______@linux-x4vi:~/Downloads> su postgres -c psql postgres
Password: 
su: Authentication failure

I also do not remember creating a user named postgres as can be seen here.

drwxr-x— 4 postgres postgres 4096 Sep 22 12:36 .
drwxr-xr-x 49 root root 4096 Sep 22 12:30 …
-rw------- 1 postgres postgres 332 Aug 22 14:59 .bash_history
-rw-r----- 1 postgres postgres 192 Feb 28 2014 .bash_profile
drwxr-xr-x 3 postgres postgres 4096 Aug 12 15:14 .local
-rw------- 1 postgres postgres 109 Aug 13 11:08 .psql_history
drwx------ 15 postgres postgres 4096 Sep 22 15:10 data
-rw-r–r-- 1 postgres postgres 1228 Aug 12 15:14 initlog

2

I’m not completely up on everything, but shouldn’t you be using something like:

sudo systemctl start postgres.service

or

su systemctl start postgres.service
3

Oh Yeah, I had already started the postgressql server as a service

4

Yes, but you may have started it with the wrong command set.
You used the following:

su postgres -c psql postgres

and it seems to me you shouldn’t start it that way anymore.

Can someone else jump in and advise?