the idea of just restoring the filesystem
dump.
so, the question becomes, if i restore a filesystem snapshot backup, the
DB will be in a 'crashed' state.
what, if any, risks are there with regards to corruption, or the inability to
actually use the restored DB?
--
Jim Mercer Reptilian R
f using these functions both for
a backup and a restore?
--
Jim Mercer Reptilian Research j...@reptiles.org+1 416 410-5633
"He who dies with the most toys is nonetheless dead"
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your sub
he old jail whe the next upgrade is complete.
repeat as often as you want to upgrade.
i'm pretty sure this can be adapted to linux, but i forget what their jail
equivilent is.
the overhead is minimal
--
Jim Mercer Reptilian Research j...@reptiles.org+1 416 410-5633
"H
On Wed, May 01, 2013 at 02:21:44PM -0600, Benjamin Krajmalnik wrote:
> So essentially we would have to run jails on this - does that affect
> performance?
i would say minimal impact.
>
>
> -Original Message-----
> From: Jim Mercer [mailto:j...@reptiles.org]
> Sent: We
d.
--jim
>
>
>
>
>
> From: Gezeala M. Bacu?o II [mailto:geze...@gmail.com]
> Sent: Wednesday, May 01, 2013 3:38 PM
> To: Jim Mercer
> Cc: Benjamin Krajmalnik; pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Installing multiple instances of Postgred on one FreeBSD
>
e of users/uids is moot, since the jail is independent of the main
system.
assuming you configure the base system to listen only on its own IP, installing
on the jail, is no different than installing on a normal system.
--jim
>
> On ?? 01 ?? 2013 16:24:01 Jim Mercer wrote:
> >
ostgresql
> >> received
> >> a SIGHUP to reload configuration.
> >>
> >>
> >> Sounds like some sysadmin scripted rsync gone wild.
> >>
> >
> >
--
Jim Mercer Reptilian Research j...@reptiles.org+1 416 410-5633
"He w
s seem to think it's OK to quote five pages
> of someone else's response, then add one or two sentences at the bottom ...
i find that top posting is far more prevalent than bottom posting, but
both are just signs of laziness.
--jim
--
Jim Mercer Reptilian Research j...@re
rritated.
bottom posts, i'll generally skip because the author obviously doesn't value
their own words.
--jim
--
Jim Mercer Reptilian Research j...@reptiles.org+1 416 410-5633
"He who dies with the most toys is nonetheless dead"
--
Sent via pgsql-admin m
ad
mailing lists, newsgroups, forums, RSS, etc.
spending a little time to clean up your message, making it terse, but not
cryptic, will go a long way to preventing people from thinking you are a
dumbass.
8^)
--jim
--
Jim Mercer Reptilian Research j...@reptiles.org+1 416 410-5633
"
t on my magic email
ettiquette hat, and spend significant amounts of time formatting my responses,
precisely so that you feel the full brunt of my anger.
yeah, that makes sense.
8^(
--
Jim Mercer Reptilian Research j...@reptiles.org+1 416 410-5633
"He who dies with the most toys i
ook a few tweaks and hacks to make it robust.
however, that was years ago.
jails have evolved into a well thought out virtual kernel environment.
ah, here you go, some stuff about setting up pgsql in a FreeBSD jail:
http://forums.freebsd.org/showthread.php?t=23114
--
Jim Mercer Reptilian Re
> there have been also some rather "warm" discussions here in these very lists.
i'm relatively new to the pgsql lists (although i've been using pgsql since
at least the mid-90's).
--jim
--
Jim Mercer Reptilian Research j...@reptiles.org+1 416 410-5633
&quo
13 matches
Mail list logo
