Re: [GENERAL] database migration question between different ubuntus and different postgresql server versions

2015-04-16 Thread Octavi Fors
ounted via nfs with computer 2 (running ubuntu 14.04 postgresql 9.3). Any commands/help to migrate 'db' from comp1+NAS1 to comp2+NAS2 would be most than welcome. Cheers, Octavi. On Thu, Apr 16, 2015 at 8:35 PM, Adrian Klaver wrote: > On 04/16/2015 03:14 PM, Octavi Fors wrote: >

Re: [GENERAL] database migration question between different ubuntus and different postgresql server versions

2015-04-16 Thread Octavi Fors
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 da

[GENERAL] database migration question between different ubuntus and different postgresql server versions

2015-04-16 Thread Octavi Fors
week: CREATE TABLESPACE onNAS LOCATION '/NAS-box/pgsql-data'; CREATE DATABASE db TABLESPACE onNAS; I would appreciate if you could provide commands I can type to make me start with the process. Thanks in advance, Octavi Fors.

Re: [GENERAL] The case of PostgreSQL on NFS Server (II)

2015-04-02 Thread Octavi Fors
-postgresql-wal-located-how-can-i-specify-a-different-path> about the topic. Any ideas on how to include the options they mention (archinve_mode?) into NAS or /etc/fstab? Thanks a lot in advance, -- Octavi Fors On Thu, Apr 2, 2015 at 8:47 PM, David G. Johnston < david.g.johns...@gmail.com

Re: [GENERAL] The case of PostgreSQL on NFS Server (II)

2015-04-02 Thread Octavi Fors
sql/9.2/main ? 2) on my my /etc/fstab here is the current line for my NAS: nas_ip:/volume1/data /home/ofors/Documents/nas nfs Which NFS client and server (on NAS side) options/arguments do you suggest for optimizing performance? Or in other words, for minimizing database corruption in case of NAS (n

[GENERAL] The case of PostgreSQL on NFS Server (II)

2015-04-02 Thread Octavi Fors
ow to migrate the databases from my desktop directory determined in a) to my NAS. Could someone please provide the steps to accomplish that? Thanks so much in advance, -- Octavi Fors