I just want to transfer only one db in pg 8.2.5 to pg 8.3.3, others
are still remained on pg 8.2.5.
I call the only one db as "db-foo", and the db owner as "user-foo" following.
The IP for pg 8.2.5 is 10.10.10.1 , IP for pg 8.3.3 is 10.10.10.2.
My operations are listed below:
1. install a new 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
dump to backup your databases? Taking
> file-level snapshots is not recommended as you may want/need to restore to a
> different version of PG that is not binary compatible with the snapshot
> you've taken.
> Regards,
> - Naz.
>
>
> ProAce wrote:
> I already put the d
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
> First idea:
> I install the pgpool on each web server (the web server farm include
> 16 web servers), and configure the pgpool as replication mode. The web
> application (written by php) access to the db server through the local
> pgpool daemon.
> The idea sounds a little unusual, dose it seems
the db
server through the pgpool daemon.
Third idea:
I install the Slony-I, linux-ha and postgresql on the same server of
the two 2U servers. The web application access to the db server
directly and without pgpool.
sincerely,
proace
---(end of broadcast
