question We have the postgres db crashes occasional. There is no dump. can we add the -c flag to the pg_ctl ? in Archives of Support Questions (Read Only)

We have the postgres db crashes occasional. There is no dump. can we add the -c flag to the pg_ctl ?

doronve — Mon, 11 May 2015 08:56:02 GMT

We have the postgres db crashes occasional.

There is no core dump.

Can we add the -c flag to the pg_ctl command in the /etc/init.d/cloudera-scm-server-db file?

$SU -c "pg_ctl start -c -w -D $DATA_DIR -l $SERVER_LOGFILE"

can we keep this change permanent?

Thanks

Doron

Re: We have the postgres db crashes occasional. There is no dump. can we add the -c flag to the pg_c

Darren — Tue, 12 May 2015 20:06:45 GMT

Hi Doron,

You can add the "-c" argument to the file in /etc/init.d if you like. You'll need to re-apply your fix when you upgrade CM.

Crashing isn't very common, so we don't plan to add this option by default to our script.

You can also consider moving to an independently managed postgresql database (or mysql or oracle), where you will have more control over these kinds of settings. The "embedded" postgresql db from cloudera-scm-server-db is not recommended for production.

Thanks,
Darren

Re: We have the postgres db crashes occasional. There is no dump. can we add the -c flag to the pg_c

doronve — Wed, 13 May 2015 12:49:01 GMT

Thanks

we'll do that.

i.e. - currently we'll add the flag under init.d

for the long run we'll create an alternative robust DB.

Doron