On Wed, Nov 26, 2014 at 11:47 AM, Bill Moran
wrote:
> On Wed, 26 Nov 2014 10:41:56 +1100
> Sanjaya Vithanagama wrote:
> >
> > > * How frequently do deadlocks occur?
> >
> > We are seeing deadlocks about 2-3 times per day in the production server.
> > To reproduce the problem easily we've written
On Tue, Nov 25, 2014 at 6:37 PM, Sameer Kumar wrote:
>
> On Fri, Oct 24, 2014 at 8:01 PM, Michael Paquier
> wrote:
>>
>> On Fri, Oct 24, 2014 at 12:30 AM, John Smith
>> wrote:
>> >
>> > i want to setup a warm standby that listens 24/7 but only syncs when
>> > told to (ie only when i am ok with t
On Wed, 26 Nov 2014 15:40:53 -0600
Daniel Torres wrote:
> Hi everyone,
>
> sorry to bother you with a simple question, (I'm a new user of postgresql),
> how do I change the data type of a column of text, to numeric or integer?
>
> I tried with:
>
> ALTER TABLE table_name
> ALTER COLUMN col_na
Daniel Torres wrote
> Hi everyone,
>
> sorry to bother you with a simple question, (I'm a new user of
> postgresql),
> how do I change the data type of a column of text, to numeric or integer?
>
> I tried with:
>
> ALTER TABLE table_name
> ALTER COLUMN col_name TYPE integer
> ;
>
> It gives me
Hi everyone,
sorry to bother you with a simple question, (I'm a new user of postgresql),
how do I change the data type of a column of text, to numeric or integer?
I tried with:
ALTER TABLE table_name
ALTER COLUMN col_name TYPE integer
;
It gives me a mistake
ERROR: la columna no puede conver
On Wednesday, November 26, 2014, Adrian Klaver
wrote:
> On 11/26/2014 12:34 PM, David Johnston wrote:
>
>>
>> I guess what is confusing to me is the transition between the text
>> mode and the constructor mode is not clear. In particular the page
>> starts with examples using the cons
On 11/26/2014 12:34 PM, David Johnston wrote:
I guess what is confusing to me is the transition between the text
mode and the constructor mode is not clear. In particular the page
starts with examples using the constructor mode but then goes to
explanations that actually apply to
> I guess what is confusing to me is the transition between the text mode
> and the constructor mode is not clear. In particular the page starts with
> examples using the constructor mode but then goes to explanations that
> actually apply to the text mode before getting back to explaining the
> co
On 11/26/2014 11:07 AM, David G Johnston wrote:
Adrian Klaver-4 wrote
I will leave it to philosophers to decide whether NULL is empty, but it
seems the documentation could be more explicit on what constitutes empty
in the text versus constructor method of creating a range.
Would it be sufficie
Is BDR still in beta?
Here’s the postgres wiki with a chart:
https://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling
From: pgsql-admin-ow...@postgresql.org
[mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Greg Spiegelberg
Sent: Wednesday, November 26, 2014 2:20 P
There is BDR (Bi-Directional Replication) from 2ndQuadrant available in 9.4.
http://2ndquadrant.com/en/resources/bdr/
-Greg
On Wed, Nov 26, 2014 at 11:09 AM, Leonardo Carneiro
wrote:
> It look's like you're searching for Postgres equivalent of Oracle RAC. I
> don't know if there is any soluti
Adrian Klaver-4 wrote
> I will leave it to philosophers to decide whether NULL is empty, but it
> seems the documentation could be more explicit on what constitutes empty
> in the text versus constructor method of creating a range.
Would it be sufficient to simply add another paragraph:
"The lo
Thanks Bill !
On Wed, Nov 26, 2014 at 9:07 AM, Bill Moran
wrote:
> In addition to what you're getting from that query, include the xact_start
> and
> state_change columns from pg_stat_activity. My guess is that your code is
> starting a transaction, then running a query, then processing the quer
I am trying out the range types:
http://www.postgresql.org/docs/9.3/interactive/rangetypes.html
and got confused by the documentation wording for specifying no lower or
upper bound:
"The lower-bound may be either a string that is valid input for the
subtype, or empty to indicate no lower bou
* Suzuki Hironobu (hiron...@interdb.jp) wrote:
> (2014/11/27 2:20), John R Pierce wrote:
> >On 11/26/2014 2:36 AM, Postgres India wrote:
> >>I am looking for PostgreSQL active/active clustering and whether
> >>PostgreSQL support any form of shared-storage clustering . Is there
> >>any methods or t
(2014/11/27 2:20), John R Pierce wrote:
On 11/26/2014 2:36 AM, Postgres India wrote:
I am looking for PostgreSQL active/active clustering and whether
PostgreSQL support any form of shared-storage clustering . Is there
any methods or tools for implementing active/active clustering on
Postgres su
It look's like you're searching for Postgres equivalent of Oracle RAC. I
don't know if there is any solution to do this right now in the postgres
On Wed, Nov 26, 2014 at 8:36 AM, Postgres India
wrote:
> Hi All,
>
> I am looking for PostgreSQL active/active clustering and whether PostgreSQL
> su
On 11/26/2014 2:36 AM, Postgres India wrote:
I am looking for PostgreSQL active/active clustering and whether
PostgreSQL support any form of shared-storage clustering . Is there
any methods or tools for implementing active/active clustering on
Postgres supported by community or any third party
Currently I use FreeBSD 10 with ZFS filesystem for our Production database.
Speed wise it's fine, i'm sure other filesystems could be faster, even
though we have never compared it with other filesystems. The reason we do
ZFS is to take advantage of the data compression and snapshots. It is very
eas
M Tarkeshwar Rao writes:
> We are facing following issue in postgresql 9.1.3 in using arrow key in
> Solaris platform.
> Can you please help us to resolve it or any new release has fix for this or
> any workaround for this?
> issue: psql client generates a core when up arrow is used twice.
Almo
On 11/25/2014 12:39 AM, Deepti Sharma S wrote:
Hello Team,
I am working for Ericsson Multi Mediation product and we are using
Postgresql as DB in our product.
Please let me know the latest Postgresql DB version available on RHEL ?
I do not have a RHEL 7 instance available, but looking at the
Hello Team,
I am working for Ericsson Multi Mediation product and we are using Postgresql
as DB in our product.
Please let me know the latest Postgresql DB version available on RHEL ?
Which Postgresql DB version will be supported on RHEL 7.x version and when the
same will be available ?
Reg
On 11/26/2014 4:16 AM, Maila Fatticcioni wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/25/2014 05:54 PM, Bill Moran wrote:
On Tue, 25 Nov 2014 17:27:18 +0100 Christoph Berg
wrote:
Re: Bill Moran 2014-11-25
<20141125111630.d05d58a9eb083c7cf80ed...@potentialtech.com>
Anything wit
On 11/26/2014 02:16 AM, M Tarkeshwar Rao wrote:
Hi all,
We are facing following issue in postgresql 9.1.3 in using arrow key in
Solaris platform.
*Can you please help us to resolve it or any new release has fix for
this or any workaround for this?*
Would seem to me to be an interaction betwee
Hi All,
I am looking for PostgreSQL active/active clustering and whether PostgreSQL
support any form of shared-storage clustering . Is there any methods or
tools for implementing active/active clustering on Postgres supported by
community or any third party tools.
Regards
Manmohan
Hi all,
We are facing following issue in postgresql 9.1.3 in using arrow key in Solaris
platform.
Can you please help us to resolve it or any new release has fix for this or any
workaround for this?
issue: psql client generates a core when up arrow is used twice.
Platfrom: Solaris
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/25/2014 05:54 PM, Bill Moran wrote:
> On Tue, 25 Nov 2014 17:27:18 +0100 Christoph Berg
> wrote:
>
>> Re: Bill Moran 2014-11-25
>> <20141125111630.d05d58a9eb083c7cf80ed...@potentialtech.com>
>>> Anything with a journal is a performance problem.
27 matches
Mail list logo
