In response to ProAce <proace@xxxxxxxxx>: > I use SAN, not NAS. :) > > Because some bugdet issue, I just have a basic SAN environment. > For multipathing, I use geom_fox to complete. > For snapshot, I want to use mksnap_ffs. > > But I don't have any experience of using mksnap_ffs to backup pgsql. > Does anyone give me some advice? If you don't want to do PITR, read this: http://www.postgresql.org/docs/8.2/static/backup-file.html You can also use the mount command to make filesystem snapshots. Assuming your PG data directory is under the mount point /var/db: mount -o snapshot -u /var/db/snapshot /var/db mdconfig -a -t vnode -f /var/db/snapshot -u 4 mount -r /dev/md4 /mnt [ ... do whatever you do to back up /mnt (which is the snapshot of /var/db ...] umount /mnt mdconfig -d -u 4 rm /var/db/snapshot > 2007/8/2, Bill Moran <wmoran@xxxxxxxxxxxxxxxxx>: > > > > Maybe. I'm confused by your question, but: > > * If the data directory is on an FFS2 volume on a FreeBSD machine, you > > can use mksnap_ffs to back it up, and that approach is actually > > recommended for PITR-type backups. > > * If the data is mounted via NFS or something similar and the filesystem > > is not FFS2, then snapshots are not available on FreeBSD. > > > > -- > > Bill Moran > > http://www.potentialtech.com > > -- Bill Moran http://www.potentialtech.com ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
