![]() WARNING: could not flush dirty data: Function not implemented 10:53:49.601 IST WARNING: could not flush dirty data: Function not implemented Postgres=# CREATE DATABASE appdb TEMPLATE template0 OWNER = postgres CONNECTION LIMIT = 150 # CREATE DATABASE appdb TEMPLATE template0 OWNER = postgres CONNECTION LIMIT = 150 There is another standard template database template0 but the content of this template database can not be modified. The content of this default template can be modified as needed, and any new databases created afterwards will have the same starting content as in this template database. When no additional options are given, the new database is created as a copy from the default template database template1. It defaults to false.Ĭonnect to psql prompt of the cluster and run the below command to create a database named testdb. IS_TEMPLATE – Specifies if the new database can be used as a template for another database.CONNECTION LIMIT – Maximum concurrent connections which can be made to this database. ![]() It defaults to the encoding of the template database. ENCODING – Character set encoding to use in the new database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |