Tag: PostgreSQL

One Comment

Install Bacula on debian systems

  By , ,

Failed to load the database DBI driver SQLite at ./bacula-backup-lib.pl line 45 Based on: https://nklug.org.ua/node/23 http://www.microhowto.info/howto/connect_to_a_sqlite_database_using_perl_dbi.html https://ru.wikibooks.org/wiki/Bacula/Быстрый_старт http://help.ubuntu.ru/wiki/руководство_по_ubuntu_server/резервное_копирование/bacula https://www.digitalocean.com/community/tutorials/how-to-install-bacula-server-on-ubuntu-14-04 The main problem was: Failed to load the database DBI driver SQLite at ./bacula-backup-lib.pl line 45 this ultra fast fix can help: apt-get install libdbd-sqlite3-perl You can install any needed module based on SQL you use: MySQL, PostrgeSQL etc. Read more…

No comments

PostgreSQL first run

  By , , ,

This is the most common issue for PostgreSQL first run in Linux env: configure the server to allow TCP/IP connections postgresql server it can produce PostgeSQL cannot connect to database host Here I’ll show how to fix it before you struggle with firewall and ports: I’ve found ot here: 17.3. Starting the Database Server and How Do I Enable remote access to PostgreSQL database server? My situation: vi /var/lib/pgsql/data/pg_hba.conf add the string: host all all 10.10.29.0/24 trust with my range and next config: vi /var/lib/pgsql/data/postgresql.conf add the string: listen_addresses=’*’ After that restart the service: systemctl restart postgresql.service also you can use an old ‘service postgresql restart’ [root@centst010 ~]# service postgresql restart Redirecting to /bin/systemctl restart postgresql.service And here it is: [root@centst010Short Read more…