Server :: Upgrading Bacula Database For Postgres?

Mar 24, 2011

While backing up/restoring bacula clients. We were getting an error regarding database tables' version. The error message is given below.. "Found 10 needs 12".

After Googling, what we found is, we have to update the postgres database for bacula. So now we are in process to update the database via the update_bacula-tables script. We are not sure, if it will solve the problem or not. We have just upgraded bacula 2.4.4 to 5.0.1. Postgres version is upgraded from 8.3 to 8.4. It is Debian 6.0 squeeze.

View 2 Replies


Server :: Restoring A Postgres Database?

Jun 9, 2010

We have a disaster recovery solution for our database where a dump file is generated daily at 1:00 AM. We have tested importing the file, along with running another sql file that generates the appropriate database user accounts, into a database on a third-party server.

One question that came up was the following: Suppose the database crashes in the middle of the day, prior to that there were transactions that were entered into the database between the time the dump file was generated, and the crash occurred. We can restore the dump file to either the main or backup server. How can the transactions that were made between the time of the dump file and the crash be restored as well?

View 2 Replies View Related

Ubuntu :: Bacula And Database Creation?

Oct 27, 2010

I have installed bacula which by default installed the mysql backend. Asked me for the root password of mysql but since I couldn't remember I cancelled the configuration. I checked it out afterwards and now I know it but I can't find my way back to the bacula database setup screen once again. I have read that there should be a create_bacula_database script somewhere but I can't find it. Any tips on how to set this up?

View 6 Replies View Related

General :: Centos Search For Postgres Database?

Jan 31, 2011

Ok so I need to Search for a postgres database File on a CentOs System. Is their a command i can run in the terminal to search for postgres files?

View 2 Replies View Related

General :: Use Bacula To Make Backups Of The Files Stored On The Server?

Apr 14, 2010

I have an ubuntu (8.04.3) server where I use bacula to make backups of the files stored on the server. Ive been trying to find a solution (with no luck) trying to succesfully implement the following:-

A Backup tape for each day of the week besides Thurs which is resused on a weekly basis. For the thursday tapes we have a backup tape corresponding to the week number that the thursday falls so for the first thursday of the month it would be ThursOne For example. These tapes are resued on a monthly basis. We then have a monthly tape that is used on the last thursday of the month. These tapes will be resused on a yearly basis.

Another requirement is just in case a tape is accidently not changed a backup should still occur regardless of what tape is in the drive (so if its tuesday and mondays tape is still in the tape drive it should rewrite that tape).

I did have this successfully set up where the tape was appended after each use rather than being recycled after the nightly backup. But then after a few weeks I would have to manually purge tapes when they became full (which isnt ideal - as Im not always in the office so in my absence it may be that a backup may not take place), so have been playing around and have now got the tapes to be marked as used after a max of 2 jobs (so the backup of the files and the catalog of the night). I also added this line 'Recycle Current Volume = yes' so that it would hopefully recycle the volume in the drive.

However what I am finding is that the tape that should be recycled is not, but in yesterday case the Mondays tape was recycled rather than the Tuesday although Mondays was the last written so Im not even sure why it choose to recycle this tape.

View 1 Replies View Related

OpenSUSE :: MySQL Database - Upgrading To 11.3

Aug 16, 2010

My existing MySQL database is running on 11.1. I plan to do a fresh install of 11.3 in order to utilize the trimming feature for SSD drives. How should I install my MySQL database to the new version? Do I perform a backup then restore to the new install? Or can I just save the mysql db files to a cd and somehow attach it to the new install?

View 2 Replies View Related

Security :: Restart Postgres In Server - Selinux Is Not Letting It Log Anything

Jan 28, 2010

Whenever i restart postgres in my server, Selinux is not letting it log anything. In /var/log/messages, it says.

Quote: Jan 28 14:15:43 dataserver kernel: audit(1264709743.263:38): avc: denied { append } for pid=5986 comm="postmaster" name="pgsql.log" dev=sda8 ino=3932166 scontext=root:system_r: postgresql_t tcontext=root: object_r:var_log_t tclass=file

