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://www.postgresql.org/message-id/20060915134344.GA4590%40winnie.fuhr.org+&cd=2&hl=de&ct=clnk&gl=de&client=firefox-b
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…