[prev in list] [next in list] [prev in thread] [next in thread] 

List:       koffice
Subject:    Re: install of KOffice on FreeBSD
From:       Dennis Veatch <dveatch () woh ! rr ! com>
Date:       2005-11-21 11:51:09
Message-ID: 200511210651.10049.dveatch () woh ! rr ! com
[Download RAW message or body]

On Monday 21 November 2005 06:31, Gordon Gilbert wrote:
> Hi Raphael!
>
> Thanks for your reply.  My mistake -- my version of FreeBSD is *5.3* not
> 5.2 -- I have had it here for quite a while, and I wouldn't dream of
> installing a new version of FreeBSD myself.  I leave that to my son the
> genius.
>
> I tried installing a new copy of postgresql, and it said something about
> backing up your data -- that postgresql doesn't do that.  What data are we
> talking about here?  I don't want to lose something, but I'm not sure
> where I should look for this data, and what to do with it.
>

The "pg_dump" command is used to create a backup of postgresql database. The 
"pg_dumpall" command is used to backup *ALL* postgresql databases on the 
system. See the manpage for additional command settings that you might want 
to use.

I don't know about BSD systems. But on Linux, postgresql normally lives 
in /var/lib/pgsql . The actual database lives in /var/lib/pgsql/data/base. If 
you "ps ax | grep post" that should help you find where postmaster is 
looking. 

*It is not wise to try backing up postgresql with any other method than 
pg_dump or pg_dumpall*.

-- 
You can tuna piano but you can't tune a fish.
____________________________________
koffice mailing list
koffice@kde.org
To unsubscribe please visit:
https://mail.kde.org/mailman/listinfo/koffice
[prev in list] [next in list] [prev in thread] [next in thread]