Le mercredi 14 janvier 2015 10:12:39 UTC-5, Bernard Tremblay a écrit :
> Le mercredi 14 janvier 2015 08:19:57 UTC-5, [email protected] a écrit :
> > W dniu wtorek, 13 stycznia 2015 17:56:47 UTC+1 użytkownik Bernard Tremblay
> > napisał:
> > > Anybody here using contrib-pgsql-plugin and willing to share
> > > configuration info ?
> > >
> > > I'm trying to setup the config to try the plugin on a test DB but I'm
> > > having hard time making the configuration file.
> > >
> > > I have compiled the plugin, created the plugin catalog DB, but now I'm
> > > scratching the back of my head in front of the lack of documentation for
> > > this plugin.
> > >
> > > Note that I'm quite noob with bareos too wich add to the overall picture.
> > >
> >
> > I've replied to your message on bareos-devel group.
> >
> > You can check below one of my test configs:
> >
> > #
> > # Config file for pgsql plugin
> > #
> > # Where Postgresql data directory is located (pg_cluster)
> > # Plugin will backup this cluster including all defined tablespaces
> > PGDATA = /pgqdata/testosteron2/PostgreSQL/9.2/data
> > # Where Postgresql socket directory is located
> > PGHOST = /tmp
> > # What Postgresql "port" is defined
> > PGPORT = 5432
> > # Database name for catalog database
> > CATDB = catbac
> > # Host location for catalog database
> > CATDBHOST = 10.80.7.11
> > # Port location for catalog database
> > CATDBPORT = 5432
> > # Catalog database user to connect to
> > CATUSER = pgsql
> > # Catalog database User's password
> > CATPASSWD = password
> > # Destination for archived wal files. It is a temporary location before
> > # we archive on backup system.
> > ARCHDEST = /pgqdata/backup
> > # Name of archiving client. Name should be unique on every catalog
> > # database. It could be a server name, service name, or other unique
> > # string. You cannot use ':' char in archclient name. This is
> > # simultaneously a name of console resource required for database
> > # restoration.
> > ARCHCLIENT = testosteronprd
> > # Bacula Director name used for console resource
> > DIRNAME = catbac-dir
> > # Bacula Director host location used for console resource
> > DIRHOST = 10.80.7.11
> > # Bacula Director port location used for console resource
> > DIRPORT = 9101
> > # Console resource password
> > DIRPASSWD = restorepassword
>
> 100 000 000 000 Thanks!
>
> This help a lot, I will try to sort it out to make my own config files.
Hi,
Could you tell me exactly what database will be backup'ed in your sample
config ?
I understant there is a catalog database catbac on 10.80.7.11 and there seems
to be a client called "testosteronprd". Does it backup all postgresql database
on testosteronprd ? Can you backup only one database ?
To my understanding, the backup catalog is the postgresql equivalent of the
catalog for the director and regular files.
In fact, it is not very clear in the documentation how the configuration of the
plugin is structured.
Once we have the pgsql.conf done, how do wee add a client with one DB to backup
??? Do we add a fileset, a job and a schedule ?
As you can see I'm quite a noob in bareos and postgresql. But, may be it could
be an opportunity to clarify the documentation ?
Regards,
Bernard
--
You received this message because you are subscribed to the Google Groups
"bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
For more options, visit https://groups.google.com/d/optout.
