I noticed postgresql would do vacuum to prevent wraparound of the transaction
id, and I also tried to use vacuum freeze, I am not quite sure about freeze,
but it seems postgresql will still vacuum the frezzed unchanged tables
automatically.
My scenario is, I have a table with daily partitions,
On Fri, May 3, 2013 at 7:03 AM, matthias ritzkowski
wrote:
> What do people use day to day?
I usually set default privileges for user postgres like below and
create end users in particular roles, either role_ro for read only or
role_rw for read-write access. All the database objects one need the
Here is my understading of your requirement:
machine-A at customer site would replicate to staging machine-B which will then
replicate to target machine-C in cloud - and you would want to encrypt data in
motion from A to B to C.
I could think of 2 possible solutions:
1. Use Stunnel from mac
We're looking to use streaming replication to a target via a secondary host
using stunnel. I'd love to hear how you were able to achieve this,
k...@rice.edu.
Effectively we're looking to have the database on our customer's site (let's
call that MachineA) replicate to our backend postgres target i
On Tue, May 07, 2013 at 03:37:07AM -0400, Stephen Cook wrote:
> Most other replies don't require the precision-quoting.
i read this as:
most other replies are so far below my dignity, you don't deserve
that much of my attention.
unless, of course, you piss me off, then i will put on my magic ema
On 7 May 2013 08:37, Stephen Cook wrote:
> It doesn't matter to me at all, I just go with whatever is generally
> accepted by the mailing list (or perhaps, whatever is generally accepted by
> the most vocal part of the mailing list). Although, I only ever really did
> the whole "inline snippets"
On 5/6/2013 2:15 PM, Craig James wrote:
Just out of curiousity, I see comments like this all the time:
> (*please* stop top-posting).
I've been participating in newsgroups since UUCP days, and I've never
encountered a group before that encouraged bottom posting. Bottom
posting has traditional
I don't agree.
Yes.
Perhaps.
Now, it's your work to know to what part of your original mail I'm answering.
But, when you reply, the parts not relevant in the conversation should be
erased.
On Mon, 6 May 2013 11:15:09 -0700
Craig James wrote:
> Just out of curiousity, I see comments like this
Hi,
>> Personally I prefer top posts for short responses to a
simple issue and in-
>> between posts for everything more complex.
>
>
And then, when some people will top post, som bottom post and some will
answer inside the original email lines, then there will be a totall mess
and most people