Seem that commands was not done correctly.
I can see in the first 3 commands:
root@arqueoserver:/var/www/html# su - postgres
psql command was not execute, and only the first command was done. So, the next lines was not done because you are not in
Well, step by step:
1 You need to test if your PostgreSQL is running:
systemctl status postgresql
If PostgreSQL is running you can go to next command, if not, review the PostgreSQL installation.
2 copy the command 1 to 1 and ensure that every command was executed.
su - postgres
you will need to show that the terminal change the user as
when you are with postgres user, enter the
you will see that the terminal was changed to
postgres=# then, copy the SQL commands to create user and database.
CREATE USER dedalo_user PASSWORD 'My_super_Secret_pw';
CREATE DATABASE dedalo_xxx
COMMENT ON DATABASE dedalo_xxx
IS 'Dédalo: Cultural Heritage and Memory management system';
Then and before rename the config files you will need to exit from
cp commands are NOT SQL commands!
So, you can exit from
and you can exit from postgres user with:
Then you will need to see that the terminal back to
root@arqueoserver: user before enter the
shell bash commands
In any action you must READ what the terminal say.
I recommend you to read the oficial bash documentation
I recommend you to see the oficial postgreSQL documentation about psql
And final note: I recommend you to get help for someone with server experience. Using the terminal could be dangerous if you don't have control about it.