07/03/2019 20:27, Arjun Ranade ha scritto:
> > Hi all,
> >
> > I'm wondering if there's a tool like pgpool that can provide a single
> > origin point (host/port) that will proxy/direct connections to the
> > specific servers that contain the db needing to be access
Hi all,
I'm wondering if there's a tool like pgpool that can provide a single
origin point (host/port) that will proxy/direct connections to the specific
servers that contain the db needing to be accessed.
For example... lets say we had two databases: db1.company.com:5432 and
Pre-copying is not really an option since we could potentially need 1-X
instances so it needs to be scalable. XFS also allows for "cp --reflink"
which I could do on a PGDATA directory and then change the port number.
That's probably the method I'll try first.
We do use barman, but again a barman
I'm working on a project that requires on-demand creation of a fresh
database as quick as possible (seconds). Essentially, this is a build
server that will require a cloned instance of Postgres to run unit tests
on. So the pattern of use would be:
- Build is triggered
- New postgres
Will barman automatically do a delta restore assuming the postgres server
is stopped and the old cluster exists at the same location it's restoring
to?
On Tue, Feb 12, 2019 at 12:59 PM Stephen Frost wrote:
> Greetings,
>
> * Arjun Ranade (ran...@nodalexchange.com) wrote:
> > Yea
resumes midday after I’ve had enough time to find
> out if the backup was successful.
>
>
>
> *Scot Kreienkamp |Senior Systems Engineer | La-Z-Boy Corporate*
> One La-Z-Boy Drive| Monroe, Michigan 48162 | Office: 734-384-6403 | |
> Mobile: 7349151444 | Email: scot.kreienk...@l
I have a Production machine which is having objects
dropped/created/truncated at all hours of the day (Read: No zero activity
window). I have multiple standbys (repmgr streaming replication) for this
machine including a cascading standby. Each night, I am attempting to take
a logical backup on
