I tried to backup all my virtual servers and i got this error message:
HTTP/1.0 500 Perl execution failed Server: MiniServ/1.810 Date: Sat, 24 Sep 2016 06:58:36 GMT Content-type: text/html; Charset=iso-8859-1 Connection: close Error - Perl execution failed
SQL select * from pg_database order by datname database "template1" does not exist at /usr/share/webmin/web-lib-funcs.pl line 1427, line 1
Intrestingly postgtres is running and there is a template1 database.
How can i fix it?
I was able to identify that virtual server, and unfortunately, this is the most important one which also has a lot of subservers. I tried to deselect the feature postgresql and got this error message:
.. PostgreSQL: DBI connect failed : FATAL: database "template1" does not exist DETAIL: The database subdirectory "base/1" is missing. at /usr/share/webmin/web-lib-funcs.pl line 1427, line 1.
Any insight, please? I need to move this to a new location and cannot backup this virtual server...
If i would apt-get remove postgresql, it would also remove my virtualmin-base package so ...
Thanks and Best
PS Found this one: https://webcache.googleusercontent.com/search?q=cache:k-1qfg2sP0MJ:https... but it wouldnt work, since i cannot connect to postgres, because it doesn't recognize any database anymore although i''ve seen this morning the postgres database, as well as template0 and template1.
UPDATE: I tried the following:
a) went to /etc/webmin/virtual-server/mydomain.acl and set feature_postgres=0. Restarted Webmin, no avail, same as before. b) went to a different server and took data directory /var/lib/postgresql/9.1/main/base and put it on the one in question. No avail as well. same as before. c) upgraded postgres, which went through but same as before
I am out of my wit, most of the tips in the www i cannot use, since there seems to be no databases at all (anymore). Even if i shutdown postgres server, it won't backup...
After upgrading postgres and trying to disassociate the feature postgres from my virtual server, which didn't work, i thought, i could try a shutdown and backup afterwards. Now it looks, that it worked (with the backup). I have to check, whether everything is fine after i put everything on the new server. But i still have this email problem. And i am wondering, why this won't work with a fresh install under Ubuntu 16.04. As to another post here, Eric said, it would be supported in April.