Add pg server to cluster

From: AlannY <m(at)alanny(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: Add pg server to cluster
Date: 2009-12-07 15:35:20
Message-ID: 20091207153519.GA17786@alanny-pc.lcl.starlink.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi there.

I'm using PostgreSQL as my main database engine. Everything works.

I have one server for PostgreSQL, and space on it are lowing down.

I want to buy a new server and somehow connect it with first one, that
PostgreSQL will use this new server's HDD. I don't want to buy new HDD
for the first server, because I don't have a space in server box.

So, currently PostgreSQL data are located in /var/lib/pgsql/data
folder. If I connect new server, how should I connect new server's
folders to this directory, so PostgreSQL can add space for its data?

Or maybe it's unreal to do? Unreal to use several network folders for
data? I'm new in clustering... Maybe it's possible to split up data
folder (and the mount it via NFS, for example)?

Thanks for patients.

--
)\._.,--....,'``.
/, _.. \ _\ (`._ ,.
`._.-(,_..'--(,_..'`-.;.'

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-12-07 15:38:24 Re: Error_startup postgresql server
Previous Message Rob W 2009-12-07 15:33:16 Query using partitioned table hangs