On Thu, Aug 02, 2007 at 09:49:42PM +0800, ProAce wrote:
> The size of my db is more then 50GB , so I consider that the pg_dump
> is not a good backup tool for me.
> And, sometimes, I need query data which is some days ago ( between 1 ~
> 14 days ).
>
> If I want to transfer my db to different PG v
In response to ProAce <[EMAIL PROTECTED]>:
> 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 pg
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?
2007/8/2, Bill Mor
The size of my db is more then 50GB , so I consider that the pg_dump
is not a good backup tool for me.
And, sometimes, I need query data which is some days ago ( between 1 ~
14 days ).
If I want to transfer my db to different PG version, I will use slony-I. :)
I worried that mksnap_ffs spend muc
In response to ProAce <[EMAIL PROTECTED]>:
> I already put the data directory on hds san storage, but there is no
> snapshot license on it.
> Could I use mksnap_ffs under freebsd to make snapshot for backup ?
Maybe. I'm confused by your question, but:
* If the data directory is on an FFS2 volume
I already put the data directory on hds san storage, but there is no
snapshot license on it.
Could I use mksnap_ffs under freebsd to make snapshot for backup ?
---(end of broadcast)---
TIP 6: explain analyze is your friend
