On 18/10/2012 23:31, Craig Ringer wrote:
> On 10/19/2012 01:46 AM, Grant Allen wrote:
>> On 18/10/2012 02:13, Shams Khan wrote:
>>> Hi Experts,
>>>
>>> I am in the process of migration from PG 9 to oracle. All of the
>>> database objects has been migrated apart from functions. The main
>>> issue I
On 10/19/2012 01:46 AM, Grant Allen wrote:
On 18/10/2012 02:13, Shams Khan wrote:
Hi Experts,
I am in the process of migration from PG 9 to oracle. All of the
database objects has been migrated apart from functions. The main
issue I am facing with function code where DML statements are used in
On Thu, Oct 18, 2012 at 2:54 PM, Tom Lane wrote:
> Craig James writes:
> > I installed 9.2 on our new server and am seeing something odd that
> doesn't
> > happen in 8.4:
>
> > postgres=# select datname, pid, usename, query from pg_stat_activity
> where
> > query != '';
>
> The query column now
Craig James writes:
> I installed 9.2 on our new server and am seeing something odd that doesn't
> happen in 8.4:
> postgres=# select datname, pid, usename, query from pg_stat_activity where
> query != '';
The query column now means "current or last query" --- there's a
separate column to check
I installed 9.2 on our new server and am seeing something odd that doesn't
happen in 8.4:
postgres=# select datname, pid, usename, query from pg_stat_activity where
query != '';
datname | pid | usename |
query
+---+--+-
Parkirat Bagga wrote:
> What, I have observed that there is always only one sender process sending
> the data. Is it possible with any configuration that I can optimize this
> system for more current and less overhead on master. We are not thinking
> in-terms of long running queries.
Replication c
Hi.
What stripe width size are you recommending for postgresql 9.2?
Default settings are often 128k, is that OK, or should I go 8k?
And what is the best practice with filesystem, to align it to stripe
width + stripe unit size, or performance doesn't benefit from it at all?
Thank you :)
--
Ja
On 18/10/2012 02:13, Shams Khan wrote:
> Hi Experts,
>
> I am in the process of migration from PG 9 to oracle. All of the
> database objects has been migrated apart from functions. The main
> issue I am facing with function code where DML statements are used in
> the code. On the other side, Oracl
Thanks Albe for the clarification.
Regards,
Parkirat Singh Bagga.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/WAL-corruption-while-replication-tp5728705p5728878.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mai
Thanks Albe.
For the delay between 2 machines, the data insertions is happening at 8K tps
and each record is around 1KB. So a total of 8Mb/s of data is getting
inserted in the Master PG.
The slave is not in different region but in different availability zone
(same region) on EC2. Sorry for the ty
On 10/18/2012 05:02 AM, fr...@frank.uvena.de wrote:
> Am 2012-10-18 10:31, schrieb Gabriele Bartolini:
>
>> Just for the record and to understand if this is due to PostgreSQL
>> limitations, are you in a position to give us technical/product
>> reasons for this decision?
>
> I'd like to also know
Am 2012-10-18 10:31, schrieb Gabriele Bartolini:
Just for the record and to understand if this is due to PostgreSQL
limitations, are you in a position to give us technical/product
reasons for this decision?
I'd like to also know reasons for this
Cheers,
Frank
--
Sent via pgsql-admin mai
Hi Shams,
On Thu, 18 Oct 2012 11:43:52 +0530, Shams Khan
wrote:
I am in the process of migration from PG 9 to oracle. All of the
database objects has been migrated apart from functions. The main
issue I am facing with function code where DML statements are used in
the code. On the other side,
Maybe you will get more enthusiastic support in an Oracle forum...
It is curious that you want to migrate form a fairly
current PostgreSQL version (you didn't say which one) to
an Oracle version that is already out of (Premier) support
and will be terminally abandoned next year.
Shams Khan wrote:
Shams Khan wrote:
> Can somebody tell me how we can automate the switch over process, I
> know there is once file recovery.conf which contains the parameter
> trigger_file. But my question is what code that file containsHope
> my thinking is correct.
The contents of the trigger file are irrele
Lonni J Friedman wrote:
>> Does rsysc sync's the partial logs as well. As I would be doing the rsync
>> from old master to new master (when the old master recovers), there might be
>> some partial logs present in the old master?
>
> I don't think that's how WAL works. The log is either complete,
Parkirat Bagga wrote:
> How to recover, if master postgres WAL got corrupted before it is
applied to
> the standby server?
>
> Will I loose all the data present in the WAL segment?
>
> How can I partially apply the WAL?
During normal recovery:
---
WAL will be replayed until
17 matches
Mail list logo
