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

[#1]

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

[#2 · Accepted solution]

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

[#3]

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