On 04/16/2015 05:52 PM, Octavi Fors wrote:
Hi Adrian,
I didn't received any answer from Andrews.
Yes, sorry I didn't describe completely my migration plan.
Right now the database 'db' is in NAS1 mounted via nfs with computer 1
(running ubuntu 12.04 postgresql 9.2).
I want to migrate 'db' to a
On Thu, Apr 16, 2015 at 02:38:56PM -0700, Adrian Klaver wrote:
Well it is an upgrade from one major version to another, so you have the
following options using Postgres core utilities:
And, if you don't want to use core utilities, you can use one of the
trigger-based replication systems to move
Dear all,
I have one newbie question which I hope one kind soul of this list can help
me.
The situation is that I have two postgresql servers:
-9.2 running on Ubuntu 12.04 with a database 'db' already created and
populated with data,
-9.3 running on Ubuntu 14.04.02 with no database created
On 04/16/2015 02:01 PM, Octavi Fors wrote:
Dear all,
I have one newbie question which I hope one kind soul of this list can
help me.
The situation is that I have two postgresql servers:
-9.2 running on Ubuntu 12.04 with a database 'db' already created and
populated with data,
-9.3
On Thu, Apr 16, 2015 at 06:14:20PM -0400, Octavi Fors wrote:
at first glance, option 1) seems to me simpler. But does it guarantee
server version upgrade compatibility?
Yes. Use the pg_dump from the later postgres, which can read old
versions and generate any output needed for the new version.
Hi Adrian,
I didn't received any answer from Andrews.
Yes, sorry I didn't describe completely my migration plan.
Right now the database 'db' is in NAS1 mounted via nfs with computer 1
(running ubuntu 12.04 postgresql 9.2).
I want to migrate 'db' to a faster NAS2 mounted via nfs with computer 2
On 04/16/2015 03:14 PM, Octavi Fors wrote:
Hi Adrian,
at first glance, option 1) seems to me simpler. But does it guarantee
server version upgrade compatibility?
Could you/someone please provide an example of commands which I could use?
See Andrews answer.
There is the matter of the
Hi Adrian,
at first glance, option 1) seems to me simpler. But does it guarantee
server version upgrade compatibility?
Could you/someone please provide an example of commands which I could use?
Thanks a lot,
Octavi.
On Thu, Apr 16, 2015 at 5:38 PM, Adrian Klaver adrian.kla...@aklaver.com