On Tue, May 03, 2011 at 10:52:23AM +0800, Craig Ringer wrote:
> ... and that's before we get into the horror of "what is someone's
> name". Which name? Which spelling? Do they even have a single canonical
> name?
- people have, at least over time, several compound names
- they have, at any one ti
On Tue, May 3, 2011 at 7:31 AM, Sim Zacks wrote:
> I have heard good things about Bucardo, though I haven't tried it myself
> yet. I was warned that it would be risky to have 2 masters that have the
> same tables modified in both because of issues such as delayed sync, race
> conditions and other
Respected Committers,
It may be a silly question, still out of curiosity I want to know, is there
any possible way to flush the Postgres Shared Memory without restarting the
cluster.
In Oracle, we can flush the SGA, can we get the same feature here..
Thanks in Advance.
Regards
Raghu Ram
Enterpr
On May 2, 2011, at 10:52 PM, Craig Ringer wrote:
> SSN? What if they don't live in the US or aren't a citizen?
Non-citizens can have SSNs (they have to if they work in the US).
--
Rick Genter
rick.gen...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make c
On 03/05/2011 07:12, alan bryan wrote:
Our developers started to use some xpath features and upon deployment
we now have an issue where PostgreSQL is seg faulting periodically.
Any ideas on what to look at next would be much appreciated.
FreeBSD 8.1
PostgreSQL 9.0.3 (also tried upgrading to 9.0.
Thanks you all,
I started with Bucardo. I installed activeperl 5.12 on my Linux(RHEL5.5)
server.
Can you please suggest some link which describe the installation steps in
details.
Thanks,
Tushar
On Tue, May 3, 2011 at 2:49 PM, Simon Riggs wrote:
> On Tue, May 3, 2011 at 7:31 AM, Sim Zacks wro
On Tue, May 3, 2011 at 11:54 AM, raghu ram wrote:
> It may be a silly question, still out of curiosity I want to know, is there
> any possible way to flush the Postgres Shared Memory without restarting the
> cluster.
> In Oracle, we can flush the SGA, can we get the same feature here..
> Thanks i
Best to start with..
http://bucardo.org/wiki/Bucardo/Installation
Best Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Tue, May 3, 2011 at 5:34 PM, tushar nehete wrote:
> Thanks you all,
> I started with Bucardo. I installed activeperl 5.12 on my Linux(RHE
One more point, Please take into consideration the points mentioned by Simon
Riggs in your testing.
Best Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Tue, May 3, 2011 at 5:41 PM, Raghavendra <
raghavendra@enterprisedb.com> wrote:
> Best to start with.
On Tue, May 3, 2011 at 5:37 PM, Simon Riggs wrote:
> On Tue, May 3, 2011 at 11:54 AM, raghu ram
> wrote:
>
> > It may be a silly question, still out of curiosity I want to know, is
> there
> > any possible way to flush the Postgres Shared Memory without restarting
> the
> > cluster.
> > In Oracl
On Tue, May 3, 2011 at 6:01 PM, Raghavendra <
raghavendra@enterprisedb.com> wrote:
>
> On Tue, May 3, 2011 at 5:37 PM, Simon Riggs wrote:
>
>> On Tue, May 3, 2011 at 11:54 AM, raghu ram
>> wrote:
>>
>> > It may be a silly question, still out of curiosity I want to know, is
>> there
>> > any
On Mon, May 2, 2011 at 11:53 PM, Craig Ringer
wrote:
> On 03/05/11 11:07, Greg Smith wrote:
>
>> That doesn't mean you can't use
>> them as a sort of foreign key indexing the data; it just means you can't
>> make them the sole unique identifier for a particular entity, where that
>> entity is a pe
On Tue, May 3, 2011 at 8:30 AM, raghu ram wrote:
> On Tue, May 3, 2011 at 6:01 PM, Raghavendra
> wrote:
>>
>> On Tue, May 3, 2011 at 5:37 PM, Simon Riggs wrote:
>>>
>>> On Tue, May 3, 2011 at 11:54 AM, raghu ram
>>> wrote:
>>>
>>> > It may be a silly question, still out of curiosity I want to k
> On Tue, May 3, 2011 at 6:01 PM, Raghavendra <
> raghavendra@enterprisedb.com> wrote:
>
>>
>> On Tue, May 3, 2011 at 5:37 PM, Simon Riggs
>> wrote:
>>
>>> On Tue, May 3, 2011 at 11:54 AM, raghu ram
>>> wrote:
>>>
>>> > It may be a silly question, still out of curiosity I want to know, is
>>>
2011/5/3 Merlin Moncure :
> On Tue, May 3, 2011 at 8:30 AM, raghu ram wrote:
>> On Tue, May 3, 2011 at 6:01 PM, Raghavendra
>> wrote:
>>>
>>> On Tue, May 3, 2011 at 5:37 PM, Simon Riggs wrote:
On Tue, May 3, 2011 at 11:54 AM, raghu ram
wrote:
> It may be a silly questio
On Tue, May 3, 2011 at 8:55 AM, Cédric Villemain
wrote:
> 2011/5/3 Merlin Moncure :
>>
>> no it will not, or at least there is no guarantee it will be. the
>> only way to reset the buffers in that sense is to restart the database
>> (and even then they might not be read from disk, because they co
2011/5/3 Merlin Moncure :
> On Tue, May 3, 2011 at 8:55 AM, Cédric Villemain
> wrote:
>> 2011/5/3 Merlin Moncure :
>>>
>>> no it will not, or at least there is no guarantee it will be. the
>>> only way to reset the buffers in that sense is to restart the database
>>> (and even then they might not
On Tue, May 3, 2011 at 4:19 AM, Simon Riggs wrote:
> On Tue, May 3, 2011 at 7:31 AM, Sim Zacks wrote:
>
>> I have heard good things about Bucardo, though I haven't tried it myself
>> yet. I was warned that it would be risky to have 2 masters that have the
>> same tables modified in both because o
On Tue, May 3, 2011 at 3:16 PM, Mark Johnson
wrote:
> The contents of this email may not be copied or forwarded in part or in
> whole without the express written consent of the author.
Pleased to meet you Mark.
If you post here, the above disclaimer is not effective. Right now
your words are be
Is there a particular one of Oracle's memory clearning features you want to use
in PostgreSQL? In Oracle you cannot flush the entire SGA without a restart, but
you can flush three parts of the SGA using three separate commands.
1. In Oracle you can flush the redo buffer by issuing a COMMIT or by
On Tue, May 03, 2011 at 03:33:34PM +0100, Simon Riggs wrote:
> > The contents of this email may not be copied or forwarded in part or in
> > whole without the express written consent of the author.
>
> Pleased to meet you Mark.
>
> If you post here, the above disclaimer is not effective. Right n
On Tue, May 3, 2011 at 2:30 PM, raghu ram wrote:
>>> The CHECKPOINT command will do this for you.
>>
>>
>
> According to PostgreSQL documentation, whenever you execute "CHECKPOINT" in
> the database,it will flush the modified data files presented in the Shared
> Buffers retuned to the Disk.
>
Karsten Hilbert writes:
> On Tue, May 03, 2011 at 03:33:34PM +0100, Simon Riggs wrote:
>> If you post here, the above disclaimer is not effective. Right now
>> your words are being copied across the internet...
> By typing / selecting a public list address "written consent
> of the author" can be
On 03/05/2011 16:08, Tom Lane wrote:
Karsten Hilbert writes:
On Tue, May 03, 2011 at 03:33:34PM +0100, Simon Riggs wrote:
If you post here, the above disclaimer is not effective. Right now
your words are being copied across the internet...
By typing / selecting a public list address "writte
On 3 May 2011 16:49, Raymond O'Donnell wrote:
> I don't want to start a flame war, but did they every have any legal force
> in the first place?
No.
--
Peter Geoghegan http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services
--
Sent via pgsql-general maili
Yes, understood and agreed. My mail server adds it automatically. I can
manually remove it prior to sending to the mail list.
-Mark
-Original Message-
From: Simon Riggs [mailto:si...@2ndquadrant.com]
Sent: Tuesday, May 3, 2011 10:33 AM
To: 'Mark Johnson'
Cc: 'pgsql-admin', 'pgsql-general'
On Sat, Apr 30, 2011 at 4:29 AM, Greg Smith wrote:
> I wouldn't fight with this too much though. Unless you have some really
> customized stuff in your wiki, there really is nothing wrong with the idea
> of dumping everything into XML, creating a blank PostgreSQL-backed MediaWiki
> install, then
On 2011-04-22, Geoffrey Myers wrote:
> Vick Khera wrote:
>> On Fri, Apr 22, 2011 at 11:00 AM, Geoffrey Myers
>> mailto:li...@serioustechnology.com>> wrote:
>>
>> Here's our problem. We planned on moving databases a few at a time.
>> Problem is, there is a process that pushes data from o
On 2011-03-24, Waqar Azeem wrote:
> --0015174766a0ffbf86049f35206e
> Content-Type: text/plain; charset=ISO-8859-1
>
> My XP is crashed and now I have to take a full backup of my postgresql 8.4
>
> I am used to get backup of ldf/mdf files in case of SQLServer
>
> Please let me know the right way of
On 05/03/11 5:04 AM, tushar nehete wrote:
I started with Bucardo. I installed activeperl 5.12 on my
Linux(RHEL5.5) server.
why ActivePerl, which is usually used by MS Windows users, rather than
the Perl built into RHEL 5.5 (btw, 5.6 is out now, you really should run
'yum update').
--
Sent
Jasen Betts wrote:
On 2011-04-22, Geoffrey Myers wrote:
Vick Khera wrote:
On Fri, Apr 22, 2011 at 11:00 AM, Geoffrey Myers
mailto:li...@serioustechnology.com>> wrote:
Here's our problem. We planned on moving databases a few at a time.
Problem is, there is a process that pushes data
On 5/3/2011 7:33 AM, Simon Riggs wrote:
Pleased to meet you Mark.
If you post here, the above disclaimer is not effective. Right now
your words are being copied across the internet...
I believe our community needs to move past posting replies like this. It
isn't even relevant to the context
On Mon, 2011-05-02 at 20:06 -0600, Rob Sargent wrote:
> Jeff Davis wrote:
> > In particular, I think you are falsely assuming that a natural key must
> > be generated from an outside source (or some source outside of your
> > control), and is therefore not reliably unique.
> >
> > You can generate
On 05/03/2011 12:51 PM, Jeff Davis wrote:
On Mon, 2011-05-02 at 20:06 -0600, Rob Sargent wrote:
Jeff Davis wrote:
In particular, I think you are falsely assuming that a natural key must
be generated from an outside source (or some source outside of your
control), and is therefore not reliably
On Tue, 2011-05-03 at 13:35 -0600, Rob Sargent wrote:
> Sorry, but I'm confused, but that's common. Isn't a "natural key" to be
> compose solely from the attributes of the entity? As in a subset of the
> columns of the table in a third-normalish world. Isn't tacking on
> another column with a
Chris Curvey writes:
> and, FWIW, here's another trace, which is NEARLY the same as the first one I
> posted, with the difference being a slightly different line number at #3. I
> will be quiet now and leave the brain trust to ponder. Let me know if there
> is anything else I can get for you guy
On Mon, 2011-05-02 at 23:07 -0400, Greg Smith wrote:
> I see this whole area as being similar to SQL injection. The same way
> that you just can't trust data input by the user to ever be secure, you
> can't trust inputs to your database will ever be unique in the way you
> expect them to be.
For restoring a database from wal files, if I omit a target on the
recovery.conf file, can I make it so the database continues the time line
instead of starting one?
Or is there a tool to pick the most recent time line from a bunch of wal
files?
thankyou.
On 05/03/11 3:07 PM, dabicho wrote:
For restoring a database from wal files, if I omit a target on the
recovery.conf file, can I make it so the database continues the time
line instead of starting one?
Or is there a tool to pick the most recent time line from a bunch of
wal files?
thankyou.
El may 3, 2011 5:59 p.m., "John R Pierce" escribió:
>
> On 05/03/11 3:07 PM, dabicho wrote:
>>
>>
>> For restoring a database from wal files, if I omit a target on the
recovery.conf file, can I make it so the database continues the time line
instead of starting one?
>> Or is there a tool to pick t
On 05/03/2011 03:08 PM, Jeff Davis wrote:
On Tue, 2011-05-03 at 13:35 -0600, Rob Sargent wrote:
Sorry, but I'm confused, but that's common. Isn't a "natural key" to be
compose solely from the attributes of the entity? As in a subset of the
columns of the table in a third-normalish world. Isn
Merlin Moncure wrote:
If your data modeler that made the the assumptions that a MAC is
unique (a mistake obviously) at least the other tables are protected
from violations of that assumption because the database would reject
them with an error, which is a Good Thing. Without a uniqueness
constra
Jeff Davis wrote:
On Mon, 2011-05-02 at 23:07 -0400, Greg Smith wrote:
I see this whole area as being similar to SQL injection. The same way
that you just can't trust data input by the user to ever be secure, you
can't trust inputs to your database will ever be unique in the way you
expect
On May 3, 2011, at 22:03, Greg Smith wrote:
> Merlin Moncure wrote:
>> If your data modeler that made the the assumptions that a MAC is
>> unique (a mistake obviously) at least the other tables are protected
>> from violations of that assumption because the database would reject
>> them with an
Hi guys,
No matter I turn on or turn off the "full_page_writes", I always
observe 8192-byte writes of log data for simple write operations
(write/update).
But according to the document, when this is off, it could speed up
operations but may cause problems during recovery. So, I guess this is
bec
My output of explain (analyze,buffers) is something like this:
shared hit=3796624 read=46038
So what is meant by *read* here? Does it indicates number of disk reads?
Does *shared hit* takes into account only the hit in the pg_buffercache of
the postgres or it also takes into account the *linux b
SUBHAM ROY wrote:
> My output of explain (analyze,buffers) is something like this:
>
> shared hit=3796624 read=46038
>
> So what is meant by read here? Does it indicates number of disk reads?
>
> Does shared hit takes into account only the hit in the pg_buffercache of the
> postgres or it also
Greets,
I've just activated another replication slave and noticed the following in the
logs:
WARNING: xlog min recovery request 38E/E372ED60 is past current point
38E/D970
It seems to be happily restoring log files from the archive, but the warning
message above concerns me.
Googling only
On 05/04/2011 08:39 AM, Andreas Kretschmer wrote:
> SUBHAM ROY wrote:
>
>> My output of explain (analyze,buffers) is something like this:
>>
>> shared hit=3796624 read=46038
>>
>> So what is meant by read here? Does it indicates number of disk reads?
>>
>> Does shared hit takes into account only
49 matches
Mail list logo
