<div dir="ltr"><div class="gmail_extra"><br><div class="gmail_quote">2016-03-09 19:59 GMT+01:00 Michael Cronenworth <span dir="ltr"><<a href="mailto:mike@cchtml.com" target="_blank">mike@cchtml.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><span class="">On 03/09/2016 12:18 PM, Suvayu Ali wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
I want to create a PostgreSQL db. So I did the following:<br>
<br>
$ su -<br>
# su - postgres<br>
$ pg_ctl initdb -D /var/lib/pgsql/data<br>
</blockquote>
<br></span>
For future reference there is a helper script that can do this stuff for you.<br>
<br>
# postgresql-setup --init-db<br>
<br></blockquote><div><br></div><div>I would pass <span style="color:rgb(0,0,0);font-family:monospace;font-size:12.844px">--data-checksums </span>to initdb<font face="arial, helvetica, sans-serif"> to <span style="color:rgb(0,0,0);font-size:12.7px;line-height:19.05px">checksum the data pages and report eventual corruption.</span></font></div><div><font face="arial, helvetica, sans-serif"><span style="color:rgb(0,0,0);font-size:12.7px;line-height:19.05px"><br></span></font></div><div><font face="arial, helvetica, sans-serif"><span style="color:rgb(0,0,0);font-size:12.7px;line-height:19.05px">-- john</span></font></div></div></div></div>