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

On Fri, Apr 3, 2015 at 1:40 AM, Octavi Fors wrote: > Hi David, John et al., > Oops, sorry yes I think I may "miss-spoke" when explaining my second reason > why not choosing eSATA. > My situation is the following: > > -Two computers (C1 & C2) and NAS (with no eSATA I/O) on the same LAN. > -C1 acqu

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

Hi David, John et al., as far as I understand eSATA is not an option for me. First because I >> already have bought the DS2415+ NAS, which does not has eSATA I/O :( >> And second, because I need the database to be accessible from two >> computers in the same LAN. >> > > ​This is new - and while th

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

On Thu, Apr 2, 2015 at 5:09 PM, Octavi Fors wrote: > Thanks John for your extensive and helpful response. > > I have a NAS box. But I would worry about responsiveness. What is >> better, IMO, is an external SATA connected DAS box. DAS is "Direct >> Attached Storage". Many PCs have a eSATA port on

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

On Apr 2, 2015, at 5:09 PM, Octavi Fors wrote: > > And second, because I need the database to be accessible from two computers > in the same LAN. If you do this, you will destroy your database[1]. Why not have the database running on one machine, all the time, potentially with a real disk s

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

On Thu, Apr 2, 2015 at 7:09 PM, Octavi Fors wrote: > Thanks John for your extensive and helpful response. > > You see that I used the ALTER from David in last message, instead your > suggestion of creating the whole database again. Looks good! > > Two only questions remain for me: > > 1) could

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

Thanks John for your extensive and helpful response. A few quick answers which may clarify my desktop-NAS system details: If you are running SELinux enabled & enforcing, it is even > more complicated. > -no, I'm not running SELinux. -My NAS is a Synology DS2415+

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

On Thu, Apr 2, 2015 at 3:01 PM, Octavi Fors wrote: > Hi, > > this is somehow overlapping one thread which was already posted in this list >here. > > However, I'm newbie in PostgreSQL and would need some help from experts on > two aspects. I apologize if these were already implicitely mentioned in

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

On Thu, Apr 2, 2015 at 1:01 PM, Octavi Fors wrote: > I don't see how to migrate the databases from my desktop directory > determined in a) to my NAS. Could someone please provide the steps to > accomplish that? > ALTER DATABASE name SET TABLESPACE new_tablespace ​You are solely responsible for

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

Hi, this is somehow overlapping one thread which was already posted in this list here . However, I'm newbie in PostgreSQL and would need some help from experts on two aspects. I apologize if these were already implicitely mentioned