The network bandwidth between the servers is definitely not an issue. What is
bothering me is the big size of the wal archives, which goes up to 200GB per
day and if the standby server will be able to replay all these files. The
argument that; since the master can do it and also do various other ta
Rory Campbell-Lange schrieb:
Try to run it as a prepared query - I guess you'll get about the same run
time as with the function (i.e. over 100 seconds).
The prepared query runs in almost exactly the same time as the function,
but thanks for the suggestion. A very useful aspect of it is that I
Considering the size of WAL archives = 200GB
Compressing them using gzip (you can use this command in a shell script and
place it in archive_command as well) would possibly reduce the size to as
low as 10 - 20 GB.
Please let us know the results.
Thanks
Venkat
On Tue, Sep 6, 2011 at 1:03 PM, Mir
the network transfer does not bother me for now. i will first try to do the
whole procedure without compression, so as not to waste any cpu util and
time for compressing and decompressing. through the 4Gbps ethernet, the
200GB of the day can be transferred in a matter of minutes. so i will try it
a
Hi,
I am trying to migrate a very small MS SQL Server Database (with 200 records
max, 20 tables, 10 stored procedures) to PostgreSQL. I tried browsing through
internet to find technical steps but I found some blogs with vague discussion
for same. Kindly let me know where to look for the inform
On Tue, Sep 06, 2011 at 12:17:28PM +, mamatha_kagathi_c...@dell.com wrote:
> Hi,
>
> I am trying to migrate a very small MS SQL Server Database (with 200
> records max, 20 tables, 10 stored procedures) to PostgreSQL. I tried
> browsing through internet to find technical steps but I found some
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Rory Campbell-Lange
Sent: Monday, September 05, 2011 4:55 PM
To: David Johnston
Cc: Tom Lane; pgsql-general@postgresql.org
Subject: Re: [GENERAL] UPDATE using query; per-row
"Tomas Vondra" writes:
> On 6 ZáÅà 2011, 0:27, Rory Campbell-Lange wrote:
>> The prepared query runs in almost exactly the same time as the function,
>> but thanks for the suggestion. A very useful aspect of it is that I was
>> able to get the EXPLAIN output which I guess gives a fairly good pi
I have a master+slave set up using asynchronous streaming replication. If I
do a graceful (-fast) shutdown of the master, and then promote the slave to
master, my understanding is that I should not have any data loss. At that
point in order to bring the old master back up as a slave the docs say
I have a couple of backend processes that are "stuck", and do not respond to a
pg_cancel_backend. This is PostgreSQL 8.3.5. The pg_cancel_backend returns
true, but the process keeps running. I have also done a "kill 12345" from the
command-line, with no effect.
The processes are running a "s
Chris Redekop wrote:
I have a master+slave set up using asynchronous streaming replication.
If I do a graceful (-fast) shutdown of the master, and then promote
the slave to master, my understanding is that I should not have any
data loss. At that point in order to bring the old master back up
Susan Cassidy writes:
> I have a couple of backend processes that are "stuck", and do not respond to
> a pg_cancel_backend. This is PostgreSQL 8.3.5. The pg_cancel_backend
> returns true, but the process keeps running. I have also done a "kill 12345"
> from the command-line, with no effect.
-Original Message-
> From: Tom Lane [mailto:t...@sss.pgh.pa.us]
> Sent: Tuesday, September 06, 2011 9:57 AM
> To: Susan Cassidy
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Backend process that won't die
> Susan Cassidy writes:
>> I have a couple of backend processes that
Hi:
If I have a table that has 2 records which are identical with regard to all
their column values, is there a way to delete one of them, leaving one
remaining? Is there some unique record_id key of some sort I can use for
somethign like this?
Thanks in Advance!
On 6 September 2011 18:39, Gauthier, Dave wrote:
> Hi:
>
> ** **
>
> If I have a table that has 2 records which are identical with regard to all
> their column values, is there a way to delete one of them, leaving one
> remaining? Is there some unique record_id key of some sort I can use for
On 9/6/2011 12:39 PM, Gauthier, Dave wrote:
Hi:
If I have a table that has 2 records which are identical with regard to
all their column values, is there a way to delete one of them, leaving
one remaining? Is there some unique record_id key of some sort I can use
for somethign like this?
Thanks
On 9/6/2011 12:44 PM, Thom Brown wrote:
On 6 September 2011 18:39, Gauthier, Dave mailto:dave.gauth...@intel.com>> wrote:
Hi:
__ __
If I have a table that has 2 records which are identical with regard
to all their column values, is there a way to delete one of them,
lea
Gauthier, Dave wrote:
> Hi:
>
>
>
> If I have a table that has 2 records which are identical with regard to all
> their column values, is there a way to delete one of them, leaving one
> remaining? Is there some unique record_id key of some sort I can use for
> somethign like this?
Yes, use
The identification and deleting of the records using ctids seems to have worked
fine.
Thanks !
-Original Message-
From: Andy Colson [mailto:a...@squeakycode.net]
Sent: Tuesday, September 06, 2011 1:55 PM
To: Thom Brown
Cc: Gauthier, Dave; pgsql-general@postgresql.org
Subject: Re: [GENE
Hi.
I have installed activeperl 5.10. It works with pg8.4, but not with
9.1rc1 (win32 installer).
Do this version need perl 5.12?
--
pasman
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
pasman pasma?ski wrote:
> Hi.
> I have installed activeperl 5.10. It works with pg8.4, but not with
> 9.1rc1 (win32 installer).
> Do this version need perl 5.12?
Odd, the source code only requires Perl 5.8. Not sure why win32 would
need a later version. What error are you seeing?
--
Bruce M
At 07:02 PM 9/5/2011, J. Hondius wrote:
I agree that there are better ways to do this.
But for me this works. (legacy driven situation)
INSERT INTO tbinitialisatie (col1, col2)
SELECT 'x', 'y'
FROM tbinitialisatie
WHERE not exists (select * from tbinitialisatie where col1 = 'x'
and col2 = 'y
Hello,
I need to implement HA for the appliance that is sold to the customer - our
application has no DBA and must be very stable and self recoverable.
We are running PostgreSQL 8.4.
Is the warm standby a good solution for us?
Thank you for all the suggestions.
Helen
--
View this messag
On Tue, Sep 6, 2011 at 1:50 PM, Lincoln Yeoh wrote:
> At 07:02 PM 9/5/2011, J. Hondius wrote:
>>
>> I agree that there are better ways to do this.
>> But for me this works. (legacy driven situation)
>>
>> INSERT INTO tbinitialisatie (col1, col2)
>> SELECT 'x', 'y'
>> FROM tbinitialisatie
>> WHE
On Tue, Sep 6, 2011 at 2:06 PM, hyelluas wrote:
> Hello,
>
> I need to implement HA for the appliance that is sold to the customer - our
> application has no DBA and must be very stable and self recoverable.
>
> We are running PostgreSQL 8.4.
>
> Is the warm standby a good solution for us?
It c
>
>
> I have two questions:
> (1) Did you set recovery_target_timeline='**latest' in both master and
> slave?
>
Yesbut it's in recovery.conf so it only really applies to whichever
server is currently the slave...
> (2) Did you make any changes after promote the slave to be master?
Yes, som
On Tue, Sep 6, 2011 at 3:45 PM, Merlin Moncure wrote:
> On Tue, Sep 6, 2011 at 1:50 PM, Lincoln Yeoh wrote:
>> At 07:02 PM 9/5/2011, J. Hondius wrote:
>>>
>>> I agree that there are better ways to do this.
>>> But for me this works. (legacy driven situation)
>>>
>>> INSERT INTO tbinitialisatie (c
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Andy Colson
Sent: Tuesday, September 06, 2011 1:55 PM
To: Thom Brown
Cc: Gauthier, Dave; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Deleting one of 2 identical recor
I have a complex query question whose answer I think would help me to
understand subselects and aggregates better. I have a table with four
columns of interest:
id (int primary key), loc_title (varchar null), loc_value (float
null), loc_unit (varchar null)
I want the output columns to be:
(1) eac
On 6 September 2011 19:00, Gauthier, Dave wrote:
> The identification and deleting of the records using ctids seems to have
> worked fine.
> Thanks !
>
Alternative you could do something like this:
WITH keep AS (
SELECT
my_table AS duplicate_row,
min(ctid) AS keep,
c
Hello Thom.
what is the meaning of
select table_name from table_name
Also is this a common behavior of all Databases i.e. oracle , Microsoft ,...etc
. i.e is this is the standard behavior
I think this is a good way to find duplicates in general, I will write a
routine to compare all t
On 7 September 2011 00:55, salah jubeh wrote:
>
> Hello Thom.
>
> what is the meaning of
>
> select table_name from table_name
>
> Also is this a common behavior of all Databases i.e. oracle , Microsoft
> ,...etc . i.e is this is the standard behavior
>
> I think this is a good way to find dupli
On 7/09/2011 3:00 AM, Bruce Momjian wrote:
pasman pasma�ski wrote:
Hi.
I have installed activeperl 5.10. It works with pg8.4, but not with
9.1rc1 (win32 installer).
Do this version need perl 5.12?
Odd, the source code only requires Perl 5.8. Not sure why win32 would
need a later version.
Th
Craig Ringer wrote:
> On 7/09/2011 3:00 AM, Bruce Momjian wrote:
> > pasman pasma?ski wrote:
> >> Hi.
> >> I have installed activeperl 5.10. It works with pg8.4, but not with
> >> 9.1rc1 (win32 installer).
> >> Do this version need perl 5.12?
> > Odd, the source code only requires Perl 5.8. Not s
I'm looking for a reliable way for a client to disconnect from a backend
such that any running query is terminated.
Right now, PostgreSQL doesn't seem to make an effort to detect a client
cancellation. For instance, if you do a "select pg_sleep(1000)" and then
kill -9 the client, the SELECT will r
>> The win32 packages require whatever version of Perl they were built
>> against, AFAIK. Perl DLLs are only binary compatible within a major
>> version, and I think the DLL naming changes too.
>>
Looks like 9.1 binaries are linked with perl 5.14.
Thanks for answers
pasman
--
Sent via pgsql-g
On 7/09/2011 10:00 AM, Jeff Davis wrote:
I'm looking for a reliable way for a client to disconnect from a backend
such that any running query is terminated.
Right now, PostgreSQL doesn't seem to make an effort to detect a client
cancellation. For instance, if you do a "select pg_sleep(1000)" and
37 matches
Mail list logo