Jan 28 14:15:43 dataserver kernel: audit(1264709743.263:39): avc: denied { append } for pid=5986 comm="postmaster" name="pgsql.log" dev=sda8 ino=3932166 scontext=root:system_r: postgresql_t tcontext=root: object_r:var_log_t tclass=file

I cannot disable SeLinux in this server.

View 1 Replies View Related

Server :: System Error - Authentication Failed For User Postgres

Mar 29, 2011

I made a system in CentOS5.5. I used Tomcat6 and PostgreSQL. But I couldn't enter my system. There are some error. And I don't understand what kind of error this.
JDBCExceptionReporter.logExceptions(100) | SQL Error: 0, SQLState: null
JDBCExceptionReporter.logExceptions(101) | Cannot create PoolableConnectionFactory (FATAL: Ident authentication failed for user "postgres")
"postgres" is username.
Is anybody knows anything about this error message.

View 4 Replies View Related

CentOS 5 Server :: Login As Postgres User And Enter Commands?

Sep 10, 2010

I've had a server setup working perfectly for the last 2 years. Today we installed a newer version of postgresql and recompiled apache/php.

Postgresql will not start now.

"service postgresql start" = /var/lib/pgsql/data is missing. Use "service postgresql initdb" to initialize the cluster first. To initdb we need to be as user postgres.

"su - postgres" = "no file or directory"

In /etc/passwd = postgres:x:26:26:PostgreSQL Server:/var/lib/pgsql:/bin/bash

how i can login as postgres user and enter these commands?

View 2 Replies View Related

Fedora :: Transfer The Database Without Upgrading The Existing Mysql In Solaris Machine?

Oct 14, 2010

i am using fedora 12i want to bakup my mysql database and extract it in my solaris 10 my fedora machine i gave

mysqldump (database-name) > bakup.sql
in my solaris machine i gave
mysql (newly created dbname) < bakup.sql


View 4 Replies View Related

Server :: Database Stopped Showing Up - Files Still There - Restore The Database From The Files?

Jul 8, 2011

I recently moved into a new place and when I hooked up my webserver, I wasn't able to bring up my page, even from localhost. With some digging, it seems that I can't access the database that housed my posts (wordpress installation). I looked for the datadir in MySQL and that directory shows the wordpress directory that should be holding the database and all the files are still there. 1) why the database no longer shows up 2) how to restore the database from the files?

View 2 Replies View Related

Ubuntu Multimedia :: Video Drivers After Upgrading To 10.04 - Error "Unable To Initialize PCS Database"

Apr 2, 2010

Having all kinds of trouble with my video drivers after upgrading to 10.04 The error message I get is

Unable to initialize PCS database Missing PCS default file .etc/ati/amdpcsdb.default No devices I keep reinstalling my video drivers from the file for my radeon 2400 card - seemingly successfully - but it doesn't seem to help and when I reboot i just get the limited video function

View 2 Replies View Related

Software :: How To Run The Bacula's Bat

Mar 2, 2010

What is best practice for running Bacula's bat (Bacula Administration Tool) on Linux? Specifically on Slackware 13.0 with Xfce.

/usr/bin/bat is installed as root:root 554; its config file (typically /etc/bacula/bat.conf) is installed as root:root 640. Presumably there are good reasons for these settings.

bat is a GUI tool so needs to run under X. Running X as root is considered insecure or dangerous. One solution would be to put an ordinary user in group bacula (say) and give that group execute permission on /usr/bin/bat and read permission on /etc/bacula/bat.conf.

Netsearching for combinations of bacula, bat, X, root has not found anything helpful (bat without bacula finds too many pages about .bat files).

View 6 Replies View Related

Ubuntu :: When Will Bacula Packages Be Updated?

Jul 16, 2010

I'm building a new backup server, migrating from Centos to Ubuntu 10.04 LTS and upgrading to Bacula 5 all at the same time.Is there a way to find out why there's a 3 month lag? 5.0.2 was released in April, and the currently available packages are 5.0.1.Also how can I find the policy on future updates ? I'd really like to use the core-provided packages but don't want to end up way behind after a year or two.

View 3 Replies View Related

Software :: Install Bacula Onto Trixbox?

Feb 21, 2010

I'm complely stuck on this one, I want to install Bacula onto my trixbox, and I can't figure out the correct procedure to install the bacula-fd daemon, because you cannot use apt-get.

