On 2/10/2010 9:41 AM, Dann Corbit wrote:
The inserts are processed via an INSERT/SELECT statement.
A custom driver has been written that performs this operation
using the COPY API.
BTW, is there any chance you can push that (ODBC, you said?) driver
somewhere public? It might interest the psql
Hi all.
It's not clear to me whether it's faster to check error conditions
before actually executing some
statements or to add error trapping code to "react" to errors.
The documentation states that the former should be faster than the
latter. Which is more or less
the same as I can experience in
* Andrew E. Tegenkamp wrote:
I have two tables and want to attach and return the most recent data from
the second table.
Table 1 has a counter ID and name. Table 2 has a counter ID, Reference (to
Table 1 ID), Date, and Like. I want to do a query that gets each name and
their most recent like. I
Dear List,
Firstly thanks to the postgresql global development team for releasing
postgresql
with such a great enterprise feature of SR & HS.
As an enduser i setup SR based on
http://wiki.postgresql.org/wiki/Streaming_Replication
The master & standby are both powerful machines and are on same gig
Steps to reproduce:
1. Ran latest pgAdmin in windows server 2005 Standard x64 Edition
2. Restore data to Postgres 9.0 linux server from 450 MB backup file if
only
SSL connection is enabled
After some time pg_restore reports that connection is closed.
server log is below.
How to restore 450 MB ba
Andrus Moor writes:
> How to restore 450 MB backup copy to Postgres 9.0 Linux server from
> windows server using SSL ?
Either (1) get a non-lobotomized SSL library, or (2) set
ssl_renegotiation_limit to zero in the server.
regards, tom lane
--
Sent via pgsql-general mai
> Either (1) get a non-lobotomized SSL library
I'm using latest official Postgres 9.0 server and pgAdmin client.
Does one of them contain bug in SSL ?
Andrus.
I'm trying to come up with an automated monitoring system to watch the
WAL log progress and sound appropriate alarms if it gets too far behind
for some reason (e.g. communications problems, etc.) - so far without
success.
What I need is some sort of way to compute a difference between the
master
I hope u checked point #11
http://wiki.postgresql.org/wiki/Streaming_Replication#How_to_Use
- *11.* You can calculate the replication lag by comparing the current
WAL write location on the primary with the last WAL location
received/replayed by the standby. They can be retrieved using *
On 10/2/2010 11:40 PM, Rajesh Kumar Mallah wrote:
>
> I hope u checked point #11
> http://wiki.postgresql.org/wiki/Streaming_Replication#How_to_Use
>
> * *11.* You can calculate the replication lag by comparing the
> current WAL write location on the primary with the last WAL
> lo
On Sun, Oct 3, 2010 at 07:07, Karl Denninger wrote:
> Now how do I get an arithmetic difference between the two? There will
> (usually) be a small difference between the master and slave on a busy
> system - what I want to do is query both and if the difference in their
> locations is greater tha
Le 03/10/2010 07:07, Karl Denninger a écrit :
> On 10/2/2010 11:40 PM, Rajesh Kumar Mallah wrote:
>>
>> I hope u checked point #11
>> http://wiki.postgresql.org/wiki/Streaming_Replication#How_to_Use
>>
>> * *11.* You can calculate the replication lag by comparing the
>> current WAL writ
12 matches
Mail list logo