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 tst
On Fri, Jul 26, 2013 at 7:24 AM, Neil McGuigan 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" "c:\\postgres\\
>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 f
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,nbreFilm
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 disp
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 ? T
On Fri, Jul 26, 2013 at 9:35 AM, akp geek 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 9.0.13. Pri
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
fore
On Jul 25, 2013, at 11:45 PM, Joe Van Dyk 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 there really no w
On Jul 26, 2013, at 1:42 PM, Tim Spencer wrote:
> On Jul 25, 2013, at 11:45 PM, Joe Van Dyk 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 password syst
On Thu, Jul 25, 2013 at 3:59 PM, 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] STATEME
On Thu, Jul 25, 2013 at 3:24 PM, Neil McGuigan 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 mean.
To me, the ac
From: "Adrian Klaver"
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 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 pa
Lonni J Friedman 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. SET might mo
On Fri, Jul 26, 2013 at 3:28 PM, Tom Lane wrote:
> Lonni J Friedman 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 A
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 (pgsql-genera
On Thu, Jul 25, 2013 at 3:54 PM, Janek Sendrowski 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: http://www.linkedin.com/in/grayhemp
Phone
21 matches
Mail list logo