View 1 Replies View Related

Server :: MySQL Move Database / Server Doesn't Start

Nov 3, 2010

I'm trying to move a mysql 5.1.50-community InnoDB database from one location to another.When starting the service I get:Starting MySQL.Manager of pid-file quit without updating file [FAILED]I've searched for a way to do this but I can only find people who describe what I've just done.

View 6 Replies View Related

Hardware :: Bacula - Setting Up Tape Drive Backup

Sep 15, 2010

I am setting up a tape drive back up, but I am having "fun" with bacula configuration. Basically the drive is working , I ran the test with the btape program and all was correct. I am basically meddled up with the jargon and the very large bacula documentation. I created some 2 volumes and gave the mounted the tapedrive (labeled) the name of one of them "tapevol2" .... now I can not relabel the tape, I deleted the volume "tapevol2" but still the tape drive is mounted with that name, even though the volume is deleted. If I add ( create more volumes) I can not make the tape to mount with anything different that "tapevol2". I would like to go back to zero and delete all volumes, and mount the tape with one of the newly created volumes, so the jobs back up can run.

View 2 Replies View Related

Networking :: Amanda Versus Bacula For Historical Backups

Jun 8, 2010

I have a client that is using a windows based backup system called Retrospect and will be installing Linux to replace his windows server. Right now the way it works is on the XP pro workstation Norton 360 makes a backup to the server and then Retrospect make it backups every night. I want to add a linux based backup system that will give them a historical backup system that had XP pro client software that can backup open files and such I can do away with the Norton backup stuff and streamline this setup. I need it to have the capability to go back in time to restore something of an older date this historical. I was looking into:


I have never used either one and was wondering what the linux community wold recommend between the two or if there is something better that has client software and free and does it have a GUI for my clients? I am leaning toward AMANDA after reading Jeremy's article:


and there seams to be a webadmin gui as well.


View 5 Replies View Related

Software :: Bacula And Overwriting The Data On The Next Backup On The Tape

Feb 22, 2010

Currently I have bacula backing up the contents of my server on a daily basis (Mon-Fri) on to a tape. There are in total 9 backup tapes so far. One for each day of the week (Mon-Thurs) and one for every Friday in the month (so there are 5 friday tapes). The tapes are all from the same pool and once the tapes are full they should then get recycled. As I understand and from what I have seen, the data from my server backups up to the tape and is then marked with the append status. Every time that tape is used, data is then appended onto the tape until the tape is full. At this point it is marked as full but wont be recycled until all the tapes from the pool are marked as full (so until all 9 tapes are full).

My question is, is there a way of overwriting the data on the next backup on the tape, rather than appending or requiring that all tapes in a pool are full before a tape can be recycled. As the mon-thurs tapes currently cant be recycled until all the Friday tapes have been used. The reason why I dont have seperate pools for the Friday backups and the other days of the week or even seperate pools for each day of the week, is that if a tape is accidently not changed or someone puts in the incorrect tape by accident a backup will still occur. Which is better than no backup!

View 2 Replies View Related

Software :: Bacula - RHEL6 - Permission Denied Errors

Feb 24, 2011

OS = RHEL6 64 bit
Bacula version - Version: 5.0.3
Clean build from tarball
DB = Postgresql

Short version = Installed and configured bacula from scratch. All bacula daemons are running, bconsole responds and let's me run manual jobs. I'm testing the new install by trying to backup my backup server (minus the raid storage area) and I keep getting permission denied on system, files. I know they are owned by root but I need to be able to back them up regardless. Here's what I'm seeing:


Now I know I've done this before back in bacula version 2 something but I'm missing something here and my brain is shot from configuring this thing to this point. I'm on the home stretch and need advice on where to look next. Once I can successfully backup the backup server, then I can move on to my main server, my winblows systems, and then my Macs.

View 3 Replies View Related

Server :: Slow Database Server On Processing / Make It Up?

Apr 15, 2010

I'm having trouble with my database server run with PHP & MYSQL; i just installed this system on a SUSE Linux Enterprise Sever; the Server its self is an HP Proliant ML370G with 4GB RAM
The system was fine for like 3 weeks until recently when it started slowing down. Apparently, eveything is normal when you are accessing the server, for example when you are browsing on the database web interface; but problem is when you start working in the database, when you try submitting into the database, its really slow on processing, i have to first restart the mysql;
Could it be RAM? or the SQL itself?

