On Mon, Sep 9, 2013 at 10:09 AM, Mike Christensen wrote:
> How about something incredibly cheesy like
>
> SELECT * FROM Mug;
>
I dig this. Black mug with this in white on one side, and a postgres logo
in white on the other side. I'd buy one...
One thing I have not seen discussed here is "Who is
ation
already in place. Previously, and still according to that article in the
wiki, the pg_xlog directory was specifically excluded. Does anyone know why
this behavior may have changed?
On Fri, Aug 9, 2013 at 9:33 AM, Quentin Hartman <
qhart...@direwolfdigital.com> wrote:
> This pair of
A bit of an aside, but you also might want to change that "CREATE EXTENSION
ltree;" to
"CREATE EXTENSION IF NOT EXISTS ltree;"
That way your script won't error out if the extension is already enabled.
On Fri, Aug 9, 2013 at 3:57 AM, Don Parris wrote:
> On Thu, Aug 8, 2013 at 8:42 PM, Tom Lane
aused by something not getting
overwritten when it was supposed to.
On Thu, Aug 8, 2013 at 6:23 PM, Michael Paquier
wrote:
> On Fri, Aug 9, 2013 at 8:55 AM, Quentin Hartman
> wrote:
> > 2013-08-08 23:47:30 GMT LOG: WAL file is from different database system
> > 2013-08-0
I'm going through all my usual steps for setting up streaming replication
on a new pair of servers. Modify configs as appropriate, rsync data from
master to slave, etc. I have this all automated with chef, and it has been
pretty bulletproof for awhile. However, today, I ran into this when
starting
Ah, that makes sense. I think I'll add some logic to the script that has it
get new data points if it comes up with a negative value.
Thanks for the insight.
QH
On Mon, Apr 22, 2013 at 5:11 PM, Andres Freund wrote:
> On 2013-04-22 16:36:38 -0600, Quentin Hartman wrote:
> >
I'm using this script to check my replication lag on my streaming
replication pairs with Nagios:
https://gist.github.com/jacobian/743942
It generally works fine, but will occasionally return a negative lag value
(-37kb for example) which of course causes it to throw an alarm, but is
total nonsens
What version of pgpool are you using?
Are there other commands you have a problem with? I would suspect that the
restart is causing the postgres server to go away, pgpool decides to
disconnect, and then it has to be manually added back to the cluster.
Unless of course you've got automatic failback
Also, Packt has a deal on their site where if you buy 2 ebooks, you get
them both for half off. This one seems to qualify, so I Was able to get it
for $3, while also getting another book I've been wanting for half what I
was expecting to pay.
Hooray!
QH
On Fri, Mar 29, 2013 at 10:50 AM, Tom Lane wrote:
> Quentin Hartman writes:
> > On Fri, Mar 29, 2013 at 10:37 AM, Tom Lane wrote:
> >> What process did you use for setting up the slave?
>
> > I used an rsync from the master while both were stopped.
>
> If the
On Fri, Mar 29, 2013 at 10:37 AM, Tom Lane wrote:
> Quentin Hartman writes:
> > Yesterday morning, one of my streaming replication slaves running 9.2.3
> > crashed with the following in the log file:
>
> What process did you use for setting up the slave?
>
I used an rsy
On Fri, Mar 29, 2013 at 10:23 AM, Lonni J Friedman wrote:
> Looks like you've got some form of coruption:
> page 1441792 of relation base/63229/63370 does not exist
>
Thanks for the insight. I thought that might be it, but never having seen
this before I'm glad to have some confirmation.
The que
Yesterday morning, one of my streaming replication slaves running 9.2.3
crashed with the following in the log file:
2013-03-28 12:49:30 GMT WARNING: page 1441792 of relation base/63229/63370
does not exist
2013-03-28 12:49:30 GMT CONTEXT: xlog redo delete: index
1663/63229/109956; iblk 303, heap
13 matches
Mail list logo