On Thu, Jul 26, 2012 at 1:31 PM, Gary Webster wrote:
> OK, I set "log_statement = "all""
> The log grew to 1GB in ~minute! It is dominated by this one statement,
> which occurs every ~1.4 sec:
> "update WS_BUNDLE set BUNDLE_DATA = $1 where NODE_ID_HI = $2 and NODE_ID_LO
> = $3"
> parameter $1 is
On Wed, Jul 25, 2012 at 2:44 PM, Joshua D. Drake wrote:
>
> On 07/25/2012 11:37 AM, Gary Webster wrote:
>
> This is a cluster issue, not a database issue. So if you have an
>> idnle in transaction, then it is affecting your JCR schema as well.
>>
>> OK, how do I track/debug/stop the "idle
On Mon, Jul 16, 2012 at 02:27:45PM +0930, Stephen Davies wrote:
> (I used the rsync method suggested in the last paragraph of the pg_upgrade
> man
> pages to create a copy of the databases to be upgraded.
> This works fine except that the paragraph should also point out that the file
> postmaste
On 07/26/2012 02:24 AM, Alexey Klyukin wrote:
Hello,
I've recently come across the task of setting up a PostgreSQL 9.1 standby
server that is N hours behind the master, i.e. only transactions that finished
N hours in the past or older should be replayed on a standby. The goal is to
have a kn
Thomas Markus writes:
> a rollback prepared on these does the job
If you aren't intentionally using prepared transactions, it's a good
idea to disable them by setting max_prepared_transactions to zero
(DB restart required). That prevents you from accidentally shooting
yourself in the foot like t
Alexey Klyukin writes:
> Hello,
>
> I've recently come across the task of setting up a PostgreSQL 9.1
> standby server that is N hours behind the master, i.e. only
> transactions that finished N hours in the past or older should be
> replayed on a standby. The goal is to have a known good state s
On Thu, Jul 26, 2012 at 01:16:42PM +0530, Rajat Sangal wrote:
> Hello Everyone,
>
> I want to import Data from MySql to MS Sql Server 2008 using vb.net.
> So please help me. Pls give me reply as soon possible.
>
You should probably post this to a MySQL or MSSQL mailing list or
forum. This venue i
Hi Craig,
thanks, that was the tip
a rollback prepared on these does the job
best regards
Thomas
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
On 07/26/2012 04:39 PM, Thomas Markus wrote:
Hi,
see below
Am 26.07.2012 10:25, schrieb Craig Ringer:
- Do you have any uncommitted two phase transactions? Run:
SELECT * from pg_prepared_xacts ;
hm yes, i stopped all applications this morning but this query shows:
transaction | gid
Hello,
I've recently come across the task of setting up a PostgreSQL 9.1 standby
server that is N hours behind the master, i.e. only transactions that finished
N hours in the past or older should be replayed on a standby. The goal is to
have a known good state server to perform backups from a
Wrong list, but I would look at creating SSIS packages to transform and load
data into SQL Server. You can find out quite a bit about this from the technet
area of the Microsoft website.
Mark
On Jul 26, 2012, at 3:46, Rajat Sangal wrote:
> Hello Everyone,
>
> I want to import Data from
Hi Rajat,
On Thu, 26 Jul 2012 13:16:42 +0530, Rajat Sangal wrote:
I want to import Data from MySql to MS Sql Server 2008 using vb.net.
So please help me. Pls give me reply as soon possible.
MySQL, MS SQL, vb? I think you are on the wrong list :)
Jan
--
professional: http://www.oscar-consult.
On 07/26/2012 03:46 PM, Rajat Sangal wrote:
Hello Everyone,
I want to import Data from MySql to MS Sql Server 2008 using vb.net.
So please help me. Pls give me reply as soon possible.
You seem to be in the wrong place. This is a mailing list for
administration of the PostgreSQL database serv
Hi,
see below
Am 26.07.2012 10:25, schrieb Craig Ringer:
First, thank-you for an excellent complete question with versions,
EXPLAIN ANALYZE, and exact messages.
;)
- Do you have any uncommitted two phase transactions? Run:
SELECT * from pg_prepared_xacts ;
hm yes, i stopped all applicati
Hi,
On 26 July 2012 08:03, wrote:
> Interesting. so have you also created zabbix postgres template to go with
> it ?
>
I used to have one for zabbix 1.8, the main problem being that I had to
manually create items for each single database. We assist a large number of
customers and pretty often w
First, thank-you for an excellent complete question with versions,
EXPLAIN ANALYZE, and exact messages.
My reply is interleaved below.
On 07/26/2012 03:44 PM, Thomas Markus wrote:
I have 2 systems with CentOS 5.5 (2.6.18) x86_64, postgresql-9.0.6 64bit
both systems contains the same content.
Hello Everyone,
I want to import Data from MySql to MS Sql Server 2008 using vb.net.
So please help me. Pls give me reply as soon possible.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Hi,
I have 2 systems with CentOS 5.5 (2.6.18) x86_64, postgresql-9.0.6 64bit
both systems contains the same content. But one system make troubles.
some system tables (eg pg_catalog.pg_class or pg_attribute) contain much
dead rows and all simple query take much time on one system. the other
on
18 matches
Mail list logo
