"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
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
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
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
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
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
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).
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
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
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
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
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
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
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
14 matches
Mail list logo