Dear Dan,
In message <A216F657-338F-4BDF-BDBD-814508CCAEB1 AT langille DOT org> you wrote:
>
> > However, none of the PostgreSQL based examples I have seen so far
> > contain similar (at least similar obvious) exclude rules. What am I
> > missing here?
>
> It depends on where your PostgreSQL database is. On FreeBSD, which is =
> my preferred
> operating system for a server, this is /usr/local/pgsql
>
> That is the usual location, but it may vary.
For the record, under Fedora it's at /var/lib/pgsql/data/
> However, there may be things that you do want to back up. Especially in
> /usr/local/pgsql/data:
>
> at a minimum, I would backup:
>
> pg_hba.conf
> pg_ident.conf
> postgresql.conf
>
> But given you want regex, I'd go with:
>
> pg_multixact pg_subtrans pg_twophase
> pg_stat_tmp pg_tblspc pg_xlog
> pg_clog base global postmaster.log
Thanks - that was really helpful!
> This assumes you are dumping each database, including the globals
> database, to disk and backing that up.
Understood, doing that.
Thanks again.
Best regards,
Wolfgang Denk
--
DENX Software Engineering GmbH, MD: Wolfgang Denk & Detlev Zundel
HRB 165235 Munich, Office: Kirchenstr.5, D-82194 Groebenzell, Germany
Phone: (+49)-8142-66989-10 Fax: (+49)-8142-66989-80 Email: wd AT denx DOT de
Give a man a fish, and you feed him for a day. Teach a man to fish,
and he'll invite himself over for dinner. - Calvin Keegan
------------------------------------------------------------------------------
Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and
much more. Get web development skills now with LearnDevNow -
350+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122812
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|