reset password
Author Message
raylongma1018
Posts: 81
Posted 13:57 Jul 06, 2015 |

Hi Dr.Sun:

When we try to create a new database table from postgre. Is it ok to delete the default database name "postgre", so our database will only contain "csjobs"

Also when we try to add a new login role, is it ok to delete the default login rule "postgre" so we only have the "csjobs" as our login name?

cysun
Posts: 2935
Posted 14:02 Jul 06, 2015 |

It's OK to delete the postgres database, though I wouldn't recommend it as it's the default database for the postgres user.

It's OK to delete the postgres user but only if you have another superuser, because otherwise you won't be able to create new database or user.

I'd recommend that you keep both because there's really no benefit to delete them.