Re: [GENERAL] Postgres on shared network drive

2008-04-12 Thread Gregory Stark
"Pavan Deolasee" <[EMAIL PROTECTED]> writes: > I am not suggesting one read-write and many read-only architecture. I am > rather suggesting all read-only systems. I would be interested in this > setup if I run large read-only queries on historical data and need easy > scalability. With read-only

Re: [GENERAL] Postgres on shared network drive

2008-04-12 Thread Peter Wilson
Pavan Deolasee wrote: [...] I am not suggesting one read-write and many read-only architecture. I am rather suggesting all read-only systems. I would be interested in this setup if I run large read-only queries on historical data and need easy scalability. With read-only setup, you can easily

Re: [GENERAL] Postgres on shared network drive

2008-04-12 Thread Dawid Kuroczko
On Sat, Apr 12, 2008 at 8:11 PM, Pavan Deolasee <[EMAIL PROTECTED]> wrote: > On Sat, Apr 12, 2008 at 11:00 PM, Dawid Kuroczko <[EMAIL PROTECTED]> wrote: > > Not quite workable. Remember that table data is not always available on > > the block device -- there are pages modified in the buffer ca

Re: [GENERAL] Postgres on shared network drive

2008-04-12 Thread Pavan Deolasee
On Sat, Apr 12, 2008 at 11:00 PM, Dawid Kuroczko <[EMAIL PROTECTED]> wrote: > > Not quite workable. Remember that table data is not always available on > the block device -- there are pages modified in the buffer cache (shared > memory), and other machines have no access to the other's shared

Re: [GENERAL] Postgres on shared network drive

2008-04-12 Thread Dawid Kuroczko
On Fri, Apr 11, 2008 at 2:54 PM, Craig Ringer <[EMAIL PROTECTED]> wrote: > Pavan Deolasee wrote: > > I wonder if it would make sense to add support to mount database in > > *read-only* mode from multiple servers though. I am thinking about > > data warehouse kind of operations where multiple server

Re: [GENERAL] Postgres on shared network drive

2008-04-11 Thread Craig Ringer
Pavan Deolasee wrote: I wonder if it would make sense to add support to mount database in *read-only* mode from multiple servers though. I am thinking about data warehouse kind of operations where multiple servers can be used answer read-only queries. Is there a use case for such applications in

Re: [GENERAL] Postgres on shared network drive

2008-04-11 Thread J Ottery
On Apr 11, 5:34 pm, [EMAIL PROTECTED] ("A. Kretschmer") wrote: > am Thu, dem 10.04.2008, um 23:53:18 -0700 mailte J Ottery folgendes: > > > Using windows XP and TCP/IP network. > > > I install PostgreSQL on a client PC and put the data files on a > > networked drive (instead of the local drive).

Re: [GENERAL] Postgres on shared network drive

2008-04-11 Thread Pavan Deolasee
On Fri, Apr 11, 2008 at 1:04 PM, A. Kretschmer <[EMAIL PROTECTED]> wrote: > > > You idea is complete ill. PostgreSQL is a Server-Client-database, with > one Server and multiple Clients. You can't access to the same > database-files with multiple database-servers. > I wonder if it would make sen

Re: [GENERAL] Postgres on shared network drive

2008-04-11 Thread A. Kretschmer
am Thu, dem 10.04.2008, um 23:53:18 -0700 mailte J Ottery folgendes: > Using windows XP and TCP/IP network. > > I install PostgreSQL on a client PC and put the data files on a > networked drive (instead of the local drive). Postgres as user and > localport. This works well. > > Now I install po

Re: [GENERAL] Postgres on shared network drive

2008-04-11 Thread Magnus Hagander
Tomasz Ostrowski wrote: > On 2008-04-11 08:53, J Ottery wrote: > > > I install PostgreSQL on a client PC and put the data files on a > > networked drive (instead of the local drive). Postgres as user and > > localport. This works well. > > This is not the way it is meant to work, and it can eat

Re: [GENERAL] Postgres on shared network drive

2008-04-11 Thread Craig Ringer
J Ottery wrote: Thanks so much Craig. I have decided to migrate to Postgres and most of my applications are single computer based but I need to plan for future needs. Some research is in order for me. All you should need to do is allow the user / administrator to configure the connection sett

Re: [GENERAL] Postgres on shared network drive

2008-04-11 Thread Craig Ringer
J Ottery wrote: Using windows XP and TCP/IP network. I install PostgreSQL on a client PC and put the data files on a networked drive (instead of the local drive). Postgres as user and localport. This works well. I wouldn't personally trust this setup. Now I install postgresSQL on another cl

Re: [GENERAL] Postgres on shared network drive

2008-04-11 Thread Tomasz Ostrowski
On 2008-04-11 08:53, J Ottery wrote: > I install PostgreSQL on a client PC and put the data files on a > networked drive (instead of the local drive). Postgres as user and > localport. This works well. This is not the way it is meant to work, and it can eat your data. > Now I install postgresSQ

[GENERAL] Postgres on shared network drive

2008-04-11 Thread J Ottery
Using windows XP and TCP/IP network. I install PostgreSQL on a client PC and put the data files on a networked drive (instead of the local drive). Postgres as user and localport. This works well. Now I install postgresSQL on another client machine and point it to the same data directory on the n