Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
Contributor

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

1 ACCEPTED SOLUTION

avatar
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

View solution in original post

2 REPLIES 2

avatar
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

avatar
Contributor

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