@ percusse is right:
Adding \pgfdeclarelayer{backgroundlayer}
in the correct place works.
PGF requires you to define any layer before you can use it.
\documentclass[landscape,a0paper, margin=9mm, innermargin=9mm,
blockverticalspace=14mm, colspace=12mm, subcolspace=0.1mm]{tikzposter}
\usepackage{tikz,pgfplots}
\begin{document}
\begin{block}{Title}{Text}
\begin{tikzpicture}[>=latex]
\pgfdeclarelayer{backgroundlayer}
\begin{pgfonlayer}{backgroundlayer}
\begin{axis}[%
width=20cm,height=20cm,
at={(0.803629in,0.513333in)},
scale only axis,
separate axis lines,
every outer x axis line/.append style={black},
every x tick label/.append style={font=\color{black}},
xmin=0,
xmax=25,
xtick={0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25},
xticklabels={{},{0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18},{19},{20},{21},{22},{23},{}},
xmajorgrids,
every outer y axis line/.append style={black},
every y tick label/.append style={font=\color{black}},
ymin=1300,
ymax=2000,
ytick={1300, 1800, 1900, 2000},
ymajorgrids
]
\addplot [color=red,solid,line width=4.0pt,mark size=10.0pt,mark=*,mark options={solid,fill=red},forget plot]
table[row sep=crcr]{%
1 1912\\
2 1895\\
3 1916\\
24 1878\\
};
\end{axis}
\end{pgfonlayer}
\end{tikzpicture}
\end{block}
\end{document}
I would suggest that you actually use PGFPlots, since you're already including it. Are you trying to do something like this?
\documentclass[tikz]{standalone}
\usepackage{pgfplots}
%why are you not using at least compat=1.3?
\pgfplotsset{compat=1.11}
\begin{document}
\begin{tikzpicture}[scale=10]
\begin{axis}[
xmin=0,
xmax=1,
ymin=0,
ymax=0.6,
xtick={0,0.1,...,1.1},
minor xtick={0.05,0.15,...,0.95},
ytick={0,0.1,...,0.6},
minor ytick={0.05,0.15,...,0.55},
]
\addplot[domain=0:1,samples=50] {(1+(x/(1-x)))/(sqrt(2*pi)*sqrt((x/(1-x))^2 +1))};
\addplot[] plot coordinates{(0,0.4) (1,0.4)};
\end{axis}
\end{tikzpicture}
\end{document}
Which produces this:
It is easy to change the ticks and such, if that is desired.
Best Answer
As others already mentioned, the floating point unit (FPU) shipped with PGF currently has no implementation of atan2 (it should get one; this is a bug).
A workaround is to configure
pgfplots
that it should not use the FPU. This works for the image in question (but is, in general, not recommended since it limits both data range + precision).