Here's PostgreSQL-based sharding solution which provides both
read/write horizontal scalability.
http://sourceforge.net/apps/mediawiki/postgres-xc/index.php?title=Main_Page
http://sourceforge.net/projects/postgres-xc/
Hope this helps.
---
Koichi Suzuki
2014-06-03 3:47 GMT+09:00 Sébastien Lorion
Thank You for your suggestions.
In silent installation we use the following code in vb.net to install
postgres
xinststr =" --mode unattended --superaccount
--superpassword--serviceaccount
--servicepassword--serverport --unattendedmodeui
none "
*For 64 bit windows*
Shell(Applicatio
On 06/03/2014 10:58 PM, Kalai R wrote:
Hi,
Yesterday the psql service stopped in our two customers's machines
See comments inline below.
Windows OS ---> Windows XP
We re-installed the postgresql to solve the problem.
Except from what you have indicated it does not solve the problem, jus
On 06/03/2014 10:02 PM, sramay wrote:
Sir,
No it is reporting that base table is missing not the TOAST table.
Is Streaming Replication can cause this issue?.
What is the exact error message Tomcat is reporting?
Data is not being
aged which is much. As the records add during this period on
On Wed, Jun 4, 2014 at 9:21 AM, Tom Lane wrote:
>
> If your input data is uniformly incompressible, that's not too surprising.
> pg_largeobject tuples hold BLCKSZ/4 bytes of data, plus some overhead, so
> the only way that 4 of them will fit on a page is if compression saves
> more than the overh
Peter Eisentraut-2 wrote
> On 5/29/14, 11:59 AM, Bob Moyers wrote:
>> When I try this update:
>>
>> UPDATE REPORT_STYLE SET JASPER_STYLE = XMLPARSE(DOCUMENT ?) WHERE
>> (REPORT_STYLE_NAME = ?)
>>
>>
>>
>> I get:
>>
>> org.postgresql.util.PSQLException: ERROR: invalid XML content
>>
>> Detail
On Mon, Jun 2, 2014 at 2:47 PM, Sébastien Lorion
wrote:
> On Mon, Jun 2, 2014 at 12:52 PM, Kevin Goess wrote:
>
>> > So my conclusion is that for now, the best way to scale read-only
>> queries for a sharded master is to
>> > implement map-reduce at the application level.
>>
>> That's the conclu
On 5/29/14, 11:59 AM, Bob Moyers wrote:
> When I try this update:
>
> UPDATE REPORT_STYLE SET JASPER_STYLE = XMLPARSE(DOCUMENT ?) WHERE
> (REPORT_STYLE_NAME = ?)
>
>
>
> I get:
>
> org.postgresql.util.PSQLException: ERROR: invalid XML content
>
> Detail: line 2: StartTag: invalid element nam
Jason Newton writes:
> I spent some time trying to get things to work as is, raising what limits I
> could to no avail. So I decided to upgrade to 9.3 and use large binary
> objects rather than making another file store due to a large convenience
> of keeping everything in database. I noticed t
>
>
> From: Tom Lane
>
> Hm, can you restore it into 9.2 either?
>
> AFAICS, pg_dump has absolutely no idea that it should be worried about the
> value of xmloption, despite the fact that that setting affects what is
> considered valid XML data. What's worse, even if it were attempting to do
I wanted to share an experience that we had this morning, after the
upgrade from postgres 9.2.7 to postgres 9.3.4 on our production system.
(The data set was upgraded in QA without issues,but I rather suspect
that I had done a full 'vacuum' on that data set more recently). NOTE:
this was within a
Tim Kane writes:
> Iâm migrating a database from 9.2.4 to 9.3.0 and encountering an issue with
> an XML field failing to restore.
Hm, can you restore it into 9.2 either?
AFAICS, pg_dump has absolutely no idea that it should be worried about the
value of xmloption, despite the fact that that se
Hi all,
I’m migrating a database from 9.2.4 to 9.3.0 and encountering an issue with an
XML field failing to restore.
I’m using pg_dump 9.3.0 as follows (with 9.2.4 on 5433 and 9.3.0 on 5432). I
have verified my paths, it’s definitely using the 9.3.0 binaries. Both source
and target are using
Sir,
No it is reporting that base table is missing not the TOAST table.
Is Streaming Replication can cause this issue?. Data is not being
aged which is much. As the records add during this period on the base
table
which is hardly 300 MB ( 3million records) . the db size 700 GB.
Version I am
Hi,
Some scope of setting: I use postgres to manage metadata about field tests
and simulations part of that involves HDF5 files. These hdf5 files are
generated both with field testing and simulations so there's going to be a
modest amount of them - in the 10k region eventually - an older database
On 06/04/2014 05:20 AM, Bhushan Pathak wrote:
Hello,
I have installed the following RPM on CentOS 6.5 64 bit -
uuid-1.5.1-4.rhel5.x86_64
postgresql92-contrib-9.2.4-1PGDG.rhel5.x86_64
postgresql92-9.2.4-1PGDG.rhel5.x86_64
postgresql92-server-9.2.4-1PGDG.rhel5.x86_64
postgresql92-libs-9.2.4-1PGDG.
Hi,
On Wed, 2014-06-04 at 17:50 +0530, Bhushan Pathak wrote:
> The RPM get installed successfully, but when I issue the "service
> postgresql-9.2 initdb" command, it gets stuck for 5-10 minutes & then
> says failed. The pgstartup.log file has only 1 line -
> Segmentation fault (core dumped)
Can
Tim Kane wrote
> I suspect this might be resolved in a newer point release of 9.3, however
> I
> don’t have the luxury on this particular host right now.
>
> Any suggestions how I might convince 9.3.0 to accept the dump from 9.2.4?
Given the history of 9.3 if you cannot use the most current point
Hello,
I have installed the following RPM on CentOS 6.5 64 bit -
uuid-1.5.1-4.rhel5.x86_64
postgresql92-contrib-9.2.4-1PGDG.rhel5.x86_64
postgresql92-9.2.4-1PGDG.rhel5.x86_64
postgresql92-server-9.2.4-1PGDG.rhel5.x86_64
postgresql92-libs-9.2.4-1PGDG.rhel5.x86_64
Kernel version is -
kernel-2.6.32-
Hi all,
I’m migrating a database from 9.2.4 to 9.3.0 and encountering an issue with
an XML field failing to restore.
I’m using pg_dump 9.3.0 as follows (with 9.2.4 on 5433 and 9.3.0 on 5432).
I have verified my paths, it’s definitely using the 9.3.0 binaries. Both
source and target are using UTF8
Hi,
Some scope of setting: I use postgres to manage metadata about field tests
and simulations part of that involves HDF5 files. These hdf5 files are
generated both with field testing and simulations so there's going to be a
modest amount of them - in the 10k region eventually - an older database
I just figured it out :-
I just figured it out :-
yelloday_development=# select id, workplace_ids from reporting_groups ;
id | workplace_ids
+---
2 | {}
3 | {}
1 | {}
5 | {2}
4 | {1}
(5 rows)
yelloday_development=# select id, workplace_ids from reporting_groups where
22 matches
Mail list logo
