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

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

Craig Ringer wrote: > On 24/06/10 12:42, Iwao Shikase wrote: > > > In my environment, Database cluster is in NFS server. > > So you are mounting an nfs file system shared by "localhost" ? > > Why not run PostgreSQL directly on the underlying file system, rather > than via nfs? > > > I guess tha

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

On Friday 25 June 2010 02:23:17 Iwao Shikase wrote: > Hi Roeleveld-san, > > Thank you for your advice. But My purpose is to test PostgreSQL > which data cluster is in NFS server. > As your says, Cluster Filesystem is one of answer of sharing files. > But my company still want to use NFS server. S

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

On 25/06/2010 8:23 AM, Iwao Shikase wrote: Hi Roeleveld-san, Thank you for your advice. But My purpose is to test PostgreSQL which data cluster is in NFS server. As your says, Cluster Filesystem is one of answer of sharing files. But my company still want to use NFS server. So I want to know ho

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

Hi Roeleveld-san, Thank you for your advice. But My purpose is to test PostgreSQL which data cluster is in NFS server. As your says, Cluster Filesystem is one of answer of sharing files. But my company still want to use NFS server. So I want to know how to use PostgreSQL using NFS. By the way,T

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

shik...@air.co.jp (Iwao Shikase) writes: > If I mount the database cluster with caching in my environment, What kind of >  problem I will meet? Please give the information about the problem you met. If you use NFS, and are not absolutely certain of the semantics of the implementation, then you are

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

On Thursday 24 June 2010 06:42:52 Iwao Shikase wrote: > Hi > > This is shikase. > I have a question about PostgreSQL on NFS Server as follows. > Please let me know advice about that. If I posted the wrong mailing-list, > please let me know. Why not use a real Cluster Filesystem? http://en.wikiped

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

Hello, Thank you for the information . I understood you never recommend the case. I have another question. I also use Linux in the case. There are NFS mount options , noac and sync which is concerned with caching. Which option means the keyword 'without caching' in the manual.? And the case you

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

Craig Ringer wrote: > On 24/06/10 12:42, Iwao Shikase wrote: > [...] >> If I mount the database cluster with caching in my environment, What kind of >> problem I will meet? Please give the information about the problem you met. > > It varies so much by NFS implementation and version that it i

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

On 24/06/10 12:42, Iwao Shikase wrote: > In my environment, Database cluster is in NFS server. So you are mounting an nfs file system shared by "localhost" ? Why not run PostgreSQL directly on the underlying file system, rather than via nfs? > I guess that, In my environment, the mount options

[GENERAL] The case of PostgreSQL on NFS Server

Hi This is shikase. I have a question about PostgreSQL on NFS Server as follows. Please let me know advice about that. If I posted the wrong mailing-list, please let me know. I found the manual 17.2.1 Network File System. 17.2.1 Network File System If client and server NFS implementations have