Error installing PostgreSQL via php upgrade

Thanks. I used the "ls -lahrt /root/centminlogs/ | egrep 'php_upgrade'" command and it matches the "sort by last modified" view in Filezilla that I was using. Is the minimal log I provided adequate? Or do I need to compress the full log and upload it?

---

 

Here you go ****

I included the past few logs because I noticed they had differences.

 

Code:

ls -lAh /usr/pgsql-15/bin/postgresql-15-setup
-rwxr-xr-x 1 root root 9.4K Aug 10 07:23 /usr/pgsql-15/bin/postgresql-15-setup

 

I saw you updated inc/postgresql.inc, so I ran php upgrade again and it seems to be working. Thanks!

Extra info:
I ran "psql" and it says:

Code:

psql
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  role "root" does not exist

I tried these https://stackoverflow.com/questions/46142381/psql-fatal-role-root-does-not-exist
This one works:

Code:

sudo -i -u postgres
psql

The next one gives an error:

Code:

su postgres
[02:36][postgres@centos7test root]$ psql
could not change directory to "/root": Permission denied
psql (15.4)
Type "help" for help.

postgres=#

Looks like a pw is set or has to be set:

Code:

psql -U postgres
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  Peer authentication failed for user "postgres"

The -W will prompt for a pw:

Code:

psql -U postgres -W

I don't know what the default is. Someone on stackoverflow says:

So presumably, the easiest way to set up the user would be:

Code:

sudo -i -u postgres
psql
ALTER USER postgres PASSWORD 'newpw';
exit
psql -U postgres -W
newpw

But that seems to only work temporarily. More info:

• https://www.postgresqltutorial.com/postgresql-getting-started/install-postgresql-linux/
• https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-centos-7