On Fri, Jul 26, 2013 at 7:54 AM, Janek Sendrowski jane...@web.de wrote:
Hi,
I'm searching for an algorithm/Index to find similar sentences in a database.
The Fulltextsearch is not really suitable because it doesn't have a tolerance.
The Levenshtein-distance ist to slow.
I also tried
secondary without having to rsync the data as it can take up to 10 hours.
pg_rewind (https://github.com/vmware/pg_rewind) is what you need.
But I think it has a problem regarding the hint bits which Robert Hass
pointed out.
You can still solve hint bit problem by enabling new checksum feature,
On Fri, Jul 26, 2013 at 3:00 PM, Samrat Revagade
revagade.sam...@gmail.comwrote:
secondary without having to rsync the data as it can take up to 10 hours.
pg_rewind (https://github.com/vmware/pg_rewind) is what you need.
But I think it has a problem regarding the hint bits which Robert Hass
On Thu, Jul 25, 2013 at 11:00 PM, Samrat Revagade
revagade.sam...@gmail.com wrote:
secondary without having to rsync the data as it can take up to 10 hours.
pg_rewind (https://github.com/vmware/pg_rewind) is what you need.
But I think it has a problem regarding the hint bits which Robert Hass
On Thursday, July 25, 2013, Tim Spencer wrote:
Hello there!
I've seen lots of people who have asked questions about how to log
this or that, but I have the opposite question! :-) I'm seeing this in my
logs:
Jul 25 18:08:11 staging-db11 postgres[27050]: [10-2] STATEMENT: create
On 2013-07-25 22:00:23 -0700, Sergey Konoplev wrote:
On Thu, Jul 25, 2013 at 1:03 AM, TJ t...@wallago.co.uk wrote:
I am looking for a way of speeding up the process of switching over of
severs.
At the moment we are switching over via the trigger file, reconfiguring our
applications,
On Friday, July 5, 2013, Jeff Davis wrote:
On Tue, 2013-06-11 at 14:05 -0700, Joe Van Dyk wrote:
# select tsrange(null)::tstzrange;
ERROR: cannot cast type tsrange to tstzrange
LINE 1: select tsrange(null)::tstzrange;
I agree that there should be a cast between tsrange and tstzrange.
On Fri, Jul 26, 2013 at 7:24 AM, Neil McGuigan neilmcgui...@gmail.com wrote:
Trying to do an hourly hot incremental backup of a single postgres server
(windows).
I have the following setup in postgresql.conf:
max_wal_senders=2
wal_level=archive
archive_mode=on
archive_command='copy %p
5. should I use the --xlog parameter and if so do I need to change
wal_keep_segments from 0?
you have already use --xlog as -x in your above command of pg_basebackup
.
yes it better to change wal_keep_segments, if you want start a postmaster
directly in the extracted directory without the
Hello,
The description of datestyle parameter does not seem to match the actual
behavior. Is this a bug to be fixed? Which do you think should be
corrected, the program or the manual?
The manual says:
DateStyle (string)
Sets the display format for date and time values, as well as the rules
Hello,
I've try to make some concurrency robustness test with an web server app
that use Hibernate and Postgres.
It seems that my trigger make deadlock when multiple thread use it.
I will try to simplify examples:
I have a table films(id, title,director) and a table
directors(id,name,nbreFilms).
Hi Neil,
Il 26/07/2013 00:24, Neil McGuigan ha scritto:
Trying to do an hourly hot incremental backup of a single postgres
server (windows).
I have the following setup in postgresql.conf:
max_wal_senders=2
wal_level=archive
archive_mode=on
archive_command='copy %p c:\\postgres\\archive\\%f'
Loïc Rollus wrote:
I've try to make some concurrency robustness test with an web server app that
use Hibernate and
Postgres.
It seems that my trigger make deadlock when multiple thread use it.
I will try to simplify examples:
I have a table films(id, title,director) and a table
On 07/26/2013 05:31 AM, MauMau wrote:
Hello,
The description of datestyle parameter does not seem to match the actual
behavior. Is this a bug to be fixed? Which do you think should be
corrected, the program or the manual?
The manual says:
DateStyle (string)
Sets the display format
Hi All -
We have been running postgres 9.0.2 since October. Streaming also
in place. Working flawless. yesterday suddenly the replication stopped.
When I look at the log file. This is what I have for the last 2 lines and
that's it. I don't see any discrepancies. Can you please help ?
On Fri, Jul 26, 2013 at 9:35 AM, akp geek akpg...@gmail.com wrote:
Hi All -
We have been running postgres 9.0.2 since October. Streaming also in
place. Working flawless. yesterday suddenly the replication stopped.
Did you write that correctly? If so, Postgres 9.0 is on patch
release
Greetings,
I have a postgresql-9.3-beta1 cluster setup (from the
yum.postgresql.org RPMs), where I'm experimenting with the postgres
FDW extension. The documentation (
http://www.postgresql.org/docs/9.3/static/postgres-fdw.html )
references three Cost Estimation Options which can be set for a
On Jul 25, 2013, at 11:45 PM, Joe Van Dyk j...@tanga.com wrote:
Have chef supply the password in encrypted format.
Interesting idea. I was hoping that somebody would be able to solve my
logging issue instead of me having to rejigger my nice centralized password
system. :-) Is
On Jul 26, 2013, at 1:42 PM, Tim Spencer wrote:
On Jul 25, 2013, at 11:45 PM, Joe Van Dyk j...@tanga.com wrote:
Have chef supply the password in encrypted format.
I was hoping that somebody would be able to solve my logging issue instead
of me having to rejigger my nice centralized
On Thu, Jul 25, 2013 at 3:59 PM, Tim Spencer tspen...@cloudpassage.com wrote:
Hello there!
I've seen lots of people who have asked questions about how to log
this or that, but I have the opposite question! :-) I'm seeing this in my
logs:
Jul 25 18:08:11 staging-db11
On Thu, Jul 25, 2013 at 3:24 PM, Neil McGuigan neilmcgui...@gmail.com wrote:
Trying to do an hourly hot incremental backup of a single postgres server
(windows).
Can you explain what incremental backup means to you? I find that
there is a surprising variety of opinions about what these terms
From: Adrian Klaver adrian.kla...@gmail.com
Actually the relevant code seems to be here:
/src/ backend/parser/gram.y
CURRENT_DATE
{
/*
* Translate as
'now'::text::date.
On 07/26/2013 10:42 AM, Tim Spencer wrote:
On Jul 25, 2013, at 11:45 PM, Joe Van Dyk j...@tanga.com wrote:
Have chef supply the password in encrypted format.
Interesting idea. I was hoping that somebody would be able to solve my
logging issue instead of me having to rejigger my nice
Lonni J Friedman netll...@gmail.com writes:
nightly=# ALTER SERVER cuda_db10 OPTIONS (SET use_remote_estimate 'true') ;
ERROR: option use_remote_estimate not found
Am I doing something wrong, or is this a bug?
[ experiments... ] You need to say ADD, not SET, to add a new option to
the list.
On Fri, Jul 26, 2013 at 3:28 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Lonni J Friedman netll...@gmail.com writes:
nightly=# ALTER SERVER cuda_db10 OPTIONS (SET use_remote_estimate 'true') ;
ERROR: option use_remote_estimate not found
Am I doing something wrong, or is this a bug?
[
Thanks for your answers.
@Amit Langote: I had a look and found out that pg_bigm doesn't support similar
matches
@Dann Corbit: The idea with the sequences makes sence. I had a look and I'm not
sure, if they support similar sequences
Janek
--
Sent via pgsql-general mailing list
On Thu, Jul 25, 2013 at 3:54 PM, Janek Sendrowski jane...@web.de wrote:
The Fulltextsearch is not really suitable because it doesn't have a tolerance.
What do you exactly mean by tolerance here?
--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA
Profile:
27 matches
Mail list logo