Dong,
Once the wal_copy command completes the primary is free to handle the
wal logs as it sees fit. Is it possible that rsync is getting behind ?
Dave Cramer
dave.cramer(at)credativ(dot)ca
http://www.credativ.ca
On Mon, Dec 12, 2011 at 11:28 PM, Dong Han wrote:
> Dave,
>
> The WAL files wer
Dear List,
I found this interesting:
SELECT regexp_matches('123-A' , E'(3[A-Z\- ])');
ERROR: invalid regular expression: invalid character range
whereas:
SELECT regexp_matches('123-A' , E'(3[\- A-Z])');
regexp_matches
{3-}
(1 row)
Notice the order of (escaped) characters and
On 13 December 2011 14:04, InterRob wrote:
> Dear List,
>
> I found this interesting:
>
> SELECT regexp_matches('123-A' , E'(3[A-Z\- ])');
> ERROR: invalid regular expression: invalid character range
>
> whereas:
> SELECT regexp_matches('123-A' , E'(3[\- A-Z])');
> regexp_matches
>
True, but still weird...
And are you sure it does the same thing?
2011/12/13 Szymon Guz
>
>
> On 13 December 2011 14:04, InterRob wrote:
>
>> Dear List,
>>
>> I found this interesting:
>>
>> SELECT regexp_matches('123-A' , E'(3[A-Z\- ])');
>> ERROR: invalid regular expression: invalid charact
On Dec 13, 2011, at 8:09, Szymon Guz wrote:
>
>
> On 13 December 2011 14:04, InterRob wrote:
> Dear List,
>
> I found this interesting:
>
> SELECT regexp_matches('123-A' , E'(3[A-Z\- ])');
> ERROR: invalid regular expression: invalid character range
>
> whereas:
> SELECT regexp_matches('12
Thanks guys, i see what you mean.
I do intend to use the PG escaping, in order to avoid that annoying
warning... Hence, my expression should indeed be:
SELECT regexp_matches('123-A' , E'(3[A-Z\\-\\(\\) ])');
In the above expression i added the parentheses as I whish to match these
as well :))
Th
On Tue, Dec 13, 2011 at 02:51:15PM +0100, InterRob wrote:
> Thanks guys, i see what you mean.
>
> I do intend to use the PG escaping, in order to avoid that annoying
> warning... Hence, my expression should indeed be:
> SELECT regexp_matches('123-A' , E'(3[A-Z\\-\\(\\) ])');
>
> In the above expr
Removing the administrator rights worked and the service is now able to start
over the domain. Thanks for the help!
From: Craig Ringer [mailto:ring...@ringerc.id.au]
Sent: Monday, December 12, 2011 5:48 PM
To: Sogard, Michael (DPS)
Cc: Sachin Srivastava; pgsql-general@postgresql.org
Subject: Re:
On Tue, Dec 13, 2011 at 7:51 AM, InterRob wrote:
> Thanks guys, i see what you mean.
>
> I do intend to use the PG escaping, in order to avoid that annoying
> warning... Hence, my expression should indeed be:
> SELECT regexp_matches('123-A' , E'(3[A-Z\\-\\(\\) ])');
>
> In the above expression i a
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Merlin Moncure
Sent: Tuesday, December 13, 2011 11:39 AM
To: r...@marjot-multisoft.com
Cc: David Johnston; Szymon Guz; pgsql-general
Subject: Re: [GENERAL] order of (escaped)
Thanks Tom. I had tried it with SU before I mailed the list and it didn't
work. When I tried it again, I noticed that I typed a lower case C which it
wouldn't accept. I tried it again with an upper case C and it worked. That's
probably why my first attempt with SU failed and I didn't catch t
On Tue, Dec 13, 2011 at 10:53 AM, David Johnston wrote:
> Aside from backward compatibility, and the various warnings, is there any
> reason to prefer dollar-quoting over a non-SQL-escaped string literal (i.e.,
> '3[A-Z\-\(\) ]' ) ?
yeah -- because sooner or later you have to stick a single quo
True, but still weird...
And are you sure it does the same thing?
2011/12/13 Szymon Guz
>
>
> On 13 December 2011 14:04, InterRob wrote:
>
>> Dear List,
>>
>> I found this interesting:
>>
>> SELECT regexp_matches('123-A' , E'(3[A-Z\- ])');
>> ERROR: invalid regular expression: invalid charact
hi,
i'm trying to output all values that can be reached from a specific record
by a foreign key link.
for example, if tblimage has image_id, image_info and tblstack has
stack_id=tblimage.image_id, stack_info_1, stack_info_2
i want to be able to get image_id, image_info, stack_info_1, stack_info_2
On Tue, Dec 13, 2011 at 2:37 PM, anisoptera wrote:
> hi,
>
> i'm trying to output all values that can be reached from a specific record
> by a foreign key link.
>
> for example, if tblimage has image_id, image_info and tblstack has
> stack_id=tblimage.image_id, stack_info_1, stack_info_2
> i want
Merlin Moncure-2 wrote
>
>
> I didn't quite parse that.Using recursive queries, it should be
> able to pretty easily query out, given a table name, all tables that
> link to that table and the columns of the keys in the constraints
> (and, if necessary, the links from other tables to those t
Merlin Moncure wrote:
Breaking your large queries into functions OTOH can make significant
changes to the plan, often to the worse.
As an end-user, I think this is an area where PostgreSQL could really stand
out (that and the moon launch). In Rails-land, you don't have The DBA that
writes qu
On 12/12/2011 10:33 PM, Jayadevan M wrote:
But I miss all those user-friendly trouble-shooting utilities (like
Automatic Workload Repository,Active Session History etc etc) in
PostgreSQL. Yes - some of them are there, but one has to
search,download, configure etc. I hope many of these features
PGDay.SoCal is scheduled at this year's Southern California Linux
Exposition (SCALE10X) held in the LAX Hilton Hotel in the city of Los
Angeles, California, USA, on Friday January 20th, 2012.
Talks are designed for a general audience of web developers, sysadmins,
DBAs and open source users. Talks
This message has been digitally signed by the sender.
_GENERAL__PGDay_SoCal___SCALE_10X.eml
Description: Binary data
-
Hi-Tech Gears Ltd, Gurgaon, India
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Lets assume I have a table with an index defined as:
create index test_key on test_table(mtime) where status=1;
Will be update such as:
update test_table set mtime=NOW() where id=10;
threated as HOT update if the entry with id=10 have status=0 ?
That update seems valid one for using HOT, however
On 14/12/2011 12:10 AM, Sogard, Michael (DPS) wrote:
Removing the administrator rights worked and the service is now able
to start over the domain. Thanks for the help!
Glad to hear it.
I'm inclined to think Pg needs a better error message in the logs and/or
to emit a service log warning
Hello, All !
I have 2 machines with Gentoo Linux its ip is 192.168.17.109 and
Windows XP ip is 192.168.17.124
Postgresql 9.0.1 was installed on both machines. If I connect from
Windows machine onto Linux machine all works fine. pg_hba.conf on
linux machine is
local all all
On 12/13/11 9:27 PM, Yuriy Rusinov wrote:
But pg_admin on windows successfully works on both servers.
Any ideas ?
is a windows firewall blocking incoming connections on port 5432/tcp ?
--
john r pierceN 37, W 122
santa cruz ca mid-left co
Hello !
>>
>> But pg_admin on windows successfully works on both servers.
>> Any ideas ?
>
>
> is a windows firewall blocking incoming connections on port 5432/tcp ?
>
Possible yes, but which way I have to verify it ?
--
Best regards,
Sincerely yours,
Yuriy Rusinov.
--
Sent via pgsql-general
Hello,
We have configured "streaming replication" (not synchronous) for our
production in PG-9.1.1.
Replication is working fine, we can see the transactions getting replicated
without any issues.
I see the below problem -
pg_stat_replication on master shows no rows all the time..
ps -Af | grep
On Dec 14, 2011, at 0:40, Yuriy Rusinov wrote:
> Hello !
>
>>>
>>> But pg_admin on windows successfully works on both servers.
>>> Any ideas ?
>>
>>
>> is a windows firewall blocking incoming connections on port 5432/tcp ?
>>
>
> Possible yes, but which way I have to verify it ?
>
>
Turn
Is it possible to find out, when was pg_stat_reset() used in my server for
the last time?
I am using Postgresql 9.2 and I need to find out unused index.
28 matches
Mail list logo