View 3 Replies View Related

CentOS 5 Server :: Put A MySQL Database In A Server's Memory?

Mar 18, 2010

I'm looking for a way to put a MySQL database in a server's memory. The disks aren't fast enough to keep up with the usage and I don't feel like going for a splitted web&db server yet because of the costs.

Because this involves risks (unless there's a way to read from the memory and write to the memory AND disks?), so I'd prefer that the DB gets copied automatically every hour or so to the local disks.

View 1 Replies View Related

OpenSUSE :: Postgres Does Not Start After Upgrade To 11.2?

Feb 10, 2010

I had postgresql 8.3 running on opensuse 11.0, recently upgraded to 11.2 (so postgres is now 8.4) and have problems starting it. I make, su, then as root run:

# /etc/init.d/postgresql start
Your databases are still using the format of PostgreSQL 8.3.
Therefore a backup of the old PostgreSQL server program will be used
until you have saved and removed your old database files
See also /usr/share/doc/packages/postgresql/README.SuSE.{de,en} .
Starting PostgreSQLsu: incorrect password


View 4 Replies View Related

Ubuntu :: What Is The Default Postgres Password?

Jun 23, 2011

I just installed postgresql 8.4 package on my Ubuntu 10.10 desktop. Seems to have worked fine. But what is the password for logging into the databases created by user 'postgres'?

sudo su postgres
and then
psql mydb

fine and it never asks me for a password. But if I want to use pgadmin3, I want to enter passwd for postgres, etc.

View 4 Replies View Related

General :: User Postgres Does Not Exist?

Jul 21, 2010

i have installed postgresql to my fedora10-distribution. when i would to access to this database by using the command #su postgres as is mentioned at [URL]..3/install/wiff/createcontext to install freedom , an error message is shown to tell me that user postgres does not exist. what is the likely problem.

View 15 Replies View Related

Software :: Autofill - Tab Key - Not Working In Postgres ?

Feb 24, 2010

I installed postgres successfully but, when I press tab key, it does not autofill the available options.

View 1 Replies View Related

Ubuntu :: Pgadmin On 10.10 - Support For Postgres 9?

Jan 16, 2011

I am in the process of looking to migrate my PC from Windows 7 to Ubuntu 10.10 as I like it and i find it a little quicker than Windows. One of the major failings I find at the moment is software app support. I am setting up some PostgreSQL 9.0 servers (to do streaming replication) and using pgadmin to do the management.

Under Windows this app works great, but under Ubuntu it seems the standard package only supports up to 8.4, and looks like support has been dropped for pgadmin on Ubuntu. What I can't understand is the open source movement isn't supporting itself - or is it that because 10.10 is not on LTS, they are waiting for the next version to update the package - anyone know? If its not supported then back to Windows I go, because I know the latest version works fine.

View 4 Replies View Related

Server :: Database Can't Use SSL Certificates?

Apr 19, 2011

I've installed PostgreSQL on Arch Linux & also self generated self signed certificates in /etc/ssl/ directory. My PostgreSQL 'data' directory is /var/lib/postgres/data & I've edited my postgresql.conf file to use SSL however I'm having permission / access problems starting my database using SSL. It can't access the certificates and errors out when I try and start the database engine:

LOG: autovacuum launcher shutting down
LOG: shutting down
LOG: database system is shut down
FATAL: could not load server certificate file "server.crt": No such file or directory

I don't know what I need to chown or chmod in order to get PostgreSQL to access my self signed certificates.

View 3 Replies View Related

Server :: Create New Database From PHP / SQL

Nov 4, 2010

I am now able to create the database using PHP and SQL. But it seems I can only do it as MySQL root user.. $dbuser = 'root'; but is there a way to do that as a regular MySQL user?

View 2 Replies View Related

Server :: Sync One Database To Other?

Nov 8, 2010

I have got 2 postgresql databases on separate servers. i want to sync one database to the other. how it can be done ?

View 1 Replies View Related

Copyrights 2005-15, All rights reserved