Broke Postgres?

[Alteil Analysis]

Hi. I am sorry.

 

I am not sure if I broke Postgres database.

 

I tried to install mediawiki, with InnoDB. Failed for four times, and everytime I deleted the database before I started.

It says it can not connect to localhost.

I look for InnoDB and stevie in the official wiki. Later, when I search the forum I found that is bad because that

would cause problems to stevie's InnoDB.

 

After that, I read an article from digital ocean that says Postgres has ber data integrity than MySQL, but is also slower.

I created a postgres database, and then reinstall mediawiki by reuploading and then setup.

I also created two users for the database with cPannel and noted that it didn't ask anything about permission of the user.

Installing mediawiki with the two users didn't work, probably because of permission problem.

 

It didn't occur to me that I could directly use my root passwolrd to ask the mediawiki install to create lower permission

accounts.

 

Then, I downloaded adminer. The 3.x version say my root account needs to have connect permission.

I downloaded and uploaded the 4.0 version, set the php file to 640 permission, and then log in with my root account.

 

At the same time, I downloaded the PyGreSQL library for python to my laptop.

The python library can connect with my root account to the database that I created in cPannel.

 

Strangely, I don't see the postgres database that I created earlier with cPannel in adminer.

I deleted the database and users with cPannel.

 

After that I log into adminer with my root account and without specifying the table name.

I see the information schema table, and then created alteilar_wiki table.

I tried to create and then add alteilar_postgres user to the alteilar_wiki table, but, adminer

says my root account can not grant permission.

 

So, I deleted the user I made, and the alteilar_wiki table.

 

When I log out and then log back in, I noticed that the information schema table disappeared

and I see a bunch of table names with username_table format. I click on one of them, but

admin says the table doesn't exist. I also noticed that one of the table is called admin.

 

At that point, I log out. When I reload the php installer of mediawiki, it says

MysqlUpdater.php has problem at line 249.

as in http://code.metager.de/source/history/mediawiki/includes/installer/MysqlUpdater.php

 

I deleted my heliohost account on stevie, and recreated one with the same subdomain, user name,

but different password.

 

 

I am sorry if I broke postgres of stevie.