Try to restore the PgSQL database in shared web hosting. I give it a test.

1. Change D7 to maintenance mode
2. In phppgadmin, click database - mydatabase > click Export > Format:Structure and data, Options:FORMAT:SQL, this create the dump.sql file
3. Then I delete the database
4. Then create a new database with the same name and password like the 1 before
5. In phppgadmin, click database - mydatabase > click SQL, paste the SQL code, click Execute.

After successfully restore and revisit the website. Get the below error

Notice: unserialize(): Error at offset 0 of 1009 bytes in /home/www/mywebsite.me/includes/cache.inc on line 438

Notice: unserialize(): Error at offset 0 of 182399 bytes in /home/www/mywebsite.me/includes/cache.inc on line 438

Warning: Invalid argument supplied for foreach() in /home/www/mywebsite.me/includes/module.inc on line 213

Warning: array_keys() expects parameter 1 to be array, null given in /home/www/mywebsite.me/includes/module.inc on line 89

Notice: unserialize(): Error at offset 0 of 182399 bytes in /home/www/mywebsite.me/includes/cache.inc on line 438

Warning: Invalid argument supplied for foreach() in /home/www/mywebsite.me/includes/module.inc on line 213

Warning: array_keys() expects parameter 1 to be array, null given in /home/www/mywebsite.me/includes/module.inc on line 89

Fatal error: Call to undefined function system_run_automated_cron() in /home/www/mywebsite.me/includes/common.inc on line 2732

Try to use MySQL that provided by the same shared web hosting company. Restore successful.
Try to use PgSQL in my testing environment (PgSQL build by myself), successful too.
I think this should be the settings of the PgSQL database. Anybody have a clue ?

Comments

ravi_admec’s picture

i think you should try one or all from the following given steps.
1. remove all the cache of ur browser
2. remove the cache from the database/ phpmyadmin
3. one more time match your config detail

thanks

DHL’s picture

Umm...
1. Clear the web browser cache not work. The web hosting support also see the same error.
2. I think I can't clear the cache of the database. I'm using shared web hosting service.
3. There's not many config I can check. The database was restored by the dump.sql file. Everything should be same as before, unless the database cheat me...

DHL’s picture

I push this subject back to the top because I really need HELP !!!