General thought:
It's entirely possible my current Postgres environment is missing
something (I'm an automation engineer, not a DBA - most of my postgres
knowledge has been learned on the job or from Google), but we actively
monitor the receive and replay lag (i.e. comparing
pg_current_xlog_lo
I'm not a "high level committer", nor am I even a regular poster to this
list.
not saying this post is true, but... If I'm reading between the lines
correctly, this could make for quite a striking headline in the tech
news - "NSA dumps Oracle proprietary database in favor of PostgreSQL."
I'd v
t recovery state reached at
> 2DE/BFFFE53C
> 2014-02-19 11:11:01 CET LOG: database system is ready to accept read
> only connections
>
> So my question is, could there be something wrong with my configuration
> or is this normal?
>
> Juergen
>
> On 02/19/2014 02:14 AM, Ant
Juergen,
I've seen this quite a lot in the past, as we do this multiple times a day.
Here's the procedure we use to prevent it:
1) read the PID from postmaster.pid in the data directory
2) Issue "service postgresql-9.0 stop" (this does a fast shutdown with
-t 600)
3) loop until the PID is no lon
On 02/15/2014 04:55 PM, Antman, Jason (CMG-Atlanta) wrote:
> On 02/15/2014 02:00 PM, Francisco Olarte wrote:
>>
>> If I NEEDED to be able to provide 100-150 snapshots to test/dev
>> environments 20% of which maybe active, I'll setup a cluster, buy
>> somewhere above
On 02/15/2014 05:27 PM, Karsten Hilbert wrote:
> On Sat, Feb 15, 2014 at 10:17:05PM +0000, Antman, Jason (CMG-Atlanta) wrote:
>
>> [...] I see how my original "brilliant" idea
>> (multiple DBs per postgres instance on one host, [...]) is insane,
>> without some sp
of documentation or best practices for running multiple
postgres instances on the same host, and how to maximize resource
sharing between them?
Thanks,
Jason
On 02/15/2014 04:26 PM, Adrian Klaver wrote:
> On 02/15/2014 10:31 AM, Antman, Jason (CMG-Atlanta) wrote:
>> Well thanks fo
On 02/15/2014 02:00 PM, Francisco Olarte wrote:
> Hi:
>
> On Sat, Feb 15, 2014 at 7:31 PM, Antman, Jason (CMG-Atlanta)
> wrote:
>> Well thanks for someone at least sending a reply, though I suppose I
>> should have asked "how do I do this", or "what are the
On 02/15/2014 01:22 PM, John R Pierce wrote:
> On 2/15/2014 10:15 AM, Antman, Jason (CMG-Atlanta) wrote:
>> I also asked this question on dba.stackexchange.com, where it
>> received a very detailed enumeration of the associated problems from
>> Craig Ringer:
>> h
postgres supports balooning of memory?
Thanks,
Jason
On 02/15/2014 01:20 PM, Tom Lane wrote:
> "Antman, Jason (CMG-Atlanta)" writes:
>> Perhaps there's a postgres internals expert around, someone intimitely
>> familiar with pg_xlog/pg_clog/pg_control, who can comment o
databases?
Thanks,
Jason
On 02/13/2014 04:41 PM, Antman, Jason (CMG-Atlanta) wrote:
I have a bunch of test/development databases which we currently refresh with
production data as-needed using a NetApp filer's snapshot capabilities - we
have a production slave with its datadir on a filer m
I have a bunch of test/development databases which we currently refresh with
production data as-needed using a NetApp filer's snapshot capabilities - we
have a production slave with its datadir on a filer mount (NFS), and once a
night (via cron) we shutdown the slave, snapshot the filer volume,
12 matches
Mail list logo