Στις Tuesday 21 December 2010 03:23:25 ο/η sn...@email.it έγραψε:
> Hi everybody,
> I'm trying to figure out a way to setup a PostgreSQL HA cluster solution.
>
> I've done some research and I've an idea of different possible solutions,
> but I'd honestly like to implement it using CARP in a "Share
Hi Kevin, Scott.
Thank you for your response.
Data duplication happened on source server (that is, on production
environment). This data duplication affected only on some tables, with
some duplicated PKs and altered sequences (sequences value didn't match
"select max()" and we had to fix it manua
> On Mon, Dec 20, 2010 at 8:03 PM, wrote:
> >> On Mon, Dec 20, 2010 at 6:23 PM, wrote:
> > Well, I'd prefer a big single storage instead of "too many spinning
disks"
> > around mainly for maintenance reasons, to avoid replication and too much
> > network traffic.
>
> Sure, but that then makes
On Mon, Dec 20, 2010 at 8:03 PM, wrote:
>> On Mon, Dec 20, 2010 at 6:23 PM, wrote:
> Well, I'd prefer a big single storage instead of "too many spinning disks"
> around mainly for maintenance reasons, to avoid replication and too much
> network traffic.
Sure, but that then makes your single po
> On Mon, Dec 20, 2010 at 6:23 PM, wrote:
> > Hi everybody,
> > I'm trying to figure out a way to setup a PostgreSQL HA cluster
solution.
> >
> > For the record:
> > - I've already tried pgpool-II 2.x in Synchronous Multi Master
Replication
> > mode and I was satisfied by it's functionality but c
On Mon, Dec 20, 2010 at 6:23 PM, wrote:
> Hi everybody,
> I'm trying to figure out a way to setup a PostgreSQL HA cluster solution.
>
> For the record:
> - I've already tried pgpool-II 2.x in Synchronous Multi Master Replication
> mode and I was satisfied by it's functionality but concerned about
Hi everybody,
I'm trying to figure out a way to setup a PostgreSQL HA cluster solution.
For the record:
- I've already tried pgpool-II 2.x in Synchronous Multi Master Replication
mode and I was satisfied by it's functionality but concerned about having
the same data growing on several nodes
- I've
On Mon, Dec 20, 2010 at 12:22 PM, Iñigo Martinez Lasala
wrote:
> Good evening.
>
> Yesterday we experienced some data duplication in several database tables
> after one sysadmin decided to test in a production environment an rsync
> script in order to migrate a database from one server to another
IñigoMartinez Lasala wrote:
> Yesterday we experienced some data duplication in several database
> tables after one sysadmin decided to test in a production
> environment an rsync script in order to migrate a database from
> one server to another one.
> Postgresql (8.2) was running in source ser
Good evening.
Yesterday we experienced some data duplication in several database
tables after one sysadmin decided to test in a production environment an
rsync script in order to migrate a database from one server to another
one.
Postgresql (8.2) was running in source server and rsync script was
l
Lou Picciano wrote:
> Is any 'upgrade' required to move a 9.0.1 cluster to 9.0.2?
The "general rule" on this is here:
http://www.postgresql.org/support/versioning
To quote from that page:
| Upgrading to a minor release does not require a dump and restore;
| merely stop the database serve
work_mem is not set in the config file, so it's using the default setting..
On Mon, Dec 20, 2010 at 9:34 AM, Scott Marlowe wrote:
> On Mon, Dec 20, 2010 at 6:41 AM, Benoit Clennett-Sirois
> wrote:
>> Hi,
>>
>> We have a front-end server taking care of Nginx, memcached and
>> Postgresql. Last nig
On Mon, Dec 20, 2010 at 8:06 AM, Lou Picciano wrote:
> Gang,
> Is any 'upgrade' required to move a 9.0.1 cluster to 9.0.2? TIA, Lou
No, just upgrade the binaries and bounce your cluster.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
h
Gang,
Is any 'upgrade' required to move a 9.0.1 cluster to 9.0.2? TIA, Lou
On Mon, Dec 20, 2010 at 9:29 AM, wrote:
> Zitat von Benoit Clennett-Sirois :
>
>> Hi,
>>
>> We have a front-end server taking care of Nginx, memcached and
>> Postgresql. Last night the postgres daemon crashed (traffic was very
>> low at that time) with the following error:
>>
>> 2010-12-20 03:34:
On Mon, Dec 20, 2010 at 6:41 AM, Benoit Clennett-Sirois
wrote:
> Hi,
>
> We have a front-end server taking care of Nginx, memcached and
> Postgresql. Last night the postgres daemon crashed (traffic was very
> low at that time) with the following error:
>
> 2010-12-20 03:34:30 EST DETAIL: Failed s
Zitat von Benoit Clennett-Sirois :
Hi,
We have a front-end server taking care of Nginx, memcached and
Postgresql. Last night the postgres daemon crashed (traffic was very
low at that time) with the following error:
2010-12-20 03:34:30 EST DETAIL: Failed system call was
shmget(key=5432001, siz
Hi,
We have a front-end server taking care of Nginx, memcached and
Postgresql. Last night the postgres daemon crashed (traffic was very
low at that time) with the following error:
2010-12-20 03:34:30 EST DETAIL: Failed system call was
shmget(key=5432001, size=1124474880, 03600).
2010-12-20 03:34
18 matches
Mail list logo