On Wed, Mar 5, 2014 at 2:14 PM, leo wrote:
>I find a solution to short the recover time by configure parameter
> Synchronous Transfer. Refer to :
> https://wiki.postgresql.org/wiki/Synchronous_Transfer.
>But I don't which postgreSQL will enable this parameter, I install
> 9.3.3-1 on redha
I find a solution to short the recover time by configure parameter
Synchronous Transfer. Refer to :
https://wiki.postgresql.org/wiki/Synchronous_Transfer.
But I don't which postgreSQL will enable this parameter, I install
9.3.3-1 on redhat, but I don't find this parameter in postgresql.conf.
On Tue, Mar 4, 2014 at 6:26 PM, leo wrote:
> I wonder how to quickly recovery failed master? If I directly startup the
> failed master as slave ( assign proper parameter), is there any problem?
Yep, if the master has got ahead of the slave in term of WAL replay
where WAL forked after the slave pro
On Tue, Mar 4, 2014 at 9:19 PM, David Janssens wrote:
> Hello,
> I would like to log statements that modify a small subset of tables in a
> databases.
> (not all tables, because the log files become too big in that case and I
> also worry about performance)
> I currently use log_statement='mod' bu
On 03/04/2014 01:40 PM, Merlin Moncure wrote:
On Tue, Mar 4, 2014 at 2:15 PM, Kevin Grittner wrote:
Roy Anderson wrote:
We have an OLTP database and no data warehouse. We are currently
planning out a build for a data warehouse however (possibly using
Hadoop). "X" is recommending that we conv
Merlin Moncure-2 wrote
> On Tue, Mar 4, 2014 at 1:49 PM, Owen Hartnett <
> owen@
> > wrote:
>
>> It looks like I should be able to use the window function to do this,
>> but
>> I've been unsuccessful. The following runs, but doesn't seem to have any
>> effect:
>>
>> select owner_id, array_agg(
On Tue, Mar 4, 2014 at 2:15 PM, Kevin Grittner wrote:
> Roy Anderson wrote:
>
>> We have an OLTP database and no data warehouse. We are currently
>> planning out a build for a data warehouse however (possibly using
>> Hadoop). "X" is recommending that we convert our current,
>> normalized OLTP da
Roy Anderson wrote:
> We have an OLTP database and no data warehouse. We are currently
> planning out a build for a data warehouse however (possibly using
> Hadoop). "X" is recommending that we convert our current,
> normalized OLTP database into a flattened Star Schema.
I'm not going to repeat
David Janssens writes:
> Hello,
> I would like to log statements that modify a small subset of tables in
> a databases.
> (not all tables, because the log files become too big in that case and
> I also worry about performance)
> I currently use log_statement='mod' but I didn't find a way to limit
On Tue, Mar 4, 2014 at 1:49 PM, Owen Hartnett wrote:
> Hi all:
>
> I have a table that has multiple records for a single owner_id. I'm able to
> use array_arg to combine the records into a single row, which works fine.
> I'm using this sql:
>
> select owner_id, array_agg(trim(maplot)), array_agg(
Hi all:
I have a table that has multiple records for a single owner_id. I'm able to
use array_arg to combine the records into a single row, which works fine. I'm
using this sql:
select owner_id, array_agg(trim(maplot)), array_agg(revallandvalue +
revalbuildingvalues) from parcel group by own
thanks for the reply ,..
When i am trying to enter anything else other then some Arabic , Hindi ..
that case it does not give this error.
like if i enter..
insert into table values('welcome',1);
then it does not give any error and get successfully
Thanks
--
View this message in context:
http
On 03/04/2014 06:00 AM, François Beausoleil wrote:
Le 2014-03-03 à 10:53, Adrian Klaver a écrit :
On 03/02/2014 08:48 PM, François Beausoleil wrote:
Hi all,
I have four roles involved:
meetphil - the database owner, should not login
mpwebui - the role the web application logs in as, should
Hello,
I ran into trouble with an xpath expression on a large XML file:
SELECT id, xpath('//tei:div/descendant::tei:head/text()', x, ARRAY[ARRAY['tei',
'http://www.tei-c.org/ns/1.0']]) AS stuff FROM test WHERE id=1;
returns:
ERROR: could not parse XML document
DETAIL: line 491482: internal e
On 03/04/2014 07:39 AM, Adrian Klaver wrote:
CCing list:
On 03/04/2014 03:03 AM, ajay wrote:
hello team ,
i am trying to enter this insert command in postgres
insert into mmsuper.notification
values('101','12','13','حب|welcome|आपकास्वागतहै','bye','goodbye','low
balance',5);
now when i am try
On 03/04/2014 03:03 AM, ajay wrote:
hello team ,
i am trying to enter this insert command in postgres
insert into mmsuper.notification
values('101','12','13','حب|welcome|आपकास्वागतहै','bye','goodbye','low
balance',5);
now when i am trying to paste this in postgres in Solaris , it is giving me
er
ajay writes:
> hello team ,
> i am trying to enter this insert command in postgres
> insert into mmsuper.notification
> values('101','12','13','Øب|welcome|à¤à¤ªà¤à¤¾à¤¸à¥à¤µà¤¾à¤à¤¤à¤¹à¥','bye','goodbye','low
> balance',5);
> now when i am trying to paste this in postgres in Solaris , it
Tom Lane wrote:
> Albe Laurenz writes:
>> Is there anything that "varchar_pattern_ops" is needed for that
>> "text_pattern_ops" cannot provide?
>
> Lack of surprise? If you're creating a pattern index on a varchar column,
> you'd likely expect to need to mention varchar_pattern_ops.
>
> The idea
On Mar 4, 2014, at 2:19 AM, David Janssens wrote:
> Hello,
> I would like to log statements that modify a small subset of tables in a
> databases.
> (not all tables, because the log files become too big in that case and I also
> worry about performance)
> I currently use log_statement='mod' bu
hello team ,
i am trying to enter this insert command in postgres
insert into mmsuper.notification
values('101','12','13','حب|welcome|आपकास्वागतहै','bye','goodbye','low
balance',5);
now when i am trying to paste this in postgres in Solaris , it is giving me
error
fm_db_Server1-# insert into m
On 03/04/2014 04:48 AM, loref85 wrote:
So, there's no way to do this?
In your original post you said you found a version of odbc_fdw that
compiled for 9.2+, but hung on a select due to this error:
ERROR: odbc_fdw::odbcGetTableSize: Could not retrieve table size
Have you tried to contact t
Le 2014-03-03 à 10:53, Adrian Klaver a écrit :
> On 03/02/2014 08:48 PM, François Beausoleil wrote:
>> Hi all,
>>
>> I have four roles involved:
>>
>> meetphil - the database owner, should not login
>> mpwebui - the role the web application logs in as, should have very limited
>> privileges, b
On Tue, Mar 4, 2014 at 6:48 AM, loref85 wrote:
> So, there's no way to do this?
You might want to give jdbc-fdw a try. not sure what's wrong with
odbc -- looks like a driver mismatch issue.
merlin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your s
So, there's no way to do this?
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Read-tables-of-sql-server-with-postgres-tp5793046p5794581.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general
Hello,
I would like to log statements that modify a small subset of tables in a
databases.
(not all tables, because the log files become too big in that case and I
also worry about performance)
I currently use log_statement='mod' but I didn't find a way to limit
this to the set of tables I want
2014-03-04 10:19 GMT+02:00 Adarsh Sharma :
>
> PLAN
>
>
> -
> HashAggregate (cost=10651634346.70..10651780073.12 rows
I wonder how to quickly recovery failed master? If I directly startup the
failed master as slave ( assign proper parameter), is there any problem? For
example, I don't do any copy operation in script of
recovery_1st_stage_command and recovery_2st_stage_command.
According to this document:
https://
On Tue, Mar 4, 2014 at 4:19 PM, Adarsh Sharma wrote:
> Is dere any way i can rewrite the query so that i need not to set
> seqscan-off, because i dont want to embed one more line in application
> code and also dont want to change global setting in postgresql.conf to
> disable seqscan.
>
You can
On Tue, Mar 4, 2014 at 1:13 PM, Sameer Kumar wrote:
>
> On Tue, Mar 4, 2014 at 2:57 PM, Adarsh Sharma wrote:
>
>> I tried creating simple and gin indexes on the column(t_ids) but still
>> not helping. Anyone has any idea or faced this before. Postgresql version
>> is 9.2.
>>
>
> have you done a va
29 matches
Mail list logo
