Re: [Bacula-users] Migrating to Newer Version of PGSQL

> You might run Baculas "dbcheck" to prune unused entries in the
> database before migration.
>

I ran:
root@pisces:/~# su -m bacula -c '/usr/local/sbin/dbcheck -B -c /usr/local/etc/bacula-dir.conf'
catalog=MyCatalog
db_name=bacula
db_driver=
db_user=bacula
db_password=
db_address=
db_port=0
db_socket=
db_type=PostgreSQL
working_dir=/var/db/bacula
root@pisces:/~#

It completed within seconds. Looks good, no?

No, :)

Option '-B' just print catalog configuration and exit. Check a manual, documentation or in application help.

Use it without '-B' parameter and supply database connection parameters. Then check your instance.

I read up on it and ran dbcheck with the desired parameters and found millions of orphaned records! I now recall that we’ve had various clients that we used to back up over the years but since then have dropped them as clients. I’m now eliminating these orphans as I type this.

Thanks for the pointer!

~Doug

------------------------------------------------------------------------------
Own the Future-Intel&reg; Level Up Game Demo Contest 2013
Rise to greatness in Intel's independent game demo contest.
Compete for recognition, cash, and the chance to get your game 
on Steam. $5K grand prize plus 10 genre and skill prizes. 
Submit your demo by 6/6/13. http://p.sf.net/sfu/intel_levelupd2d

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users